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

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

148 columns | Print definition?ERP 6.0  | KBSTAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1A501ServcAgent/Incoterms9KBSTATProcessing status for conditionsnvarchar20
2A514ServcAgent/Ship.type9KBSTATProcessing status for conditionsnvarchar20
3A519ServcAgent/Suppl. 39KBSTATProcessing status for conditionsnvarchar20
4A589Sales org./Distr. Chl/Matl Group/Material11KBSTATProcessing status for conditionsnvarchar20
5A615Condition Table for Pricing A61511KBSTATProcessing status for conditionsnvarchar20
6A616Condition Table for Pricing A6168KBSTATProcessing status for conditionsnvarchar20
7A619Condition Table for Pricing A6199KBSTATProcessing status for conditionsnvarchar20
8A620Condition Table for Pricing A6209KBSTATProcessing status for conditionsnvarchar20
9A634Camp. ID/Material9KBSTATProcessing status for conditionsnvarchar20
10A635Camp. ID/PH1/PH2/PH311KBSTATProcessing status for conditionsnvarchar20
11A636Camp. ID/Matl grp 19KBSTATProcessing status for conditionsnvarchar20
12A637Camp. ID8KBSTATProcessing status for conditionsnvarchar20
13A640Sales org./Distr. Chl/Customer/Material/Grid Value12KBSTATProcessing status for conditionsnvarchar20
14A641Sales org./Distr. Chl/Material/Grid Value11KBSTATProcessing status for conditionsnvarchar20
15A651Camp. ID/Material9KBSTATProcessing status for conditionsnvarchar20
16A652Camp. ID/PH1/PH2/PH311KBSTATProcessing status for conditionsnvarchar20
17A653Camp. ID/Matl grp 19KBSTATProcessing status for conditionsnvarchar20
18A700Sales org./Distr. Chl/Material/Product ID/Customer12KBSTATProcessing status for conditionsnvarchar20
19A701Distr. Chl/Material/Product ID11KBSTATProcessing status for conditionsnvarchar20
20A702Sales org./Distr. Chl/Material/Product ID11KBSTATProcessing status for conditionsnvarchar20
21A706Distr. Chl/Material/Product ID/Customer12KBSTATProcessing status for conditionsnvarchar20
22A707Sales org./Distr. Chl/TG/Material11KBSTATProcessing status for conditionsnvarchar20
23A710Surcharge/TradeLane/ServiceType/ContainerTypeSize11KBSTATProcessing status for conditionsnvarchar20
24A711Surcharge/TradeLane/ServiceType/POL/ContainerTypeSize12KBSTATProcessing status for conditionsnvarchar20
25A712Surcharge/TradeLane/ServiceType/POD/ContainerTypeSize12KBSTATProcessing status for conditionsnvarchar20
26A720Trade Lane/POR - City/POD - City/ServiceType/Cont.TypeSize12KBSTATProcessing status for conditionsnvarchar20
27A721TradeLane/POR-Countr/POD-Countr/ServiceType/Cont.TypeSize12KBSTATProcessing status for conditionsnvarchar20
28A722TradeLane/POR - City/POD-Countr/ServiceType/Cont.TypeSize12KBSTATProcessing status for conditionsnvarchar20
29A723TradeLane/POR-Countr/POD - City/ServiceType/Cont.TypeSize12KBSTATProcessing status for conditionsnvarchar20
30A724TradeLane/POL/POD/ServiceType/Cont.TypeSize12KBSTATProcessing status for conditionsnvarchar20
31A730TradeLane/ServiceType/ContainerTypeSize10KBSTATProcessing status for conditionsnvarchar20
32A731TradeLane/ServiceType/POL/ContainerTypeSize11KBSTATProcessing status for conditionsnvarchar20
33A732TradeLane/ServiceType/POD/ContainerTypeSize11KBSTATProcessing status for conditionsnvarchar20
34A911MProjectID/Material/Sales org.10KBSTATProcessing status for conditionsnvarchar20
35A913Material/Customer/Sales org.10KBSTATProcessing status for conditionsnvarchar20
36A914Sales org./Material9KBSTATProcessing status for conditionsnvarchar20
37A925Camp. ID/Shpg Cond.9KBSTATProcessing status for conditionsnvarchar20
38A926Tax code8KBSTATProcessing status for conditionsnvarchar20
39A927Plant8KBSTATProcessing status for conditionsnvarchar20
40A928Ctrl code8KBSTATProcessing status for conditionsnvarchar20
41A944Sales org./Distr. Chl/Mat.pr.grp/Shp.Cond.11KBSTATProcessing status for conditionsnvarchar20
42A945Sales org./Distr. Chl/Shp.Cond./Dest. Ctry/Region12KBSTATProcessing status for conditionsnvarchar20
43A946Sales org./Distr. Chl/TG10KBSTATProcessing status for conditionsnvarchar20
44A947Sales Org/Distr.Channel/Shipping Conditions10KBSTATProcessing status for conditionsnvarchar20
45A950Sales org./Distr. Chl/Customer/PH1/PH2/PH313KBSTATProcessing status for conditionsnvarchar20
46A951Sales org./Distr. Chl/HierarchyNode/Material11KBSTATProcessing status for conditionsnvarchar20
47A952Sales org./Distr. Chl/HierarchyNode/PH1/PH2/PH313KBSTATProcessing status for conditionsnvarchar20
48A960Sales org./Distr. Chl/Shp.Cond./Dest. Ctry/Region12KBSTATProcessing status for conditionsnvarchar20
49A963Sales Org/Distr.Channel/Shipping Conditions10KBSTATProcessing status for conditionsnvarchar20
50A965Country/Plant/TaxCl.Mat/TaxCl1Cust11KBSTATProcessing status for conditionsnvarchar20
51A966Country/Plant/TaxCl.2Mat/TaxCl2Cust11KBSTATProcessing status for conditionsnvarchar20
52A967Material/Plant9KBSTATProcessing status for conditionsnvarchar20
53A968Material/Plant/Ship-to10KBSTATProcessing status for conditionsnvarchar20
54A969Sales org./Distr. Chl/Division/Customer11KBSTATProcessing status for conditionsnvarchar20
55A990CoCode/Dest. Ctry/Material10KBSTATProcessing status for conditionsnvarchar20
56A996Sales org./Distr. Chl/Shp.Cond./TG11KBSTATProcessing status for conditionsnvarchar20
57A999Camp. ID/Sales org./Distr. Chl/Division/Material12KBSTATProcessing status for conditionsnvarchar20
TOPChargeback
58A163Number/Material9KBSTATProcessing status for conditionsnvarchar20
TOPCondition Technique
59/SAPCND/T686ECondition Processing Status2KBSTATEditing statusnvarchar20
60/SAPCND/T686FText Processing Status2KBSTATEditing statusnvarchar20
TOPConditions
61A304Material with release status10KBSTATProcessing status for conditionsnvarchar20
62A305Customer/material with release status11KBSTATProcessing status for conditionsnvarchar20
63A306Price list category/currency/material with release status12KBSTATProcessing status for conditionsnvarchar20
64A307Customer with Release Status10KBSTATProcessing status for conditionsnvarchar20
65A350Sales org.8KBSTATProcessing status for conditionsnvarchar20
66A352ST Code/Post.code/PlntRegion10KBSTATProcessing status for conditionsnvarchar20
67A353ST Code/Region/PlntRegion10KBSTATProcessing status for conditionsnvarchar20
68A354Country/Region/PlntRegion10KBSTATProcessing status for conditionsnvarchar20
69A355Jur. code8KBSTATProcessing status for conditionsnvarchar20
70A356Country/PlntRegion/ST Code/TaxCl1Cust/TaxCl.Mat12KBSTATProcessing status for conditionsnvarchar20
71A357Country/Plant/Ctrl code10KBSTATProcessing status for conditionsnvarchar20
72A358Country/Plant/Ctrl code/Material11KBSTATProcessing status for conditionsnvarchar20
73A359Plant/Matl group9KBSTATProcessing status for conditionsnvarchar20
74A363Plant/Vendor/Material10KBSTATProcessing status for conditionsnvarchar20
75A367Country/Plant/Region/Material11KBSTATProcessing status for conditionsnvarchar20
76A368Country/PlntRegion/Region/TaxCl1Cust/TaxCl.Mat12KBSTATProcessing status for conditionsnvarchar20
77A369Country/Plant/Ctrl code/TaxCl1Cust11KBSTATProcessing status for conditionsnvarchar20
78A371Country/Plant/Ctrl code/Ship-to11KBSTATProcessing status for conditionsnvarchar20
79A372Sales org./Ref.doc./Ref.item10KBSTATProcessing status for conditionsnvarchar20
80A523Camp. ID/Matl grp 19KBSTATProcessing status for conditionsnvarchar20
81A599SD doc./Item/Variant10KBSTATProcessing status for conditionsnvarchar20
82A602Condition Table for Pricing A60213KBSTATProcessing status for conditionsnvarchar20
83A631Appl./Version/Status9KBSTATProcessing status for conditionsnvarchar20
84A667SD Doc./Item/Material10KBSTATProcessing status for conditionsnvarchar20
85A668SD Doc./Item/Material/Billable/Grade12KBSTATProcessing status for conditionsnvarchar20
86A669SD Doc./Item/Material/Billable/Country12KBSTATProcessing status for conditionsnvarchar20
87A670SD Doc./Item/Material/Billable/Country/Grade13KBSTATProcessing status for conditionsnvarchar20
88A671SD Doc./Item/Material10KBSTATProcessing status for conditionsnvarchar20
89A740SD Doc./Cust.grp.2/POR - City/POD - City/Shpg Cond./Variant13KBSTATProcessing status for conditionsnvarchar20
90A741SD Doc./Cust.grp.2/POR-Countr/POD-Countr/Shpg Cond./Variant13KBSTATProcessing status for conditionsnvarchar20
91A742SD Doc./Cust.grp.2/POR - City/POD-Countr/Shpg Cond./Variant13KBSTATProcessing status for conditionsnvarchar20
92A743SD Doc./Cust.grp.2/POR-Countr/POD - City/Shpg Cond./Variant13KBSTATProcessing status for conditionsnvarchar20
93A744SD Doc./Cust.grp.2/POL/POD/Shpg Cond./Variant13KBSTATProcessing status for conditionsnvarchar20
94A755Sales Org. D.C. Price Group10KBSTATProcessing status for conditionsnvarchar20
95A796ServcAgent/DepPostCde/RecipCntry10KBSTATProcessing status for conditionsnvarchar20
96A797ServcAgent/DestCtry/DepPostCde10KBSTATProcessing status for conditionsnvarchar20
97A799ServcAgent/DepPostCde/DestCtry/DestRegion11KBSTATProcessing status for conditionsnvarchar20
98A805ShipmntTyp/ServcAgent/TfZn P.Dep/Tf zn.dest11KBSTATProcessing status for conditionsnvarchar20
99A810ShipmntTyp/ServcAgent/TfZn P.Dep/Tf zn.dest/FreightCl.12KBSTATProcessing status for conditionsnvarchar20
100A815ShipmntTyp/ServcAgent/TfZn P.Dep/FreightCl.11KBSTATProcessing status for conditionsnvarchar20
101A816ShipmntTyp/ServcAgent/TargPostCd10KBSTATProcessing status for conditionsnvarchar20
102A817ShipmntTyp/ServcAgent/TargPostCd/FreightCl.11KBSTATProcessing status for conditionsnvarchar20
103A818ShipmntTyp/ServcAgent/DepPostCde10KBSTATProcessing status for conditionsnvarchar20
104A819ShipmntTyp/ServcAgent/DepPostCde/FreightCl.11KBSTATProcessing status for conditionsnvarchar20
105A901Sales org./Distr. Chl/Sold-to pt/Region11KBSTATProcessing status for conditionsnvarchar20
106A907Sales org./Distr. Chl/Sold-to pt10KBSTATProcessing status for conditionsnvarchar20
107A909Sales org./Distr. Chl/Sold-to pt/Incoterms/Inco. 212KBSTATProcessing status for conditionsnvarchar20
108A910Sales org./Distr. Chl/Ship-to/Incoterms/Inco. 212KBSTATProcessing status for conditionsnvarchar20
109A915Sales org./Distr. Chl/Matl Group10KBSTATProcessing status for conditionsnvarchar20
110A920Organisation/Practice/Grade10KBSTATProcessing status for conditionsnvarchar20
111A921Organisation/Practice/Client/Grade11KBSTATProcessing status for conditionsnvarchar20
112A922Organisation/Practice/Client/Fee Earner11KBSTATProcessing status for conditionsnvarchar20
113A923Organisation/Practice/Matter/Grade11KBSTATProcessing status for conditionsnvarchar20
114A933Sales Organization/Incoterms9KBSTATProcessing status for conditionsnvarchar20
115A936Sales org./Distr. Chl/Shpg Cond./Incoterms/Plant/Ship-to13KBSTATProcessing status for conditionsnvarchar20
116A972Sales Organization/Distribution Channel/Material/WBS Element11KBSTATProcessing status for conditionsnvarchar20
117A973Sales ORg/Distr Chan/Material/WBS Elm/PersNr12KBSTATProcessing status for conditionsnvarchar20
118A976Sales Org/DistrChannel/Customer/Material/Personnel NR12KBSTATProcessing status for conditionsnvarchar20
119A981Sales org./Distr. Chl/Material/Billable11KBSTATProcessing status for conditionsnvarchar20
120A982Sales org./Distr. Chl/Material/Billable/Country12KBSTATProcessing status for conditionsnvarchar20
121A983Sales org./Distr. Chl/Material/Billable/Grade12KBSTATProcessing status for conditionsnvarchar20
122A984Sales org./Distr. Chl/Material/Billable/Country/Grade13KBSTATProcessing status for conditionsnvarchar20
123A985Customer/Material/Billable/Country/Grade12KBSTATProcessing status for conditionsnvarchar20
124A986Customer/Material/Billable/Country11KBSTATProcessing status for conditionsnvarchar20
125A987Customer/Material/Billable/Grade11KBSTATProcessing status for conditionsnvarchar20
126A988Customer/Material9KBSTATProcessing status for conditionsnvarchar20
127A991ServcAgent/Dlv.Prior./TfZn P.Dep/Tf zn.dest11KBSTATProcessing status for conditionsnvarchar20
128A992DepPostCde/FreightCl.9KBSTATProcessing status for conditionsnvarchar20
129A993DepPostCde/MatlFrtGrp9KBSTATProcessing status for conditionsnvarchar20
130A994SD doc./Pers.no.9KBSTATProcessing status for conditionsnvarchar20
131A995Sales Doc./Item/Pers.No.10KBSTATProcessing status for conditionsnvarchar20
132A997Sales document/MnItm PrcRefMatl/Personnel Number10KBSTATProcessing status for conditionsnvarchar20
133T686EConditions: Processing Status2KBSTATProcessing status for conditionsnvarchar20
134T686FConditions: Processing Status: Texts3KBSTATProcessing status for conditionsnvarchar20
TOPLocalization
135A151Dest. Ctry/Comm. code9KBSTATProcessing status for conditionsnvarchar20
136A373Country/Plant/Material10KBSTATProcessing status for conditionsnvarchar20
137A374Country/Sales org./Region/PlntRegion/TaxCl3Cust/TaxCl.3Mat13KBSTATProcessing status for conditionsnvarchar20
138A375Country/Sales org./Region/PlntRegion/TaxCl2Cust/TaxCl.2Mat13KBSTATProcessing status for conditionsnvarchar20
139A376Country/Sales org./Region/PlntRegion/TaxCl4Cust/TaxCl.4Mat13KBSTATProcessing status for conditionsnvarchar20
TOPLogistics - General
140A364Trading Contract/Vendor/Material10KBSTATProcessing status for conditionsnvarchar20
141A365Trading Contract/Vendor/Material10KBSTATProcessing status for conditionsnvarchar20
TOPPeriodical Sales and Distribution
142A158PTT Circulation/Publication (CH)9KBSTATProcessing status for conditionsnvarchar20
143A159Package Type/PType Var./Country Grouping10KBSTATProcessing status for conditionsnvarchar20
144A385Sales Org./DChann./Division/Material/Status/Proc.Status10KBSTATProcessing status for conditionsnvarchar20
TOPTariffs, Duties and Permits
145A419ED pricing/Origin/Tax Group/Handl.Type/Orig.reg.12KBSTATProcessing status for conditionsnvarchar20
TOPTraders and Schedulers Workbench
146A339ClsGrp8KBSTATProcessing status for conditionsnvarchar20
TOPTrading Contract
147A311TrCont.no.8KBSTATProcessing status for conditionsnvarchar20
148A312TrCont.no./Item no.9KBSTATProcessing status for conditionsnvarchar20