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

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

137 columns | Print definition?ERP 6.0  | CRTSP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPSLL/CQPEUComponent Quantity Management for FC w/PEU9CRTSPUTC Time Stamp When Object Was Addeddecimal150
2/SAPSLL/CUSWLADLink for Requesting External Customs Declaration Replicates12CRTSPUTC Time Stamp When Object Was Addeddecimal150
3CMM_D_IDXCommodity Management: Index Table35CRTSPIndex: UTC Time Stamp when Object was Addeddecimal150
4MEV_D_AD_ITEMPeriod-End Valuation: Accruals Document Item38CRTSPUTC Time Stamp When Object Was Addeddecimal150
5MEV_D_AD_ROOTPeriod-End Valuation: Accruals Document Root28CRTSPUTC Time Stamp When Object Was Addeddecimal150
6MEV_D_WL_ITEMPeriod-end valuation: Worklist item13CRTSPUTC Time Stamp When Object Was Addeddecimal150
TOPForeign Trade
7/SAPSLL/KMATWLR3GTS: R/3 Feeder System: KMAT Worklist11CRTSPTime Stamp on Which Object Was Addeddecimal150
8/SAPSLL/PRPREFR3GTS: Material Master Record: Preference Data (Summarized)19CRTSPTime Stamp on Which Object Was Addeddecimal150
TOPGlobal Trade Services
9/SAPSLL/ADRCONLegal Control: Data on Address Defined for Business Partner4CRTSPUTC Time Stamp When Object Was Addeddecimal150
10/SAPSLL/ADRLRIDGTS: Identification Numbers for Address in Business Partner4CRTSPUTC Time Stamp When Object Was Addeddecimal150
11/SAPSLL/BOMHDSLL: BOM - Header32CRTSPUTC Time Stamp When Object Was Addeddecimal150
12/SAPSLL/BOMITSLL: BOM - Item28CRTSPUTC Time Stamp When Object Was Addeddecimal150
13/SAPSLL/BOMSTATSLL: BOM: Statis for BOM Transfer10CRTSPUTC Time Stamp When Object Was Addeddecimal150
14/SAPSLL/BOPHDGTS: General Bill of Product - Header Data16CRTSPUTC Time Stamp When Object Was Addeddecimal150
15/SAPSLL/BOPITGTS: General Bill of Product - Item Data20CRTSPUTC Time Stamp When Object Was Addeddecimal150
16/SAPSLL/CCMHDCustoms Warehouse Collective Completion - Header19CRTSPUTC Time Stamp When Object Was Addeddecimal150
17/SAPSLL/CDSYNCGTS: Synchronization of Customs Doc. with Feeder System Doc.7CRTSPUTC Time Stamp When Object Was Addeddecimal150
18/SAPSLL/CMLBPCase Management Audit Business Partners7CRTSPUTC Time Stamp When Object Was Addeddecimal150
19/SAPSLL/CMLCDCase Management Audit Customs Document6CRTSPUTC Time Stamp When Object Was Addeddecimal150
20/SAPSLL/CMLPRCase Management Audit Customs Product7CRTSPUTC Time Stamp When Object Was Addeddecimal150
21/SAPSLL/CORCUITCL&L Srv.: Document - Item- and Country-Specific Customs Data4CRTSPUTC Time Stamp When Object Was Addeddecimal150
22/SAPSLL/CORCUSDCL&L Srv.: Document - Doc.- and Country-Specific Customs Data4CRTSPUTC Time Stamp When Object Was Addeddecimal150
23/SAPSLL/CORDASVLegal & Logistics Services - Information on Data Service6CRTSPUTC Time Stamp When Object Was Addeddecimal150
24/SAPSLL/CORSTHChronological Status of a Document11CRTSPUTC Time Stamp When Object Was Addeddecimal150
25/SAPSLL/CTSCONVNumber System: Relations Between Number Systems24CRTSPUTC Time Stamp When Object Was Addeddecimal150
26/SAPSLL/CTSCONVANumber System: Relations: Authority: Recoding24CRTSPUTC Time Stamp When Object Was Addeddecimal150
27/SAPSLL/CTSCONVPNumber System: Relations: Improperly Classified Products15CRTSPUTC Time Stamp When Object Was Addeddecimal150
28/SAPSLL/CTSGENLegal&Logistics Services: Generic Part of Customs Tariff No.15CRTSPUTC Time Stamp When Object Was Addeddecimal150
29/SAPSLL/CTSNUMCustoms Tariff Number15CRTSPUTC Time Stamp When Object Was Addeddecimal150
30/SAPSLL/CTSNUMCL & L Services - Country-Specific Customs Tariff No.16CRTSPUTC Time Stamp When Object Was Addeddecimal150
31/SAPSLL/CTSSETGTS: Assignment of Number to Set10CRTSPUTC Time Stamp When Object Was Addeddecimal150
32/SAPSLL/CTSTXTKSLL: Numbering System: Search Terms for the Numbering Texts4CRTSPUTC Time Stamp When Object Was Addeddecimal150
33/SAPSLL/CUHDCustoms Document: Header6CRTSPUTC Time Stamp When Object Was Addeddecimal150
34/SAPSLL/CUHDBLRCustoms Document: Header: Blocked Legal Regulations8CRTSPUTC Time Stamp When Object Was Addeddecimal150
35/SAPSLL/CUHDRCustoms Document (Backup): Header6CRTSPUTC Time Stamp When Object Was Addeddecimal150
36/SAPSLL/CUITCustoms Document: Item6CRTSPUTC Time Stamp When Object Was Addeddecimal150
37/SAPSLL/CUITBLRCustoms Document: Item: Blocked Legal Regulations9CRTSPUTC Time Stamp When Object Was Addeddecimal150
38/SAPSLL/CUITPREGTS: Customs Document: Item: Preference Data21CRTSPUTC Time Stamp When Object Was Addeddecimal150
39/SAPSLL/CUITRCustoms Document (Backup): Item6CRTSPUTC Time Stamp When Object Was Addeddecimal150
40/SAPSLL/CUPEDSupplementary Customs Declaration Header21CRTSPUTC Time Stamp When Object Was Addeddecimal150
41/SAPSLL/CUSWLAWorklist for Quantity Comparison Goods Issue/Customs Doc.33CRTSPUTC Time Stamp When Object Was Addeddecimal150
42/SAPSLL/CUSWLBCustoms Worklist: Qty Adjustment - Completed Transactions37CRTSPUTC Time Stamp When Object Was Addeddecimal150
43/SAPSLL/CUSWLDCustoms Processing: Procedures Completed for Customs Decl.72CRTSPUTC Time Stamp When Object Was Addeddecimal150
44/SAPSLL/CUSWLEWorklist for Processing Domestic Customs Warehouse Issues32CRTSPUTC Time Stamp When Object Was Addeddecimal150
45/SAPSLL/CUSWLFCustoms Worklist: Domestic Issues - Completed Transactions32CRTSPUTC Time Stamp When Object Was Addeddecimal150
46/SAPSLL/CUSWLMQuantity Comparison: Customs Declaration/Goods Receipt35CRTSPUTC Time Stamp When Object Was Addeddecimal150
47/SAPSLL/CUSWLNCompleted Quantity Comparisons Customs Declaration/GR35CRTSPUTC Time Stamp When Object Was Addeddecimal150
48/SAPSLL/CUSWLOWorklist for Transactions with Reference to Delivery or PO72CRTSPUTC Time Stamp When Object Was Addeddecimal150
49/SAPSLL/CUSWLPCustoms Worklist: Periodic Declarations17CRTSPUTC Time Stamp When Object Was Addeddecimal150
50/SAPSLL/CUSWLQCustoms Worklist: Per. Declarations - Completed Transactions17CRTSPUTC Time Stamp When Object Was Addeddecimal150
51/SAPSLL/CUSWLSCustoms Worklist: Temporary Storage39CRTSPUTC Time Stamp When Object Was Addeddecimal150
52/SAPSLL/CUSWLTCustoms Worklist: Completed Temporary Storage39CRTSPUTC Time Stamp When Object Was Addeddecimal150
53/SAPSLL/CWLCCPWorklist of Export Items to Determine IP Closing Portions15CRTSPUTC Time Stamp When Object Was Addeddecimal150
54/SAPSLL/CWLOCPWorklist: Import Items to Determine OP Closing Portions11CRTSPUTC Time Stamp When Object Was Addeddecimal150
55/SAPSLL/CWLPCPWorklist: Installation Statement FC w/PEU17CRTSPUTC Time Stamp When Object Was Addeddecimal150
56/SAPSLL/FTOBPRELGTS: Relational Table: Foreign Trade Org.for Business Part.8CRTSPUTC Time Stamp When Object Was Addeddecimal150
57/SAPSLL/FTOPRRELGTS: Relational Table: Foreign Trade Org.for Product7CRTSPUTC Time Stamp When Object Was Addeddecimal150
58/SAPSLL/GENOBJSLL: Generated Objects5CRTSPUTC Time Stamp When Object Was Addeddecimal150
59/SAPSLL/ITARAUDITAR Tracking: Log - Header Data15CRTSPUTC Time Stamp When Object Was Addeddecimal150
60/SAPSLL/IVMCSL01Individual Stock Item, Special Customs Proced. - Change Log10CRTSPUTC Time Stamp When Object Was Addeddecimal150
61/SAPSLL/IVMCSL02Totals Stock, Special Customs Procedures - Change Log10CRTSPUTC Time Stamp When Object Was Addeddecimal150
62/SAPSLL/IVMFSL01Change Log for Individual Stock item Free Circulation f. PEU10CRTSPUTC Time Stamp When Object Was Addeddecimal150
63/SAPSLL/IVMPSL01Processing Stock: Log of Changes10CRTSPUTC Time Stamp When Object Was Addeddecimal150
64/SAPSLL/KMATPREFGTS: Preference Processing KMAT - Storage of Results25CRTSPUTC Time Stamp When Object Was Addeddecimal150
65/SAPSLL/KMATWLGTS: KMAT Worklist13CRTSPUTC Time Stamp When Object Was Addeddecimal150
66/SAPSLL/KMATWLSIGTS: KMAT Worklist Subitem8CRTSPUTC Time Stamp When Object Was Addeddecimal150
67/SAPSLL/LCLICLegal Control: License Header12CRTSPUTC Time Stamp When Object Was Addeddecimal150
68/SAPSLL/LCLICAQLLicense: Change Log: Available Quantity5CRTSPUTC Time Stamp When Object Was Addeddecimal150
69/SAPSLL/LCLICAVLLicense: Change Log of Available Quantity5CRTSPUTC Time Stamp When Object Was Addeddecimal150
70/SAPSLL/LCLICSLegal Control: Licenses - Statuses5CRTSPUTC Time Stamp When Object Was Addeddecimal150
71/SAPSLL/LCPROProject Master5CRTSPUTC Time Stamp When Object Was Addeddecimal150
72/SAPSLL/LCPROTProject Master - Text Table6CRTSPUTC Time Stamp When Object Was Addeddecimal150
73/SAPSLL/LC_CUSB1GTS: Custs Prcssng: Duty Cat: Non-EU Country Duty, Pharmac.29CRTSPUTC Time Stamp When Object Was Addeddecimal150
74/SAPSLL/LC_CUSB2GTS Customs Management: Toll Category: Preferred Customs30CRTSPUTC Time Stamp When Object Was Addeddecimal150
75/SAPSLL/LC_CUSXCGTS: Customs Managemet: Toll Cat: Customs Tolls: Exclusion6CRTSPUTC Time Stamp When Object Was Addeddecimal150
76/SAPSLL/LEGCONLegal Control - Document31CRTSPUTC Time Stamp When Object Was Addeddecimal150
77/SAPSLL/LEGPEUClosing of Free Circulation with Prescribed End Use23CRTSPUTC Time Stamp When Object Was Addeddecimal150
78/SAPSLL/LEGSCPClosings of Special Customs Procedures (IP / PUCC)24CRTSPUTC Time Stamp When Object Was Addeddecimal150
79/SAPSLL/MILOMAContent Migration Log - Header Data8CRTSPUTC Time Stamp When Object Was Addeddecimal150
80/SAPSLL/PARMAGTS: Partner Mapping13CRTSPUTC Time Stamp When Object Was Addeddecimal150
81/SAPSLL/PRLegal & Logistics Services: Product Master22CRTSPUTC Time Stamp When Object Was Addeddecimal150
82/SAPSLL/PRBOPHSLL: Outward Processing BOM - Header Data10CRTSPUTC Time Stamp When Object Was Addeddecimal150
83/SAPSLL/PRBWHGTS Product Master: BW Relevance per Logical System7CRTSPUTC Time Stamp When Object Was Addeddecimal150
84/SAPSLL/PRCONLegal Control - Product Master4CRTSPUTC Time Stamp When Object Was Addeddecimal150
85/SAPSLL/PRCTSProduct Master - Global Customs Tariff Numbers4CRTSPUTC Time Stamp When Object Was Addeddecimal150
86/SAPSLL/PRCTSCProduct Master - Country-Specific Customs Tariff Numbers4CRTSPUTC Time Stamp When Object Was Addeddecimal150
87/SAPSLL/PRECIPProduct Master: Data for Special Customs Procedures6CRTSPUTC Time Stamp When Object Was Addeddecimal150
88/SAPSLL/PRECONDGTS: Preference: Additional Conditions (Data Prov. Upload)7CRTSPUTC Time Stamp When Object Was Addeddecimal150
89/SAPSLL/PRECONDTGTS: preference: additional cond's (upload data provider -B)16CRTSPUTC Time Stamp When Object Was Addeddecimal150
90/SAPSLL/PREGPGTS: Preference: Rule Groups (Data Provider Upload)8CRTSPUTC Time Stamp When Object Was Addeddecimal150
91/SAPSLL/PREGPCONGTS: Preference: Linked Rule Groups (Upload from Data Prov.)6CRTSPUTC Time Stamp When Object Was Addeddecimal150
92/SAPSLL/PREGPPROGTS: Preference: Procedure Groups (Data Provider Upload)17CRTSPUTC Time Stamp When Object Was Addeddecimal150
93/SAPSLL/PRELGREGGTS: Preference: Agreement - Rule Group Assgmt (DP Upload)9CRTSPUTC Time Stamp When Object Was Addeddecimal150
94/SAPSLL/PREPROCGTS: Preference: Procedure (Data Provider Upload)12CRTSPUTC Time Stamp When Object Was Addeddecimal150
95/SAPSLL/PREPROCTGTS: Preference: Procedure (Data Prov. Upload) - Description7CRTSPUTC Time Stamp When Object Was Addeddecimal150
96/SAPSLL/PRETFCNOGTS: Preference: Tariff Code Rule Grp f. Agreemt (DP Upload)11CRTSPUTC Time Stamp When Object Was Addeddecimal150
97/SAPSLL/PREVDPreference: Long-Term Vendor Declaration - Header13CRTSPUTC Time Stamp When Object Was Addeddecimal150
98/SAPSLL/PREVDAUDSLL: Preference: Vend.Decl. for Customer Purp.: Audit85CRTSPUTC Time Stamp When Object Was Addeddecimal150
99/SAPSLL/PREVDCHGGTS: Preference, Vendor Decl. (Customer), Relevant Changes6CRTSPUTC Time Stamp When Object Was Addeddecimal150
100/SAPSLL/PREVDHPreference: Long-Term Vendor Declaration Header13CRTSPUTC Time Stamp When Object Was Addeddecimal150
101/SAPSLL/PREVDIPreference: Long-Term Vendor Declaration Item8CRTSPUTC Time Stamp When Object Was Addeddecimal150
102/SAPSLL/PREVDWLOSLL: Preference: Vend.Decl. f. Cust. Purp. - Worklist17CRTSPUTC Time Stamp When Object Was Addeddecimal150
103/SAPSLL/PRGENGTS: Product Master: Generic Characteristic Values36CRTSPUTC Time Stamp When Object Was Addeddecimal150
104/SAPSLL/PRODWLGTS: Product Master: Global: Worklist8CRTSPUTC Time Stamp When Object Was Addeddecimal150
105/SAPSLL/PRPARLegal and Logistics Services: Product Master - Partner7CRTSPUTC Time Stamp When Object Was Addeddecimal150
106/SAPSLL/PRPREFSLL: Product Master: Preference Data20CRTSPUTC Time Stamp When Object Was Addeddecimal150
107/SAPSLL/PRPRFCSLL: Product Master: Preference Data: Confirm. Pref. Reqmts14CRTSPUTC Time Stamp When Object Was Addeddecimal150
108/SAPSLL/PRPRFSSLL: Product Master: Preference Data: Special Requirements15CRTSPUTC Time Stamp When Object Was Addeddecimal150
109/SAPSLL/PRREXProduct Master: Re-Export Segment20CRTSPUTC Time Stamp When Object Was Addeddecimal150
110/SAPSLL/PRTLegal and Logistics Services: Product Master - Short Text4CRTSPUTC Time Stamp When Object Was Addeddecimal150
111/SAPSLL/PRTAXLegal and Logistics Services: Product Master - Tax Groups11CRTSPUTC Time Stamp When Object Was Addeddecimal150
112/SAPSLL/PRUOMLegal & Logistics Services: Product Master - Units4CRTSPUTC Time Stamp When Object Was Addeddecimal150
113/SAPSLL/PRVDRELProduct Master: Relevance for Request of Vendor Declaration8CRTSPUTC Time Stamp When Object Was Addeddecimal150
114/SAPSLL/PSVCONDGTS: Preference: Additional Conditions (Manual Entry)7CRTSPUTC Time Stamp When Object Was Addeddecimal150
115/SAPSLL/PSVCONDTGTS: Preference: Additional Conditions (Manual Entry)16CRTSPUTC Time Stamp When Object Was Addeddecimal150
116/SAPSLL/PSVGPGTS: Preference: Rule Groups (Manual Entry)8CRTSPUTC Time Stamp When Object Was Addeddecimal150
117/SAPSLL/PSVGPCONGTS: Preference: Linked Rule Groups (Manual Entry)6CRTSPUTC Time Stamp When Object Was Addeddecimal150
118/SAPSLL/PSVGPPROGTS: Preference: Procedure Groups (Manual Entry)17CRTSPUTC Time Stamp When Object Was Addeddecimal150
119/SAPSLL/PSVLGREGGTS: Preference: Agreement - Rule Group Assgmnt (Man. Entry)9CRTSPUTC Time Stamp When Object Was Addeddecimal150
120/SAPSLL/PSVPROCGTS: Preference: Procedure (Manual Entry)12CRTSPUTC Time Stamp When Object Was Addeddecimal150
121/SAPSLL/PSVPROCTGTS: Preference: Procedure (Manual Entry) - Description7CRTSPUTC Time Stamp When Object Was Addeddecimal150
122/SAPSLL/PSVTFCNOGTS: Preference: Tariff Code Rule Grp f. Agreemt (Man.Entry)11CRTSPUTC Time Stamp When Object Was Addeddecimal150
123/SAPSLL/SCPBODSettlement Run for Special Customs Procedures10CRTSPUTC Time Stamp When Object Was Addeddecimal150
124/SAPSLL/SECADJWLWorklist for Automatic Adjustment of Securities16CRTSPUTC Time Stamp When Object Was Addeddecimal150
125/SAPSLL/SECFINGTS: Guarantees - Refinancing11CRTSPUTC Time Stamp When Object Was Addeddecimal150
126/SAPSLL/SPLAUDLegal Control - SPL - Audit4CRTSPUTC Time Stamp When Object Was Addeddecimal150
127/SAPSLL/TSHDTax Statement: Header6CRTSPUTC Time Stamp When Object Was Addeddecimal150
128/SAPSLL/TSPLLegal & Logistics Services: LC: SPL Master (Header Data)4CRTSPUTC Time Stamp When Object Was Addeddecimal150
129/SAPSLL/TSPLALegal Control: SPL Master (Address Data)4CRTSPUTC Time Stamp When Object Was Addeddecimal150
130/SAPSLL/TSPLAKLegal Control: SPL Master (Address Data) - Keywords4CRTSPUTC Time Stamp When Object Was Addeddecimal150
131/SAPSLL/TSPLNLegal Control: SPL Master (Name Data)4CRTSPUTC Time Stamp When Object Was Addeddecimal150
132/SAPSLL/TSPLNKLegal Control: SPL Master (Name Data) - Keywords4CRTSPUTC Time Stamp When Object Was Addeddecimal150
133/SAPSLL/USRORGAssignment of Organizational Unit to User10CRTSPUTC Time Stamp When Object Was Addeddecimal150
134/SAPSLL/VDFCPEUInstallation Statement for Free Circ. w/Prescribed End Use9CRTSPUTC Time Stamp When Object Was Addeddecimal150
135/SAPSLL/VDIWLPROLTVD Maintenance via Web Dynpro: Control Line13CRTSPUTC Time Stamp When Object Was Addeddecimal150
136/SAPSLL/VDMTWLPreference: Worklist to Maintain LTVD via Web Dynpro19CRTSPUTC Time Stamp When Object Was Addeddecimal150
137/SAPSLL/VDOWLWorklist: Vendor Declaration for Customer's Purpose20CRTSPUTC Time Stamp When Object Was Addeddecimal150