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

111 columns | Print definition?ERP 6.0  | CHTSP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPSLL/CUSWLADLink for Requesting External Customs Declaration Replicates14CHTSPUTC Time Stamp When Object Was Changeddecimal150
2CMM_D_IDXCommodity Management: Index Table37CHTSPIndex: UTC Time Stamp when Object was Changeddecimal150
3MEV_D_AD_ITEMPeriod-End Valuation: Accruals Document Item40CHTSPUTC Time Stamp When Object Was Changeddecimal150
4MEV_D_AD_ROOTPeriod-End Valuation: Accruals Document Root30CHTSPUTC Time Stamp When Object Was Changeddecimal150
5MEV_D_WL_ITEMPeriod-end valuation: Worklist item15CHTSPUTC Time Stamp When Object Was Changeddecimal150
TOPForeign Trade
6/SAPSLL/KMATWLR3GTS: R/3 Feeder System: KMAT Worklist13CHTSPTime Stamp on Which Object Was Changeddecimal150
7/SAPSLL/PRPREFR3GTS: Material Master Record: Preference Data (Summarized)21CHTSPTime Stamp on Which Object Was Changeddecimal150
TOPGlobal Trade Services
8/SAPSLL/ADRCONLegal Control: Data on Address Defined for Business Partner6CHTSPUTC Time Stamp When Object Was Changeddecimal150
9/SAPSLL/ADRLRIDGTS: Identification Numbers for Address in Business Partner6CHTSPUTC Time Stamp When Object Was Changeddecimal150
10/SAPSLL/BOMHDSLL: BOM - Header34CHTSPUTC Time Stamp When Object Was Changeddecimal150
11/SAPSLL/BOMITSLL: BOM - Item30CHTSPUTC Time Stamp When Object Was Changeddecimal150
12/SAPSLL/BOMSTATSLL: BOM: Statis for BOM Transfer12CHTSPUTC Time Stamp When Object Was Changeddecimal150
13/SAPSLL/BOPHDGTS: General Bill of Product - Header Data18CHTSPUTC Time Stamp When Object Was Changeddecimal150
14/SAPSLL/BOPITGTS: General Bill of Product - Item Data22CHTSPUTC Time Stamp When Object Was Changeddecimal150
15/SAPSLL/CCMHDCustoms Warehouse Collective Completion - Header21CHTSPUTC Time Stamp When Object Was Changeddecimal150
16/SAPSLL/CDSYNCGTS: Synchronization of Customs Doc. with Feeder System Doc.9CHTSPUTC Time Stamp When Object Was Changeddecimal150
17/SAPSLL/CHGLGChange Log15CHTSPUTC Time Stamp When Object Was Changeddecimal150
18/SAPSLL/CMLBPCase Management Audit Business Partners9CHTSPUTC Time Stamp When Object Was Changeddecimal150
19/SAPSLL/CMLCDCase Management Audit Customs Document8CHTSPUTC Time Stamp When Object Was Changeddecimal150
20/SAPSLL/CMLPRCase Management Audit Customs Product9CHTSPUTC Time Stamp When Object Was Changeddecimal150
21/SAPSLL/CORCUITCL&L Srv.: Document - Item- and Country-Specific Customs Data6CHTSPUTC Time Stamp When Object Was Changeddecimal150
22/SAPSLL/CORCUSDCL&L Srv.: Document - Doc.- and Country-Specific Customs Data6CHTSPUTC Time Stamp When Object Was Changeddecimal150
23/SAPSLL/CORDASVLegal & Logistics Services - Information on Data Service8CHTSPUTC Time Stamp When Object Was Changeddecimal150
24/SAPSLL/CORSTALegal & Logistics Services: Document Statuses10CHTSPUTC Time Stamp When Object Was Changeddecimal150
25/SAPSLL/CTSCONVNumber System: Relations Between Number Systems26CHTSPUTC Time Stamp When Object Was Changeddecimal150
26/SAPSLL/CTSCONVANumber System: Relations: Authority: Recoding26CHTSPUTC Time Stamp When Object Was Changeddecimal150
27/SAPSLL/CTSCONVPNumber System: Relations: Improperly Classified Products17CHTSPUTC Time Stamp When Object Was Changeddecimal150
28/SAPSLL/CTSGENLegal&Logistics Services: Generic Part of Customs Tariff No.17CHTSPUTC Time Stamp When Object Was Changeddecimal150
29/SAPSLL/CTSNUMCustoms Tariff Number17CHTSPUTC Time Stamp When Object Was Changeddecimal150
30/SAPSLL/CTSNUMCL & L Services - Country-Specific Customs Tariff No.18CHTSPUTC Time Stamp When Object Was Changeddecimal150
31/SAPSLL/CTSSETGTS: Assignment of Number to Set12CHTSPUTC Time Stamp When Object Was Changeddecimal150
32/SAPSLL/CTSTXTKSLL: Numbering System: Search Terms for the Numbering Texts6CHTSPUTC Time Stamp When Object Was Changeddecimal150
33/SAPSLL/CUHDCustoms Document: Header8CHTSPUTC Time Stamp When Object Was Changeddecimal150
34/SAPSLL/CUHDBLRCustoms Document: Header: Blocked Legal Regulations10CHTSPUTC Time Stamp When Object Was Changeddecimal150
35/SAPSLL/CUHDRCustoms Document (Backup): Header8CHTSPUTC Time Stamp When Object Was Changeddecimal150
36/SAPSLL/CUITCustoms Document: Item8CHTSPUTC Time Stamp When Object Was Changeddecimal150
37/SAPSLL/CUITBLRCustoms Document: Item: Blocked Legal Regulations11CHTSPUTC Time Stamp When Object Was Changeddecimal150
38/SAPSLL/CUITPREGTS: Customs Document: Item: Preference Data23CHTSPUTC Time Stamp When Object Was Changeddecimal150
39/SAPSLL/CUITRCustoms Document (Backup): Item8CHTSPUTC Time Stamp When Object Was Changeddecimal150
40/SAPSLL/CUPEDSupplementary Customs Declaration Header23CHTSPUTC Time Stamp When Object Was Changeddecimal150
41/SAPSLL/FTOBPRELGTS: Relational Table: Foreign Trade Org.for Business Part.10CHTSPUTC Time Stamp When Object Was Changeddecimal150
42/SAPSLL/FTOPRRELGTS: Relational Table: Foreign Trade Org.for Product9CHTSPUTC Time Stamp When Object Was Changeddecimal150
43/SAPSLL/GENOBJSLL: Generated Objects7CHTSPUTC Time Stamp When Object Was Changeddecimal150
44/SAPSLL/ITARAUDITAR Tracking: Log - Header Data17CHTSPUTC Time Stamp When Object Was Changeddecimal150
45/SAPSLL/KMATPREFGTS: Preference Processing KMAT - Storage of Results27CHTSPUTC Time Stamp When Object Was Changeddecimal150
46/SAPSLL/KMATWLGTS: KMAT Worklist15CHTSPUTC Time Stamp When Object Was Changeddecimal150
47/SAPSLL/KMATWLSIGTS: KMAT Worklist Subitem10CHTSPUTC Time Stamp When Object Was Changeddecimal150
48/SAPSLL/LCLICLegal Control: License Header14CHTSPUTC Time Stamp When Object Was Changeddecimal150
49/SAPSLL/LCPROProject Master7CHTSPUTC Time Stamp When Object Was Changeddecimal150
50/SAPSLL/LCPROTProject Master - Text Table8CHTSPUTC Time Stamp When Object Was Changeddecimal150
51/SAPSLL/LC_CUSB1GTS: Custs Prcssng: Duty Cat: Non-EU Country Duty, Pharmac.31CHTSPUTC Time Stamp When Object Was Changeddecimal150
52/SAPSLL/LC_CUSB2GTS Customs Management: Toll Category: Preferred Customs32CHTSPUTC Time Stamp When Object Was Changeddecimal150
53/SAPSLL/LC_CUSXCGTS: Customs Managemet: Toll Cat: Customs Tolls: Exclusion8CHTSPUTC Time Stamp When Object Was Changeddecimal150
54/SAPSLL/LEGCONLegal Control - Document33CHTSPUTC Time Stamp When Object Was Changeddecimal150
55/SAPSLL/MILOMAContent Migration Log - Header Data10CHTSPUTC Time Stamp When Object Was Changeddecimal150
56/SAPSLL/PARMAGTS: Partner Mapping15CHTSPUTC Time Stamp When Object Was Changeddecimal150
57/SAPSLL/PRLegal & Logistics Services: Product Master24CHTSPUTC Time Stamp When Object Was Changeddecimal150
58/SAPSLL/PRBOPHSLL: Outward Processing BOM - Header Data12CHTSPUTC Time Stamp When Object Was Changeddecimal150
59/SAPSLL/PRBWHGTS Product Master: BW Relevance per Logical System9CHTSPUTC Time Stamp When Object Was Changeddecimal150
60/SAPSLL/PRCONLegal Control - Product Master6CHTSPUTC Time Stamp When Object Was Changeddecimal150
61/SAPSLL/PRCTSProduct Master - Global Customs Tariff Numbers6CHTSPUTC Time Stamp When Object Was Changeddecimal150
62/SAPSLL/PRCTSCProduct Master - Country-Specific Customs Tariff Numbers6CHTSPUTC Time Stamp When Object Was Changeddecimal150
63/SAPSLL/PRECIPProduct Master: Data for Special Customs Procedures8CHTSPUTC Time Stamp When Object Was Changeddecimal150
64/SAPSLL/PRECONDGTS: Preference: Additional Conditions (Data Prov. Upload)9CHTSPUTC Time Stamp When Object Was Changeddecimal150
65/SAPSLL/PRECONDTGTS: preference: additional cond's (upload data provider -B)18CHTSPUTC Time Stamp When Object Was Changeddecimal150
66/SAPSLL/PREGPGTS: Preference: Rule Groups (Data Provider Upload)10CHTSPUTC Time Stamp When Object Was Changeddecimal150
67/SAPSLL/PREGPCONGTS: Preference: Linked Rule Groups (Upload from Data Prov.)8CHTSPUTC Time Stamp When Object Was Changeddecimal150
68/SAPSLL/PREGPPROGTS: Preference: Procedure Groups (Data Provider Upload)19CHTSPUTC Time Stamp When Object Was Changeddecimal150
69/SAPSLL/PRELGREGGTS: Preference: Agreement - Rule Group Assgmt (DP Upload)11CHTSPUTC Time Stamp When Object Was Changeddecimal150
70/SAPSLL/PREPROCGTS: Preference: Procedure (Data Provider Upload)14CHTSPUTC Time Stamp When Object Was Changeddecimal150
71/SAPSLL/PREPROCTGTS: Preference: Procedure (Data Prov. Upload) - Description9CHTSPUTC Time Stamp When Object Was Changeddecimal150
72/SAPSLL/PRETFCNOGTS: Preference: Tariff Code Rule Grp f. Agreemt (DP Upload)13CHTSPUTC Time Stamp When Object Was Changeddecimal150
73/SAPSLL/PREVDPreference: Long-Term Vendor Declaration - Header15CHTSPUTC Time Stamp When Object Was Changeddecimal150
74/SAPSLL/PREVDAUDSLL: Preference: Vend.Decl. for Customer Purp.: Audit87CHTSPUTC Time Stamp When Object Was Changeddecimal150
75/SAPSLL/PREVDCHGGTS: Preference, Vendor Decl. (Customer), Relevant Changes8CHTSPUTC Time Stamp When Object Was Changeddecimal150
76/SAPSLL/PREVDHPreference: Long-Term Vendor Declaration Header15CHTSPUTC Time Stamp When Object Was Changeddecimal150
77/SAPSLL/PREVDIPreference: Long-Term Vendor Declaration Item10CHTSPUTC Time Stamp When Object Was Changeddecimal150
78/SAPSLL/PREVDWLOSLL: Preference: Vend.Decl. f. Cust. Purp. - Worklist19CHTSPUTC Time Stamp When Object Was Changeddecimal150
79/SAPSLL/PRGENGTS: Product Master: Generic Characteristic Values38CHTSPUTC Time Stamp When Object Was Changeddecimal150
80/SAPSLL/PRODWLGTS: Product Master: Global: Worklist10CHTSPUTC Time Stamp When Object Was Changeddecimal150
81/SAPSLL/PRPARLegal and Logistics Services: Product Master - Partner9CHTSPUTC Time Stamp When Object Was Changeddecimal150
82/SAPSLL/PRPREFSLL: Product Master: Preference Data22CHTSPUTC Time Stamp When Object Was Changeddecimal150
83/SAPSLL/PRPRFCSLL: Product Master: Preference Data: Confirm. Pref. Reqmts16CHTSPUTC Time Stamp When Object Was Changeddecimal150
84/SAPSLL/PRPRFSSLL: Product Master: Preference Data: Special Requirements17CHTSPUTC Time Stamp When Object Was Changeddecimal150
85/SAPSLL/PRREXProduct Master: Re-Export Segment22CHTSPUTC Time Stamp When Object Was Changeddecimal150
86/SAPSLL/PRTLegal and Logistics Services: Product Master - Short Text6CHTSPUTC Time Stamp When Object Was Changeddecimal150
87/SAPSLL/PRTAXLegal and Logistics Services: Product Master - Tax Groups13CHTSPUTC Time Stamp When Object Was Changeddecimal150
88/SAPSLL/PRUOMLegal & Logistics Services: Product Master - Units6CHTSPUTC Time Stamp When Object Was Changeddecimal150
89/SAPSLL/PRVDRELProduct Master: Relevance for Request of Vendor Declaration10CHTSPUTC Time Stamp When Object Was Changeddecimal150
90/SAPSLL/PSVCONDGTS: Preference: Additional Conditions (Manual Entry)9CHTSPUTC Time Stamp When Object Was Changeddecimal150
91/SAPSLL/PSVCONDTGTS: Preference: Additional Conditions (Manual Entry)18CHTSPUTC Time Stamp When Object Was Changeddecimal150
92/SAPSLL/PSVGPGTS: Preference: Rule Groups (Manual Entry)10CHTSPUTC Time Stamp When Object Was Changeddecimal150
93/SAPSLL/PSVGPCONGTS: Preference: Linked Rule Groups (Manual Entry)8CHTSPUTC Time Stamp When Object Was Changeddecimal150
94/SAPSLL/PSVGPPROGTS: Preference: Procedure Groups (Manual Entry)19CHTSPUTC Time Stamp When Object Was Changeddecimal150
95/SAPSLL/PSVLGREGGTS: Preference: Agreement - Rule Group Assgmnt (Man. Entry)11CHTSPUTC Time Stamp When Object Was Changeddecimal150
96/SAPSLL/PSVPROCGTS: Preference: Procedure (Manual Entry)14CHTSPUTC Time Stamp When Object Was Changeddecimal150
97/SAPSLL/PSVPROCTGTS: Preference: Procedure (Manual Entry) - Description9CHTSPUTC Time Stamp When Object Was Changeddecimal150
98/SAPSLL/PSVTFCNOGTS: Preference: Tariff Code Rule Grp f. Agreemt (Man.Entry)13CHTSPUTC Time Stamp When Object Was Changeddecimal150
99/SAPSLL/SECADJWLWorklist for Automatic Adjustment of Securities18CHTSPUTC Time Stamp When Object Was Changeddecimal150
100/SAPSLL/SECFINGTS: Guarantees - Refinancing13CHTSPUTC Time Stamp When Object Was Changeddecimal150
101/SAPSLL/SPLAUDLegal Control - SPL - Audit6CHTSPUTC Time Stamp When Object Was Changeddecimal150
102/SAPSLL/TSHDTax Statement: Header8CHTSPUTC Time Stamp When Object Was Changeddecimal150
103/SAPSLL/TSPLLegal & Logistics Services: LC: SPL Master (Header Data)6CHTSPUTC Time Stamp When Object Was Changeddecimal150
104/SAPSLL/TSPLALegal Control: SPL Master (Address Data)6CHTSPUTC Time Stamp When Object Was Changeddecimal150
105/SAPSLL/TSPLAKLegal Control: SPL Master (Address Data) - Keywords6CHTSPUTC Time Stamp When Object Was Changeddecimal150
106/SAPSLL/TSPLNLegal Control: SPL Master (Name Data)6CHTSPUTC Time Stamp When Object Was Changeddecimal150
107/SAPSLL/TSPLNKLegal Control: SPL Master (Name Data) - Keywords6CHTSPUTC Time Stamp When Object Was Changeddecimal150
108/SAPSLL/USRORGAssignment of Organizational Unit to User11CHTSPUTC Time Stamp When Object Was Changeddecimal150
109/SAPSLL/VDIWLPROLTVD Maintenance via Web Dynpro: Control Line15CHTSPUTC Time Stamp When Object Was Changeddecimal150
110/SAPSLL/VDMTWLPreference: Worklist to Maintain LTVD via Web Dynpro21CHTSPUTC Time Stamp When Object Was Changeddecimal150
111/SAPSLL/VDOWLWorklist: Vendor Declaration for Customer's Purpose22CHTSPUTC Time Stamp When Object Was Changeddecimal150