SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | GHO_PP_PT_PROFIL
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6BSEG345Accounting Document Segment
7/ISDFPS/CHVW_E34External Batch Where-Used List
8FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6OPCH386A/P Invoice
7INV1265A/R Invoice - Rows
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINM101Whse Journal
4OINV268A/R Invoice
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Production Planning and Control :: Production Network :: Network Operations
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0GHO_PP_PT_PROFIL501Customizing: Table for GHO Planning Table ProfileNetwork Operations
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT CLIENT, PROFILE, PERIOD_DEFAULT, ABS_PLAN_HORIZON, REL_PLAN_HORIZON, DATE_FROM, DATE_TO, PERIOD_FROM, PERIOD_TO, PLANNED_VALUES, ACTUAL_VALUES, COMPARE_VERSIONS, TOP_DOWN, BOTTOM_UP, ALL_OBJECTS, HIDE_TOP_DO_VIEW, HIDE_BOT_UP_VIEW, HIDE_ALLOBJ_VIEW, EXPAND_LEVELS, SEL_NETOBJ_ID, SEL_NETOBJ_DESC, SEL_MAT_ID, SEL_MAT_DESC, SEL_MEDIUM, TOL_FROM_G1, TOL_TO_G1, TOL_FROM_Y1, TOL_TO_Y1, TOL_FROM_R1, TOL_TO_R1, TOL_FROM_G2, TOL_TO_G2, TOL_FROM_Y2, TOL_TO_Y2, TOL_FROM_R2, TOL_TO_R2, TOL_FROM_G3, TOL_TO_G3, TOL_FROM_Y3, TOL_TO_Y3, TOL_FROM_R3, TOL_TO_R3, DIS_EQUAL_TOTAL, DIS_EQUAL_DIFF, DIS_PROP, DIFF_DISPLAY, HIST_PLAN, HIST_ALLOC, COMP_PLAN, COMP_ALLOC FROM GHO_PP_PT_PROFIL
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2PROFILEPlanning Table Profilenvarchar120CHAR(N' ')NoGHO_PP_PT_PROFILE Allow NULL? 
3PERIOD_DEFAULTPT Profile: Default Planning Horizon Periodnvarchar20CHAR(N' ')YesGHO_PP_PERIOD Allow NULL? 
4ABS_PLAN_HORIZONCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
5REL_PLAN_HORIZONCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
6DATE_FROMPT Profile: Planning Horizon (From)nvarchar80DATS(N'00000000')YesGHO_PP_DATE_FROM Allow NULL? 
7DATE_TOPT Profile: Planning Horizon (To)nvarchar80DATS(N'00000000')YesGHO_PP_DATE_TO Allow NULL? 
8PERIOD_FROMPT Profile: Planning Horizon (From)decimal20DEC((0))YesGHO_PP_PERIOD_BACK
9PERIOD_TOPT Profile: Planning Horizon (To)decimal20DEC((0))YesGHO_PP_PERIOD_FORWARD
10PLANNED_VALUESCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
11ACTUAL_VALUESCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
12COMPARE_VERSIONSCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
13TOP_DOWNCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
14BOTTOM_UPCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
15ALL_OBJECTSCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
16HIDE_TOP_DO_VIEWPT Profile Checkbox: Hide Top Down View (Planning Subview)char10CHAR(N' ')YesGHO_PP_HIDE_TOP_DOWN_VIEW Allow NULL? 
17HIDE_BOT_UP_VIEWPT Profile Checkbox: Hide Bottom Up View (Planning Subview)char10CHAR(N' ')YesGHO_PP_HIDE_BOTTOM_UP_VIEW Allow NULL? 
18HIDE_ALLOBJ_VIEWPT Profile: Hide All Planning Relevant Objects Viewchar10CHAR(N' ')YesGHO_PP_HIDE_ALL_OBJ_VIEW Allow NULL? 
19EXPAND_LEVELSPT Profile: Expand Level of Hierarchynvarchar20CHAR(N' ')YesGHO_PP_EXPAND_LEVELS Allow NULL? 
20SEL_NETOBJ_IDPT Profile Checkbox: Network Object IDchar10CHAR(N' ')YesGHO_PP_SEL_NETOBJ_ID Allow NULL? 
21SEL_NETOBJ_DESCPT Profile Checkbox: Network Object Descriptionchar10CHAR(N' ')YesGHO_PP_SEL_NETOBJ_DESC Allow NULL? 
22SEL_MAT_IDPT Profile Checkbox: Material IDchar10CHAR(N' ')YesGHO_PP_SEL_MATERIAL_ID Allow NULL? 
23SEL_MAT_DESCPT Profile Checkbox: Material Descriptionchar10CHAR(N' ')YesGHO_PP_SEL_MATERIAL_DESC Allow NULL? 
24SEL_MEDIUMPT Profile Checkbox: Mediumchar10CHAR(N' ')YesGHO_PP_SEL_MEDIUM Allow NULL? 
25TOL_FROM_G1PT Profile:Green Tolerance f.Planned/Allocation Values(From)decimal31DEC((0))YesGHO_PP_TOL_FROM_G1
26TOL_TO_G1PT Profile:Green Tolerance for Planned/Allocation Values(To)decimal31DEC((0))YesGHO_PP_TOL_TO_G1
27TOL_FROM_Y1PT Profile:Yellow Tolerance f.Planned/Allocation Values Fromdecimal31DEC((0))YesGHO_PP_TOL_FROM_Y1
28TOL_TO_Y1PT Profile:Yellow Tolerance f.Planned/Allocation Values (To)decimal31DEC((0))YesGHO_PP_TOL_TO_Y1
29TOL_FROM_R1PT Profile: Red Tolerance f.Planned/Allocation Values (From)decimal31DEC((0))YesGHO_PP_TOL_FROM_R1
30TOL_TO_R1PT Profile: Red Tolerance for Planned/Allocation Values (To)decimal31DEC((0))YesGHO_PP_TOL_TO_R1
31TOL_FROM_G2PT Profile: Green Tolerance for Planned/Actual Values (From)decimal31DEC((0))YesGHO_PP_TOL_FROM_G2
32TOL_TO_G2PT Profile: Green Tolerance for Planned/Actual Values (To)decimal31DEC((0))YesGHO_PP_TOL_TO_G2
33TOL_FROM_Y2PT Profile: Yellow Tolerance for Planned/Actual Values(From)decimal31DEC((0))YesGHO_PP_TOL_FROM_Y2
34TOL_TO_Y2PT Profile: Yellow Tolerance for Planned/Actual Values (To)decimal31DEC((0))YesGHO_PP_TOL_TO_Y2
35TOL_FROM_R2PT Profile: Red Tolerance for Planned/Actual Values (From)decimal31DEC((0))YesGHO_PP_TOL_FROM_R2
36TOL_TO_R2PT Profile: Red Tolerance for Planned/Actual Values (To)decimal31DEC((0))YesGHO_PP_TOL_TO_R2
37TOL_FROM_G3PT Profile: Green Tolerance f.Actual/Allocation Values(From)decimal31DEC((0))YesGHO_PP_TOL_FROM_G3
38TOL_TO_G3PT Profile: Green Tolerance for Actual/Allocation Values(To)decimal31DEC((0))YesGHO_PP_TOL_TO_G3
39TOL_FROM_Y3PT Profile:Yellow Tolerance f.Actual/Allocation Values(From)decimal31DEC((0))YesGHO_PP_TOL_FROM_Y3
40TOL_TO_Y3PT Profile:Yellow Tolerance for Actual/Allocation Values(To)decimal31DEC((0))YesGHO_PP_TOL_TO_Y3
41TOL_FROM_R3PT Profile: Red Tolerance for Actual/Allocation Values(From)decimal31DEC((0))YesGHO_PP_TOL_FROM_R3
42TOL_TO_R3PT Profile: Red Tolerance for Actual/Allocation Values (To)decimal31DEC((0))YesGHO_PP_TOL_TO_R3
43DIS_EQUAL_TOTALDistribution Mode: Equal Distribution of Total Quantitieschar10CHAR(N' ')YesGHO_PP_EQUAL_DIS_TOTAL Allow NULL? 
44DIS_EQUAL_DIFFDistribution Mode: Equal Distribution of Total Quantitieschar10CHAR(N' ')YesGHO_PP_EQUAL_DIS_DIFF Allow NULL? 
45DIS_PROPDistribution Mode: Proportional Distributionchar10CHAR(N' ')YesGHO_PP_PROP_DIS Allow NULL? 
46DIFF_DISPLAYDifference display for quantity fieldsnvarchar20CHAR(N' ')YesGHO_PP_DIFF_DISPLAY Allow NULL? 
47HIST_PLANHistory View: Compare with Planned Quantitieschar10CHAR(N' ')YesGHO_PP_HISTORY_PLAN Allow NULL? 
48HIST_ALLOCHistory View: Compare with Allocated Quantitieschar10CHAR(N' ')YesGHO_PP_HISTORY_ALLOC Allow NULL? 
49COMP_PLANComparison View: Compare with Planned Quantitieschar10CHAR(N' ')YesGHO_PP_COMP_PLAN Allow NULL? 
50COMP_ALLOCComparison View: Compare with Allocated Quantitieschar10CHAR(N' ')YesGHO_PP_COMP_ALLOC Allow NULL? 
NamePrimaryUniqueTypeColumns
GHO_PP_PT_PROFIL~0YesYesCLUSTEREDPROFILE, CLIENT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy