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

37 columns | Print definition?ERP 6.0  | ECPID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPCross-Application Components
1/SAPSLL/ECPPACustoms Product Master (Replicate)3ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
2/SAPSLL/TECPIDCustoms ID for Customs Procedure with Economic Significance2ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
TOPForeign Trade
3/SAPSLL/BWHSTR3Customs WH-Relevant Data for Two-Step Stock Transfer Process4ECPIDCustoms ID for Customs Procedure with Economic Impactnvarchar100
4/SAPSLL/TECOR3Assignment of Customs ID to Plant/Storage Location4ECPIDCustoms ID for Customs Procedure with Economic Impactnvarchar100
5/SAPSLL/TECOR3OPCustoms ID Assignment to Plant for Outward Processing3ECPIDCustoms ID for Customs Procedure with Economic Impactnvarchar100
TOPGlobal Trade Services
6/SAPSLL/CCMHDCustoms Warehouse Collective Completion - Header7ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
7/SAPSLL/CCMWLAWorklist: Customs Warehouse Collective Completion (Open)3ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
8/SAPSLL/CCMWLBWorklist: CWH Collective Completion (Completed)3ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
9/SAPSLL/CUHDCustoms Document: Header38ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
10/SAPSLL/CUITCustoms Document: Item73ECPIDCustoms ID for Customs Procedures CWH, IP, PUCCnvarchar100
11/SAPSLL/CUPEDSupplementary Customs Declaration Header27ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
12/SAPSLL/CUSWLAWorklist for Quantity Comparison Goods Issue/Customs Doc.16ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
13/SAPSLL/CUSWLBCustoms Worklist: Qty Adjustment - Completed Transactions20ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
14/SAPSLL/CUSWLDCustoms Processing: Procedures Completed for Customs Decl.16ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
15/SAPSLL/CUSWLEWorklist for Processing Domestic Customs Warehouse Issues15ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
16/SAPSLL/CUSWLFCustoms Worklist: Domestic Issues - Completed Transactions15ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
17/SAPSLL/CUSWLMQuantity Comparison: Customs Declaration/Goods Receipt29ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
18/SAPSLL/CUSWLNCompleted Quantity Comparisons Customs Declaration/GR29ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
19/SAPSLL/CUSWLOWorklist for Transactions with Reference to Delivery or PO16ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
20/SAPSLL/CUSWLPCustoms Worklist: Periodic Declarations13ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
21/SAPSLL/CUSWLQCustoms Worklist: Per. Declarations - Completed Transactions13ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
22/SAPSLL/CUSWLSCustoms Worklist: Temporary Storage14ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
23/SAPSLL/CUSWLTCustoms Worklist: Completed Temporary Storage14ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
24/SAPSLL/CWLCCPWorklist of Export Items to Determine IP Closing Portions4ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
25/SAPSLL/GPASTOCKShared, Periodic, and Completed Stock2ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
26/SAPSLL/IVMCST01Indiv. Stock Item: Special Customs Procedures: Inward Proc.3ECPIDCustoms Warehouse IDnvarchar100
27/SAPSLL/IVMCST02Totals Stock: Special Customs Procedure: Inward Processing3ECPIDCustoms Warehouse IDnvarchar100
28/SAPSLL/IVMPST01Processing Stock3ECPIDCustoms Warehouse IDnvarchar100
29/SAPSLL/IVMSSFFrozen Individual Stock Item for Customs Warehouse3ECPIDCustoms Warehouse IDnvarchar100
30/SAPSLL/IVMSSFHDFrozen Individual Stock Item for Customs Warehouse - Header3ECPIDCustoms Warehouse IDnvarchar100
31/SAPSLL/LEGSCPClosings of Special Customs Procedures (IP / PUCC)10ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
32/SAPSLL/PRBWHGTS Product Master: BW Relevance per Logical System4ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
33/SAPSLL/PRECIPProduct Master: Data for Special Customs Procedures4ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
34/SAPSLL/PRERRGTS: Prod.Master: Replication of Special Cust.Procedure Data4ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
35/SAPSLL/PRRECOP - Product/Receiver Assignment3ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
36/SAPSLL/TCOECPAssignment of Customs ID for Customs Procedure2ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100
37/SAPSLL/TECPIDMCustoms ID Mapping to Short Version - PC2ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100