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

118 columns | Print definition?ERP 6.0  | CUSCS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPGlobal Trade Services
1/SAPSLL/CUCAARGTS: Toll Types2CUSCSCustoms Code List Procedurenvarchar50
2/SAPSLL/CUCAARTSLL: Toll Types - Description3CUSCSCustoms Code List Procedurenvarchar50
3/SAPSLL/CUCAFAGTS: Requested Concession2CUSCSCustoms Code List Procedurenvarchar50
4/SAPSLL/CUCAFATGTS: Description of Requested Concession3CUSCSCustoms Code List Procedurenvarchar50
5/SAPSLL/CUCAGGGTS: Tax Assessment Duty Group2CUSCSCustoms Code List Procedurenvarchar50
6/SAPSLL/CUCAGGTGTS: Tax Assessment Duty Group - Description3CUSCSCustoms Code List Procedurenvarchar50
7/SAPSLL/CUCAORReason for Rejection2CUSCSCustoms Code List Procedurenvarchar50
8/SAPSLL/CUCAORTReason for Rejection - Name3CUSCSCustoms Code List Procedurenvarchar50
9/SAPSLL/CUCAPRGTS: Additional Procedure2CUSCSCustoms Code List Procedurenvarchar50
10/SAPSLL/CUCAPRTSLL: Additional Procedures - Description3CUSCSCustoms Code List Procedurenvarchar50
11/SAPSLL/CUCBMSGTS: Tax Assessment Measure2CUSCSCustoms Code List Procedurenvarchar50
12/SAPSLL/CUCBMSTGTS: Tax Assessment Measure - Description3CUSCSCustoms Code List Procedurenvarchar50
13/SAPSLL/CUCCNRReason for Cancellation2CUSCSCustoms Code List Procedurenvarchar50
14/SAPSLL/CUCCNRTReason for Cancellation - Text3CUSCSCustoms Code List Procedurenvarchar50
15/SAPSLL/CUCCPGContainer Status2CUSCSCustoms Code List Procedurenvarchar50
16/SAPSLL/CUCCPGTContainer Status3CUSCSCustoms Code List Procedurenvarchar50
17/SAPSLL/CUCDADDefinition of Customs Duty Types2CUSCSCustoms Code List Procedurenvarchar50
18/SAPSLL/CUCDADMMapping of Customs Duty Types2CUSCSCustoms Code List Procedurenvarchar50
19/SAPSLL/CUCDADTDefinition of Customs Duty Types: Text Table3CUSCSCustoms Code List Procedurenvarchar50
20/SAPSLL/CUCDCGTS: Type of Registration for Global Trade Services2CUSCSCustoms Code List Procedurenvarchar50
21/SAPSLL/CUCDCTGTS: Description of Registration Type for Global Trade Srv3CUSCSCustoms Code List Procedurenvarchar50
22/SAPSLL/CUCDSTType of Destination2CUSCSCustoms Code List Procedurenvarchar50
23/SAPSLL/CUCDSTTType of Destination - Name3CUSCSCustoms Code List Procedurenvarchar50
24/SAPSLL/CUCEXPExplanation2CUSCSCustoms Code List Procedurenvarchar50
25/SAPSLL/CUCEXPTExplanation - Text3CUSCSCustoms Code List Procedurenvarchar50
26/SAPSLL/CUCFDPFDA Package Types2CUSCSCustoms Code List Procedurenvarchar50
27/SAPSLL/CUCFDPTFDA Package Types - Name3CUSCSCustoms Code List Procedurenvarchar50
28/SAPSLL/CUCGUCConstellation of Guarantors2CUSCSCustoms Code List Procedurenvarchar50
29/SAPSLL/CUCGUCTConstellation of Guarantors - Text3CUSCSCustoms Code List Procedurenvarchar50
30/SAPSLL/CUCINDGTS: Customs Processing Indicator2CUSCSCustoms Code List Procedurenvarchar50
31/SAPSLL/CUCINDTGTS: Customs Processing Indicator3CUSCSCustoms Code List Procedurenvarchar50
32/SAPSLL/CUCINRReason for Interruption2CUSCSCustoms Code List Procedurenvarchar50
33/SAPSLL/CUCINRTReason for Interruption - Name3CUSCSCustoms Code List Procedurenvarchar50
34/SAPSLL/CUCMESMessage Codes2CUSCSCustoms Code List Procedurenvarchar50
35/SAPSLL/CUCMESTMessage Code Names3CUSCSCustoms Code List Procedurenvarchar50
36/SAPSLL/CUCMOTSLL: Type of Means of Transport2CUSCSCustoms Code List Procedurenvarchar50
37/SAPSLL/CUCMOTTSLL: Description of Type of Transport3CUSCSCustoms Code List Procedurenvarchar50
38/SAPSLL/CUCMTRSLL: Mode of Transport2CUSCSCustoms Code List Procedurenvarchar50
39/SAPSLL/CUCMTRTSLL: Description of Type of Transport3CUSCSCustoms Code List Procedurenvarchar50
40/SAPSLL/CUCNGASLL: Range of Goods2CUSCSCustoms Code List Procedurenvarchar50
41/SAPSLL/CUCNGATSLL: Range of Goods - Description3CUSCSCustoms Code List Procedurenvarchar50
42/SAPSLL/CUCORGType of Departure2CUSCSCustoms Code List Procedurenvarchar50
43/SAPSLL/CUCORGTType of Issue - Name3CUSCSCustoms Code List Procedurenvarchar50
44/SAPSLL/CUCPASAssign Document to Communication Process6CUSCSCustoms Code List Procedurenvarchar50
45/SAPSLL/CUCPATSLL: Documents/Preliminary Documents2CUSCSCustoms Code List Procedurenvarchar50
46/SAPSLL/CUCPATTSLL: Description of Preliminary Docmt Types3CUSCSCustoms Code List Procedurenvarchar50
47/SAPSLL/CUCPOPIssuing Authority2CUSCSCustoms Code List Procedurenvarchar50
48/SAPSLL/CUCPOPTIssuing Authority Name3CUSCSCustoms Code List Procedurenvarchar50
49/SAPSLL/CUCPQUQualifier of Document2CUSCSCustoms Code List Procedurenvarchar50
50/SAPSLL/CUCPQUTQualifier of Document - Name3CUSCSCustoms Code List Procedurenvarchar50
51/SAPSLL/CUCPROGTS: Place into a Customs Status2CUSCSCustoms Code List Procedurenvarchar50
52/SAPSLL/CUCPROTGTS: Place into a Customs Status - Description3CUSCSCustoms Code List Procedurenvarchar50
53/SAPSLL/CUCPRSAssign Procedures by Process / Legal Regulation6CUSCSCustoms Code List Procedurenvarchar50
54/SAPSLL/CUCPSTStatus of a Document2CUSCSCustoms Code List Procedurenvarchar50
55/SAPSLL/CUCPSTTStatus of a Document - Name3CUSCSCustoms Code List Procedurenvarchar50
56/SAPSLL/CUCPTYSLL: Package Types2CUSCSCustoms Code List Procedurenvarchar50
57/SAPSLL/CUCPTYTSLL: Package Types - Description3CUSCSCustoms Code List Procedurenvarchar50
58/SAPSLL/CUCPYTSLL: Payment Methods2CUSCSCustoms Code List Procedurenvarchar50
59/SAPSLL/CUCPYTTSLL: Description of Payment Methods3CUSCSCustoms Code List Procedurenvarchar50
60/SAPSLL/CUCRCDDefinition: Reason for Reconciliation Summary2CUSCSCustoms Code List Procedurenvarchar50
61/SAPSLL/CUCRCDTText Table for /SAPSLL/CUCRCD2CUSCSCustoms Code List Procedurenvarchar50
62/SAPSLL/CUCRCMMapping: Reason for Change to Duty Type2CUSCSCustoms Code List Procedurenvarchar50
63/SAPSLL/CUCRESSLL: Customs Control Results2CUSCSCustoms Code List Procedurenvarchar50
64/SAPSLL/CUCRESTSLL: Description of Customs Control Results3CUSCSCustoms Code List Procedurenvarchar50
65/SAPSLL/CUCRPDGTS: Type of Registration for Process Action for Legal Req.7CUSCSCustoms Code List Procedurenvarchar50
66/SAPSLL/CUCRPSGTS: Assign Customs Status per Process/Legal Regulation6CUSCSCustoms Code List Procedurenvarchar50
67/SAPSLL/CUCSLTSLL: Fastening Types2CUSCSCustoms Code List Procedurenvarchar50
68/SAPSLL/CUCSLTTSLL: Description of Fastening Types3CUSCSCustoms Code List Procedurenvarchar50
69/SAPSLL/CUCSTGTS: Customs Status2CUSCSCustoms Code List Procedurenvarchar50
70/SAPSLL/CUCSTASLL: Customs Status of Goods2CUSCSCustoms Code List Procedurenvarchar50
71/SAPSLL/CUCSTATSLL: Description of Customs Status of Goods3CUSCSCustoms Code List Procedurenvarchar50
72/SAPSLL/CUCSTTGTS: Customs Status - Description3CUSCSCustoms Code List Procedurenvarchar50
73/SAPSLL/CUCSUSGTS: Deferment Processing2CUSCSCustoms Code List Procedurenvarchar50
74/SAPSLL/CUCSUSTSLL: Description of Deferment Types3CUSCSCustoms Code List Procedurenvarchar50
75/SAPSLL/CUCTOEType of Event2CUSCSCustoms Code List Procedurenvarchar50
76/SAPSLL/CUCTOETType of Event - Name3CUSCSCustoms Code List Procedurenvarchar50
77/SAPSLL/CUCTRSTransport Administrator2CUSCSCustoms Code List Procedurenvarchar50
78/SAPSLL/CUCTRSTShipper - Name3CUSCSCustoms Code List Procedurenvarchar50
79/SAPSLL/CUCTVATGTS: VAT Category2CUSCSCustoms Code List Procedurenvarchar50
80/SAPSLL/CUCTVATTGTS: VAT Category - Name3CUSCSCustoms Code List Procedurenvarchar50
81/SAPSLL/CUCUSRReason for Complaint2CUSCSCustoms Code List Procedurenvarchar50
82/SAPSLL/CUCUSRTReason for Complaint - Name3CUSCSCustoms Code List Procedurenvarchar50
83/SAPSLL/CUCVAGTS: Entry Type2CUSCSCustoms Code List Procedurenvarchar50
84/SAPSLL/CUCVASAssign Declaration Type by Process / Legal Regulation6CUSCSCustoms Code List Procedurenvarchar50
85/SAPSLL/CUCVATGTS: Entry Type - Description3CUSCSCustoms Code List Procedurenvarchar50
86/SAPSLL/CUCWGRWine Region2CUSCSCustoms Code List Procedurenvarchar50
87/SAPSLL/CUCWGRTWine Region - Name3CUSCSCustoms Code List Procedurenvarchar50
88/SAPSLL/CUCWOPTreatment of Wine Product2CUSCSCustoms Code List Procedurenvarchar50
89/SAPSLL/CUCWOPTProcessing of Wine Product - Text3CUSCSCustoms Code List Procedurenvarchar50
90/SAPSLL/CUCWPRWine Category2CUSCSCustoms Code List Procedurenvarchar50
91/SAPSLL/CUCWPRTWine Category - Name3CUSCSCustoms Code List Procedurenvarchar50
92/SAPSLL/CUCZAFGTS: Payment Demand for Tax Assessment2CUSCSCustoms Code List Procedurenvarchar50
93/SAPSLL/CUCZAFTGTS: Payment Demand for Tax Assessment - Description3CUSCSCustoms Code List Procedurenvarchar50
94/SAPSLL/LEGBTCustoms Business Transaction Types2CUSCSCustoms Code List Procedurenvarchar50
95/SAPSLL/LEGBTTCustoms Business Transaction Types - Description3CUSCSCustoms Code List Procedurenvarchar50
96/SAPSLL/LEGEPSLL: Export Types2CUSCSCustoms Code List Procedurenvarchar50
97/SAPSLL/LEGEPTSLL: Export Types Description3CUSCSCustoms Code List Procedurenvarchar50
98/SAPSLL/LEGSLTSLL: Headquarters of Importer2CUSCSCustoms Code List Procedurenvarchar50
99/SAPSLL/LEGSLTTSLL: Headquarters of Importer: Description3CUSCSCustoms Code List Procedurenvarchar50
100/SAPSLL/LEGSSTSLL: Status of Statistics2CUSCSCustoms Code List Procedurenvarchar50
101/SAPSLL/LEGSSTTSLL: Statistics Status - Description3CUSCSCustoms Code List Procedurenvarchar50
102/SAPSLL/PRDOCProduct Master: Documents / Verifications4CUSCSCustoms Code List Procedurenvarchar50
103/SAPSLL/TCUCSSLL: Procedure for Customs Code Lists2CUSCSCustoms Code List Procedurenvarchar50
104/SAPSLL/TCUCSTSLL: Procedure for Customs Code Lists - Description3CUSCSCustoms Code List Procedurenvarchar50
105/SAPSLL/TCULROGTS: Assignment of Obj. from Customs Code List to Legal Reg.4CUSCSCustoms Code List Procedurenvarchar50
106/SAPSLL/TLECGSMap FS Container Status to Cont. Status at FS Group Level4CUSCSCustoms Code List Procedurenvarchar50
107/SAPSLL/TLECVSMapping FS Container Status to Container Status at FS Level4CUSCSCustoms Code List Procedurenvarchar50
108/SAPSLL/TLELGSMapping of Seal Type fr. Feed.Sys. Group to GTS Seal Type4CUSCSCustoms Code List Procedurenvarchar50
109/SAPSLL/TLELVSMapping of Feeder System Seal Type to GTS Seal Type4CUSCSCustoms Code List Procedurenvarchar50
110/SAPSLL/TLEMGSMapping FS Mode of Transport to MoS at FS Group Level4CUSCSCustoms Code List Procedurenvarchar50
111/SAPSLL/TLEMVSMapping FS Mode of Transport to Mode of Transp. at FS Level4CUSCSCustoms Code List Procedurenvarchar50
112/SAPSLL/TLEPRNGTS: Message for Global Trade Services Activity6CUSCSCustoms Code List Procedurenvarchar50
113/SAPSLL/TLERCMapping of Route Code to GTS-Relevant Route Info3CUSCSCustoms Code List Procedurenvarchar50
114/SAPSLL/TLESGSMapping Pack.Mat.Type Group. Backend System to Pack.Type GTS4CUSCSCustoms Code List Procedurenvarchar50
115/SAPSLL/TLESVSMapping Pack. Mat. Type Backend System to Package Type GTS4CUSCSCustoms Code List Procedurenvarchar50
116/SAPSLL/TLEVPGDerive Package Type from Sales Unit2CUSCSCustoms Code List Procedurenvarchar50
117/SAPSLL/TQUALType of Document2CUSCSCustoms Code List Procedurenvarchar50
118/SAPSLL/TQUALTType of Document - Name3CUSCSCustoms Code List Procedurenvarchar50

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