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 
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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

131 columns | Print definition?ERP 6.0  | COND_GROUP_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CN/CBPSAP001Vendor/product11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
2/1CN/CBPSAP016Contract Item10COND_GROUP_IDID of Group of Condition Recordsvarbinary160
3/1CN/CBPSAP019Contract Header10COND_GROUP_IDID of Group of Condition Recordsvarbinary160
4/1CN/CBPSAP068Location-Dependent11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
5/1CN/CBPSAP118Product10COND_GROUP_IDID of Group of Condition Recordsvarbinary160
6/1CN/CMFSAPH0FORPrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr14COND_GROUP_IDID of Group of Condition Recordsvarbinary160
7/1CN/CMFSAPH1FDTPrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr14COND_GROUP_IDID of Group of Condition Recordsvarbinary160
8/1CN/CMFSAPH1FFXPrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr14COND_GROUP_IDID of Group of Condition Recordsvarbinary160
9/1CN/CMFSAPH2TGRPrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.15COND_GROUP_IDID of Group of Condition Recordsvarbinary160
10/1CN/CMFSAPH2TRMPrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.15COND_GROUP_IDID of Group of Condition Recordsvarbinary160
11/1CN/CMFSAPH3TCTPrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.15COND_GROUP_IDID of Group of Condition Recordsvarbinary160
12/1CN/CMFSAPH3TUSPrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.15COND_GROUP_IDID of Group of Condition Recordsvarbinary160
13/1CN/CMFSAPH4TFXPrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.15COND_GROUP_IDID of Group of Condition Recordsvarbinary160
14/1CN/CMFSAPH4TQUPrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.15COND_GROUP_IDID of Group of Condition Recordsvarbinary160
15/1CN/CMFSAPH4TRFPrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.15COND_GROUP_IDID of Group of Condition Recordsvarbinary160
16/1CN/CMFSAPH4TRUPrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.15COND_GROUP_IDID of Group of Condition Recordsvarbinary160
17/1CN/CMFSAPH5TCRPrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.15COND_GROUP_IDID of Group of Condition Recordsvarbinary160
18/1CN/CMFSAPH5TPCPrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.15COND_GROUP_IDID of Group of Condition Recordsvarbinary160
19/1CN/CMFSAPH5TPQPrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.15COND_GROUP_IDID of Group of Condition Recordsvarbinary160
20/1CN/CMFSAPH5TSUPrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.15COND_GROUP_IDID of Group of Condition Recordsvarbinary160
21/1CN/CMFSAPI0FORCondition Table18COND_GROUP_IDID of Group of Condition Recordsvarbinary160
22/1CN/CMFSAPI0MSTCPE Condition Table: Formula Key for Stock Exposure13COND_GROUP_IDID of Group of Condition Recordsvarbinary160
23/1CN/CMFSAPI1FDTCondition Table18COND_GROUP_IDID of Group of Condition Recordsvarbinary160
24/1CN/CMFSAPI1FFXCondition Table18COND_GROUP_IDID of Group of Condition Recordsvarbinary160
25/1CN/CMFSAPI2TGRCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
26/1CN/CMFSAPI2TRMCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
27/1CN/CMFSAPI3TCTCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
28/1CN/CMFSAPI3TUSCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
29/1CN/CMFSAPI4TFXCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
30/1CN/CMFSAPI4TQUCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
31/1CN/CMFSAPI4TRFCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
32/1CN/CMFSAPI4TRUCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
33/1CN/CMFSAPI5TCRCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
34/1CN/CMFSAPI5TPCCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
35/1CN/CMFSAPI5TPQCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
36/1CN/CMFSAPI5TSUCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
37/1CN/CMFZ_INCOCPE Condition Table: Formula Key (Item)15COND_GROUP_IDID of Group of Condition Recordsvarbinary160
38/1CN/CPASAP00001Input Product10COND_GROUP_IDID of Group of Condition Recordsvarbinary160
39/1CN/CPNSAP00001Business Partner/Product (GUID)11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
40/1CN/CPTSAP00001Business Partner/Product Group11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
41/1CN/CPTSAP00004Business Partner/Product GUID11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
42/1CN/CPTSAP00005Business Partner/Product Group/Product GUID12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
43/1CN/CPTSAP00006Business Partner10COND_GROUP_IDID of Group of Condition Recordsvarbinary160
44/1CN/CRMSAP_CARRAirline10COND_GROUP_IDID of Group of Condition Recordsvarbinary160
45/1CN/CRMSAP_CONNAirline/Connection Number11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
46/1CN/CRMSAP_PARTCustomer ID10COND_GROUP_IDID of Group of Condition Recordsvarbinary160
47/1CN/CTXSAPD0001Country/Cost Center/Product Usage12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
48/1CN/CTXSAPD0002Country/Order/Product Usage12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
49/1CN/CTXSAPD0003Country/Product Usage11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
50/1CN/CTXSAPD0004Country10COND_GROUP_IDID of Group of Condition Recordsvarbinary160
51/1CN/CTXSAPD0201Country/Tax Code11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
52/1CN/CTXSAPR0100Country/Product Tax Group/Business Partner Tax Group12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
53/1CN/CTXSAPR0103Country/Product Tax Group11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
54/1CN/CTXSAPR0104Country10COND_GROUP_IDID of Group of Condition Recordsvarbinary160
55/1CN/CTXSAPR0105Country/Tax Event11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
56/1CN/CTXSAPR0106Country/Region/Product Tax Group/Business Partner Tax Group13COND_GROUP_IDID of Group of Condition Recordsvarbinary160
57/1CN/CTXSAPR0107Country/Tax Event/ST Jurisdiction Code12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
58/1CN/CTXSAPR0108Country/Region/Product Tax Group12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
59/1CN/CTXSAPR0110Country/1L Sppl.Jur.Code/1L Rec.Jur.Code12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
60/1CN/CTXSAPR0111Country/2L Sppl.Jur.Code/2L Rec.Jur.Code12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
61/1CN/CTXSAPR0112Country/2L Sppl.Jur.Code/2L Rec.Jur.Code/Tax Tariff Code13COND_GROUP_IDID of Group of Condition Recordsvarbinary160
62/1CN/CTXSAPR0113Country/2L Sppl.Jur.Code/2L Rec.Jur.Code/Product Tax Group13COND_GROUP_IDID of Group of Condition Recordsvarbinary160
63/1CN/CTXSAPR0120Country/Tax Tariff Code11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
64/1CN/CTXSAPR0130Country/3L Jur.Code11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
65/1CN/CTXSAPR0131Country/3L Jur.Code/Product Tax Group12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
66/1CN/CTXSAPR0140Country/Tax Event/Jurisdiction Code12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
67/1CN/CTXSAPR0201Country/Tax Code11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
68/1CN/CTXSAPRBR01Country/Tax Tariff Code11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
69/1CN/CTXSAPRBR02Country/Product Tax Group11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
70/1CN/CTXSAPRBR03Country/Product Tax Group/Business Partner Tax Group12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
71/1CN/CTXSAPRBR10Country/1L Sppl.Jur.Code/1L Rec.Jur.Code12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
72/1CN/CTXSAPRBR11Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Tax Tariff Code13COND_GROUP_IDID of Group of Condition Recordsvarbinary160
73/1CN/CTXSAPRBR12Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Product Tax Group13COND_GROUP_IDID of Group of Condition Recordsvarbinary160
74/1CN/CTXSAPRBR20Country/2L Jur.Code11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
75/1CN/CTXSAPRBR21Country/2L Jur.Code/Product Tax Group12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
76/1CN/CTXSAPRIN03Country/Tax Tariff Code/Business Partner ID12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
77/1CN/CTXSAPRIN04Recipient Country/Tax Tariff Code/Business Partner ID12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
78/1CN/CTXSAPRIN06Country/Spl Reg./Rec Region/Tax Group/Tax Group14COND_GROUP_IDID of Group of Condition Recordsvarbinary160
79/1CN/CTXSAPRIN07Country/Partner ID/Recip. Tax Region/Tax Group13COND_GROUP_IDID of Group of Condition Recordsvarbinary160
80/1CN/CTXSAPS0100Country/Business Process11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
81/1CN/CTXSAPS0101Country/Bus. Transaction11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
82/1CN/CTXSAPS0102Country/Bus. Transaction11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
83/1CN/CTXSAPW0201Country/Tax Code11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
84/1CN/CTXSAPW0202Country/Business Partner Tax Group11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
85/1CN/CTXSAPX0100Country/Region11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
86/1CN/CTXSAPX0101Country/Supplier BP ID/Business Partner ID12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
87/1CN/CTXSAPX0102Country/Business Partner Tax Group11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
88/1CN/CTXSAPX0103Country/Supplier BP ID/Business Partner ID/Product Tax Group13COND_GROUP_IDID of Group of Condition Recordsvarbinary160
89/1CN/CTXSAPX0104Recipient Country/Recipient Tax Region/Locat. Relationship12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
90/1CN/CTXSAPX0105Country/Product Tax Group11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
91/1CN/CTXSAPX0106Country/Region/Product Tax Group12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
92/1CN/CTXSAPX0140Country/Product Tax Group/Jurisdiction Code12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
93/1CN/CTXSAPX0141Country/Business Partner Tax Group/Jurisdiction Code12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
94/1CN/CTXSAPX0146Country/Region/Product Tax Group12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
95/1CN/CTXSAPX0147Country/Region/Business Partner Tax Group12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
96/1CN/CTXSAPX0148Country10COND_GROUP_IDID of Group of Condition Recordsvarbinary160
97/1CN/CTXSAPXBR01Country/Tax Tariff Code11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
98/1CN/CTXSAPXBR02Country/Product Tax Group11COND_GROUP_IDID of Group of Condition Recordsvarbinary160
99/1CN/CTXSAPXBR03Country/Product Tax Group/Business Partner Tax Group12COND_GROUP_IDID of Group of Condition Recordsvarbinary160
100/1CN/CTXSAPXBR11Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Tax Tariff Code13COND_GROUP_IDID of Group of Condition Recordsvarbinary160
101/1CN/CVFSAPH0FORCondition Table16COND_GROUP_IDID of Group of Condition Recordsvarbinary160
102/1CN/CVFSAPH1FDTCondition Table16COND_GROUP_IDID of Group of Condition Recordsvarbinary160
103/1CN/CVFSAPH1FFXCondition Table16COND_GROUP_IDID of Group of Condition Recordsvarbinary160
104/1CN/CVFSAPH2TGRCondition Table17COND_GROUP_IDID of Group of Condition Recordsvarbinary160
105/1CN/CVFSAPH2TRMCondition Table17COND_GROUP_IDID of Group of Condition Recordsvarbinary160
106/1CN/CVFSAPH3TCTCondition Table17COND_GROUP_IDID of Group of Condition Recordsvarbinary160
107/1CN/CVFSAPH3TUSCondition Table17COND_GROUP_IDID of Group of Condition Recordsvarbinary160
108/1CN/CVFSAPH4TFXCondition Table17COND_GROUP_IDID of Group of Condition Recordsvarbinary160
109/1CN/CVFSAPH4TQUCondition Table17COND_GROUP_IDID of Group of Condition Recordsvarbinary160
110/1CN/CVFSAPH4TRFCondition Table17COND_GROUP_IDID of Group of Condition Recordsvarbinary160
111/1CN/CVFSAPH4TRUCondition Table17COND_GROUP_IDID of Group of Condition Recordsvarbinary160
112/1CN/CVFSAPH5TCRCondition Table17COND_GROUP_IDID of Group of Condition Recordsvarbinary160
113/1CN/CVFSAPH5TPCCondition Table17COND_GROUP_IDID of Group of Condition Recordsvarbinary160
114/1CN/CVFSAPH5TPQCondition Table17COND_GROUP_IDID of Group of Condition Recordsvarbinary160
115/1CN/CVFSAPH5TSUCondition Table17COND_GROUP_IDID of Group of Condition Recordsvarbinary160
116/1CN/CVFSAPI0FORCondition Table18COND_GROUP_IDID of Group of Condition Recordsvarbinary160
117/1CN/CVFSAPI1FDTCondition Table18COND_GROUP_IDID of Group of Condition Recordsvarbinary160
118/1CN/CVFSAPI1FFXCondition Table18COND_GROUP_IDID of Group of Condition Recordsvarbinary160
119/1CN/CVFSAPI2TGRCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
120/1CN/CVFSAPI2TRMCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
121/1CN/CVFSAPI3TCTCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
122/1CN/CVFSAPI3TUSCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
123/1CN/CVFSAPI4TFXCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
124/1CN/CVFSAPI4TQUCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
125/1CN/CVFSAPI4TRFCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
126/1CN/CVFSAPI4TRUCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
127/1CN/CVFSAPI5TCRCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
128/1CN/CVFSAPI5TPCCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
129/1CN/CVFSAPI5TPQCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
130/1CN/CVFSAPI5TSUCondition Table19COND_GROUP_IDID of Group of Condition Recordsvarbinary160
TOPPricing
131PRCM_TABL_000Reference Table for Condition Tables (A000)10COND_GROUP_IDID of Group of Condition Recordsvarbinary160

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