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
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

155 columns | Print definition?ERP 6.0  | LGREG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPSLL/CUSWLADLink for Requesting External Customs Declaration Replicates3LGREGLegal Regulationnvarchar50
2/SAPSLL/TSPLIDXTREX Index ID for Sanctioned Party List Screening3LGREGLegal Regulationnvarchar50
3/SAPSLL/TSPLTRXTREX Index ID for Sanctioned Party List Screening (Delta)3LGREGLegal Regulationnvarchar50
TOPDenmark
4T5M5BSAP-PBS Interface: Definition of Wage Type Intervals DK27LGREGWage Type Applied in Original Payroll Periodnvarchar40
TOPForeign Trade
5/SAPSLL/ALRGDAR3GTS: Determination of Legal Regulations5LGREGLegal Regulation for Legal Control for GTSnvarchar50
6/SAPSLL/PRPREFR3GTS: Material Master Record: Preference Data (Summarized)4LGREGLegal Regulation for Legal Control for GTSnvarchar50
7/SAPSLL/T606GR3GTS: Legal Services: Legal Regulations2LGREGLegal Regulation for Legal Control for GTSnvarchar50
8/SAPSLL/T606GTR3GTS: Legal Services: Legal Regulations - Name3LGREGLegal Regulation for Legal Control for GTSnvarchar50
TOPGlobal Trade Services
9/SAPSLL/ADRCONLegal Control: Data on Address Defined for Business Partner8LGREGLegal Regulationnvarchar50
10/SAPSLL/ADRCONSPGTS: Legal Control: SPL Check Results for Address8LGREGLegal Regulationnvarchar50
11/SAPSLL/ADRLRIDGTS: Identification Numbers for Address in Business Partner8LGREGLegal Regulationnvarchar50
12/SAPSLL/ALRG01Determination of Legal Regulation at Country Level2LGREGLegal Regulationnvarchar50
13/SAPSLL/ALRG02GTS: Legal Regulation Determination: Country/Country Level2LGREGLegal Regulationnvarchar50
14/SAPSLL/ALRG03GTS: Legal Regulation Determination: Cntry/Cntry Group Level2LGREGLegal Regulationnvarchar50
15/SAPSLL/ALRG11GTS: Legal Regulation Determination at Country Group Level2LGREGLegal Regulationnvarchar50
16/SAPSLL/ALRG12GTS: Legal Regulation Determination: Cntry Group/Cntry Level2LGREGLegal Regulationnvarchar50
17/SAPSLL/ALRG13GTS: Legal Regul. Determination: Cntry Grp/Cntry Grp Level2LGREGLegal Regulationnvarchar50
18/SAPSLL/BOPHDGTS: General Bill of Product - Header Data7LGREGLegal Regulationnvarchar50
19/SAPSLL/CCCTRYLegal Control: Country-Specific Information2LGREGLegal Regulationnvarchar50
20/SAPSLL/CCGRControl Groupings for Products2LGREGLegal Regulationnvarchar50
21/SAPSLL/CCGRTLegal Control: Control Groupings for Products - Relation.3LGREGLegal Regulationnvarchar50
22/SAPSLL/CCSHLegal Control: Peculiarity Code for Products2LGREGLegal Regulationnvarchar50
23/SAPSLL/CCSHTLegal Control: Peculiarity Code for Products - Text3LGREGLegal Regulationnvarchar50
24/SAPSLL/CD01Country/Control Grouping (Legal Control Determination Level)2LGREGLegal Regulationnvarchar50
25/SAPSLL/CD02Country/Control Class (Legal Control Determination Level)2LGREGLegal Regulationnvarchar50
26/SAPSLL/CD03Country Grp/Control Grpg (Legal Control Determination Level)2LGREGLegal Regulationnvarchar50
27/SAPSLL/CD04Country Gp/Control Class (Legal Control Determination Level)2LGREGLegal Regulationnvarchar50
28/SAPSLL/CD05Country (Legal Control Determination Level)2LGREGLegal Regulationnvarchar50
29/SAPSLL/CD06Country Group (Legal Control Determination Level)2LGREGLegal Regulationnvarchar50
30/SAPSLL/CD07Control Grouping (Legal Control Determination Level)2LGREGLegal Regulationnvarchar50
31/SAPSLL/CD08Control Class: (Legal Control Determination Level)2LGREGLegal Regulationnvarchar50
32/SAPSLL/CD09Legal Regulation (Legal Control Determination Level)2LGREGLegal Regulationnvarchar50
33/SAPSLL/CD10Country/LoC Partner Group2LGREGLegal Regulationnvarchar50
34/SAPSLL/CD11Country Group/Partner Group LoC2LGREGLegal Regulationnvarchar50
35/SAPSLL/CD12Partner Group LoC (Legal Control Determination Level)2LGREGLegal Regulationnvarchar50
36/SAPSLL/CD13Country/Control Class/Grouping (Determ. Level Legal Control)2LGREGLegal Regulationnvarchar50
37/SAPSLL/CD14Country Group/Control Class/Grouping (Determ. Legal Regul.)2LGREGLegal Regulationnvarchar50
38/SAPSLL/CD15Control Class/Grouping (Determ. Level: Legal Regulation)2LGREGLegal Regulationnvarchar50
39/SAPSLL/CEEMBLegal Control: Country of Departure/Destination (Embargo)2LGREGLegal Regulationnvarchar50
40/SAPSLL/CMLBPCase Management Audit Business Partners5LGREGLegal Regulationnvarchar50
41/SAPSLL/CUCPASAssign Document to Communication Process2LGREGLegal Regulationnvarchar50
42/SAPSLL/CUCPCLHolding Locations3LGREGLegal Regulationnvarchar50
43/SAPSLL/CUCPRSAssign Procedures by Process / Legal Regulation2LGREGLegal Regulationnvarchar50
44/SAPSLL/CUCRPDGTS: Type of Registration for Process Action for Legal Req.2LGREGLegal Regulationnvarchar50
45/SAPSLL/CUCRPSGTS: Assign Customs Status per Process/Legal Regulation2LGREGLegal Regulationnvarchar50
46/SAPSLL/CUCVASAssign Declaration Type by Process / Legal Regulation2LGREGLegal Regulationnvarchar50
47/SAPSLL/CUHDBLRCustoms Document: Header: Blocked Legal Regulations3LGREGLegal Regulationnvarchar50
48/SAPSLL/CUITBLRCustoms Document: Item: Blocked Legal Regulations3LGREGLegal Regulationnvarchar50
49/SAPSLL/CUITPREGTS: Customs Document: Item: Preference Data4LGREGLegal Regulationnvarchar50
50/SAPSLL/CUPEDSupplementary Customs Declaration Header9LGREGLegal Regulationnvarchar50
51/SAPSLL/CUSWLDCustoms Processing: Procedures Completed for Customs Decl.9LGREGLegal Regulationnvarchar50
52/SAPSLL/CUSWLOWorklist for Transactions with Reference to Delivery or PO9LGREGLegal Regulationnvarchar50
53/SAPSLL/CUSWLSCustoms Worklist: Temporary Storage11LGREGLegal Regulationnvarchar50
54/SAPSLL/CUSWLTCustoms Worklist: Completed Temporary Storage11LGREGLegal Regulationnvarchar50
55/SAPSLL/DPDATAGTS: Condition for Generic Default Data3LGREGLegal Regulationnvarchar50
56/SAPSLL/KMATPREFGTS: Preference Processing KMAT - Storage of Results5LGREGLegal Regulationnvarchar50
57/SAPSLL/LCCUSMPTSLL: Reproduction of Customs Duty Types - Description4LGREGLegal Regulationnvarchar50
58/SAPSLL/LCLICLegal Control: License Header3LGREGLegal Regulationnvarchar50
59/SAPSLL/LC_CUSB1GTS: Custs Prcssng: Duty Cat: Non-EU Country Duty, Pharmac.4LGREGLegal Regulationnvarchar50
60/SAPSLL/LC_CUSB2GTS Customs Management: Toll Category: Preferred Customs4LGREGLegal Regulationnvarchar50
61/SAPSLL/LC_CUSC1Customs Processing: Duty Types Dependent on Trans.Conn.Point2LGREGLegal Regulationnvarchar50
62/SAPSLL/LC_CUSC2Customs Processing: Percentage Conditions2LGREGLegal Regulationnvarchar50
63/SAPSLL/LC_CUSC3Customs Processing: Transport Costs Dependent on Incoterms2LGREGLegal Regulationnvarchar50
64/SAPSLL/LC_CUSC5Customs Processing: Define Time-Dependent Percentages2LGREGLegal Regulationnvarchar50
65/SAPSLL/LC_CUSC6Customs Processing: Duty Types Dependent on Trans.Conn.Point2LGREGLegal Regulationnvarchar50
66/SAPSLL/LC_CUSMGTS: Customs Processing: Mapping of Customs Duty Types2LGREGLegal Regulationnvarchar50
67/SAPSLL/LC_CUSMPSLL: Customs Processing: Reproduction of Customs Duty Types3LGREGLegal Regulationnvarchar50
68/SAPSLL/LEGACTSLL: Customs Document: Activities5LGREGLegal Regulationnvarchar50
69/SAPSLL/LEGAGRGTS: References to Aggregated Document Items5LGREGLegal Regulationnvarchar50
70/SAPSLL/LEGCONLegal Control - Document5LGREGLegal Regulationnvarchar50
71/SAPSLL/LEGCULCSLL: Customs Document: Customs Processing: Duties5LGREGLegal Regulationnvarchar50
72/SAPSLL/LEGCUSCustoms Document: Customs Processing5LGREGLegal Regulationnvarchar50
73/SAPSLL/LEGLRGILegal Services: List of Services Still to Be Executed3LGREGLegal Regulationnvarchar50
74/SAPSLL/LEGTPRSLL: Customs Document: Shipment Procedure5LGREGLegal Regulationnvarchar50
75/SAPSLL/LRGCGPCountry Groups for Legal Regulation2LGREGLegal Regulationnvarchar50
76/SAPSLL/PRCONLegal Control - Product Master8LGREGLegal Regulationnvarchar50
77/SAPSLL/PREGPMAPMapping: Item-Specific Conditions for Rule Groups3LGREGLegal Regulationnvarchar50
78/SAPSLL/PRELGREGGTS: Preference: Agreement - Rule Group Assgmt (DP Upload)3LGREGLegal Regulationnvarchar50
79/SAPSLL/PRETFCNOGTS: Preference: Tariff Code Rule Grp f. Agreemt (DP Upload)3LGREGLegal Regulationnvarchar50
80/SAPSLL/PREVDIPreference: Long-Term Vendor Declaration Item4LGREGLegal Regulationnvarchar50
81/SAPSLL/PREVDITMPreference: Long-Term Vendor Declaration - Item4LGREGLegal Regulationnvarchar50
82/SAPSLL/PRFLRGSLL: Preference: Log: Preferred Zones3LGREGLegal Regulationnvarchar50
83/SAPSLL/PRNDT1Determine Messages for Activity3LGREGLegal Regulationnvarchar50
84/SAPSLL/PRPREFSLL: Product Master: Preference Data5LGREGLegal Regulationnvarchar50
85/SAPSLL/PRREXProduct Master: Re-Export Segment5LGREGLegal Regulationnvarchar50
86/SAPSLL/PSVLGREGGTS: Preference: Agreement - Rule Group Assgmnt (Man. Entry)3LGREGLegal Regulationnvarchar50
87/SAPSLL/PSVTFCNOGTS: Preference: Tariff Code Rule Grp f. Agreemt (Man.Entry)3LGREGLegal Regulationnvarchar50
88/SAPSLL/RESCOEFSLL: Restitution: Translation Coefficients3LGREGLegal Regulationnvarchar50
89/SAPSLL/RXPLRGRe-Export: Log: Legal Regulation4LGREGLegal Regulationnvarchar50
90/SAPSLL/SD09GTS: Determination of Security Type2LGREGLegal Regulationnvarchar50
91/SAPSLL/SECADJWLWorklist for Automatic Adjustment of Securities3LGREGLegal Regulationnvarchar50
92/SAPSLL/SPLAUDLegal Control - SPL - Audit8LGREGLegal Regulationnvarchar50
93/SAPSLL/SPLCTDLegal Control - SPL - Control Data for Comparison: Details2LGREGLegal Regulationnvarchar50
94/SAPSLL/SPLCTRLegal Control - SPL - Control Data for Comparison2LGREGLegal Regulationnvarchar50
95/SAPSLL/T606License Types2LGREGLegal Regulationnvarchar50
96/SAPSLL/T606GLegal Regulations2LGREGLegal Regulationnvarchar50
97/SAPSLL/T606GDLegal Control: Assignment of Deadline Type to Legal Reg.2LGREGLegal Regulationnvarchar50
98/SAPSLL/T606GTLegal Services: Texts for Legal Regulations3LGREGLegal Regulationnvarchar50
99/SAPSLL/T606SLegal Control: Status of License of Legal Regulation2LGREGLegal Regulationnvarchar50
100/SAPSLL/T606STLeg. Control: Text for Status of License of Legal Regulation3LGREGLegal Regulationnvarchar50
101/SAPSLL/T606SVLegal Control: Status Management per License Type2LGREGLegal Regulationnvarchar50
102/SAPSLL/T606TSLL: Legal Control: License Type - Description3LGREGLegal Regulationnvarchar50
103/SAPSLL/T608GSanctioned Party List: Group of List2LGREGLegal Regulationnvarchar50
104/SAPSLL/T608GTSanctioned Party List: Group of List - Name3LGREGLegal Regulationnvarchar50
105/SAPSLL/T608ISanctioned Party List: Type of Identification2LGREGLegal Regulationnvarchar50
106/SAPSLL/T608ITSanctioned Party List: Type of Identification - Name3LGREGLegal Regulationnvarchar50
107/SAPSLL/T608LLegal Control - SPL - Type of List2LGREGLegal Regulationnvarchar50
108/SAPSLL/T608LTLegal Control - SPL - Type of List - Reference3LGREGLegal Regulationnvarchar50
109/SAPSLL/T608RLegal Control - SPL - Type of Reference2LGREGLegal Regulationnvarchar50
110/SAPSLL/T608RTLegal Control: SPL - Type of Reference - Text3LGREGLegal Regulationnvarchar50
111/SAPSLL/TBO00GTS: Category of Bill of Product2LGREGLegal Regulationnvarchar50
112/SAPSLL/TBO00TGTS: Description for BOP Category2LGREGLegal Regulationnvarchar50
113/SAPSLL/TBO01GTS: Bill of Product - Item Category2LGREGLegal Regulationnvarchar50
114/SAPSLL/TBO01TGTS: Bill of Product - Item Category - Description2LGREGLegal Regulationnvarchar50
115/SAPSLL/TCGREXRe-Export Country Groups2LGREGLegal Regulationnvarchar50
116/SAPSLL/TCOADRGTS: Control of Relevant Business Partner Addresses2LGREGLegal Regulationnvarchar50
117/SAPSLL/TCULROGTS: Assignment of Obj. from Customs Code List to Legal Reg.2LGREGLegal Regulationnvarchar50
118/SAPSLL/TDPPROGTS: Procedure for Determining Default Data Procedure2LGREGLegal Regulationnvarchar50
119/SAPSLL/TEXREXRe-Export: Tariff Numbers Excluded from Calculation2LGREGLegal Regulationnvarchar50
120/SAPSLL/TLC_ASCGTS: Customs Management: Toll Procedure2LGREGLegal Regulationnvarchar50
121/SAPSLL/TLC_ASEGTS: Customs Processing: Duty Structure for Exports2LGREGLegal Regulationnvarchar50
122/SAPSLL/TLC_ASTGTS: Customs Processing: Duty Structure for Proc. Transit.2LGREGLegal Regulationnvarchar50
123/SAPSLL/TLC_ASUAssignment of Addends to Duty Lines3LGREGLegal Regulationnvarchar50
124/SAPSLL/TLC_ASVAssignment of Addends to Duty Lines3LGREGLegal Regulationnvarchar50
125/SAPSLL/TLC_ASWAssignment of Addends to Duty Lines3LGREGLegal Regulationnvarchar50
126/SAPSLL/TLC_CRULCalculation Rule for Customs Duty Calculation2LGREGLegal Regulationnvarchar50
127/SAPSLL/TLC_CRUTCalculation Rule for Customs Duty Calculation - Text3LGREGLegal Regulationnvarchar50
128/SAPSLL/TLECLControl Settings for Document Type / Legal Regulation3LGREGLegal Regulationnvarchar50
129/SAPSLL/TLECLSLeg. Ctrl: Activate Service for Item Categ./Legal Regulation4LGREGLegal Regulationnvarchar50
130/SAPSLL/TLECPLControl Data SCD Document Type / Legal Regulation3LGREGLegal Regulationnvarchar50
131/SAPSLL/TLECTGTax Statement: Determine Doc. Type through Legal Regulation2LGREGLegal Regulationnvarchar50
132/SAPSLL/TLEDPAFDetermination of Activity Sequence2LGREGLegal Regulationnvarchar50
133/SAPSLL/TLEGSUAssignment: Tariff Systems to Legal Regulations3LGREGLegal Regulationnvarchar50
134/SAPSLL/TLEGSVLeg. Srv.: Assign Tariff Systems to Legal Regulations3LGREGLegal Regulationnvarchar50
135/SAPSLL/TLEGTZAssign Time Zone to Deadline Type for Each Legal Regulation3LGREGLegal Regulationnvarchar50
136/SAPSLL/TLEPRCGTS: Customs Processing Type2LGREGLegal Regulationnvarchar50
137/SAPSLL/TLEPRCTGTS: Customs Processing Type Descriptions3LGREGLegal Regulationnvarchar50
138/SAPSLL/TLEUCGTS: External Country Definition for Data Upload2LGREGLegal Regulationnvarchar50
139/SAPSLL/TLEUCTGTS: External Country Definition for Data Upload - Descript.3LGREGLegal Regulationnvarchar50
140/SAPSLL/TMGVDSSPreference: Reminder Levels for Agreements4LGREGLegal Regulationnvarchar50
141/SAPSLL/TPFONOPreference: Assignment of Agreement to Rule Set2LGREGLegal Regulationnvarchar50
142/SAPSLL/TPREGSPreference: Assign Agreement to Schema2LGREGLegal Regulationnvarchar50
143/SAPSLL/TPRTXAssignment of Text Determination Procedure for Product Texts2LGREGLegal Regulationnvarchar50
144/SAPSLL/TRC01GTS: Restitution: Rounding Rules2LGREGLegal Regulationnvarchar50
145/SAPSLL/TRS01GTS: Restitution: CAP Recoding - Reference Type2LGREGLegal Regulationnvarchar50
146/SAPSLL/TRS01TGTS: Restitution: CAP Recoding - Reference Type2LGREGLegal Regulationnvarchar50
147/SAPSLL/TSHDTax Statement: Header10LGREGLegal Regulationnvarchar50
148/SAPSLL/TSPLLegal & Logistics Services: LC: SPL Master (Header Data)8LGREGLegal Regulationnvarchar50
149/SAPSLL/TVDFRMSPreference: Document for Agreement4LGREGLegal Regulationnvarchar50
150/SAPSLL/USGR01GTS: Assignment of User Groups to Legal Reg./FTO Document3LGREGLegal Regulationnvarchar50
151/SAPSLL/USGR03User Group Assignment to Legal Reg./FTO - Partner3LGREGLegal Regulationnvarchar50
152/SAPSLL/VDMTWLPreference: Worklist to Maintain LTVD via Web Dynpro6LGREGLegal Regulationnvarchar50
153/SAPSLL/VDOWLDETC-LTVD Worklist: Predefined Agreement Segments4LGREGLegal Regulationnvarchar50
154/SAPSLL/XLCLICTemporary Table for License Upload: Headers3LGREGLegal Regulationnvarchar50
TOPGTS Compliance Management
155/SAPSLL/CONXIControl Settings for XI Inbound Processing5LGREGLegal Regulationnvarchar50

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