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

50 columns | Print definition?ERP 6.0  | LAUNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBasic Functions
1EIZOFT: Exp/Imp ident. of goods, pres. of goods for cust.declar.5LAUNRSequential number for legal controlnvarchar50
2FSLSAForeign Trade: Legal Control-Sanctioned Party List-Address3LAUNRSequential number for legal controlnvarchar50
3FSLSDKWForeign Trade: Legal Control: SLS: Keywords from Addresses3LAUNRSequential number for legal controlnvarchar50
4FSLSNForeign Trade: Legal Control - Sanctioned Party List - Names3LAUNRSequential number for legal controlnvarchar50
5FSLSTForeign Trade: Legal Control - SLS - Audit Trail11LAUNRSequential number for legal controlnvarchar50
6FSLSTAForeign Trade: Legal Control - SLS - Audit Trail11LAUNRSequential number for legal controlnvarchar50
7FSLSWForeign Trade: Legal Control - Sanct. Party List - Keyword4LAUNRSequential number for legal controlnvarchar50
8FSLSWCFT: Legal Control: Sanct. Party List - Collected Key Words6LAUNRSequential number for legal controlnvarchar50
9FTGKLLegal Control: Log (Up-to-Date)7LAUNRSequential number for legal controlnvarchar50
10FTGKLALegal Control: Log (Prestep for Archiving)7LAUNRSequential number for legal controlnvarchar50
11T606MLegal Control: Product Classification by Destinat. Ctry6LAUNRSequential number for legal controlnvarchar50
12T606NLegal Control: Product Classification by Country Grouping6LAUNRSequential number for legal controlnvarchar50
13T606PGLegal Control: Partner Functions for Grouping Partners3LAUNRSequential number for legal controlnvarchar50
TOPForeign Trade
14/SAPSLL/OBJIDXSLL: R/3 BS: Index of Documents Not Transferred10LAUNRNatural Numberint100
TOPGlobal Trade Services
15/SAPSLL/ADRCMPKWGTS: Prepared Address for Address Comparison: Search Terms4LAUNRSequence Numbernvarchar50
16/SAPSLL/BOPITCOEGTS: Bill of Product - Basic Products per Item4LAUNRSequence Numbernvarchar50
17/SAPSLL/CORCTZCustoms Document Reference Codes8LAUNRSequence Numbernvarchar50
18/SAPSLL/CORPARDocument Partner13LAUNRSequence Numbernvarchar50
19/SAPSLL/CTSGENTL & L Services: Text for Generic Customs Tariff No.5LAUNRSequence Numbernvarchar50
20/SAPSLL/CTSNUMCTL&L Services - Text for Country-Specific Customs Tariff No.5LAUNRSequence Numbernvarchar50
21/SAPSLL/CTSNUMTLegal & Logistics Services - Text for Customs Tariff No.5LAUNRSequence Numbernvarchar50
22/SAPSLL/CTSTXTKSLL: Numbering System: Search Terms for the Numbering Texts11LAUNRSequence Numbernvarchar50
23/SAPSLL/CTSTXTTTexts for Customs Tariff Numbering System (Rule Set)4LAUNRSequence Numbernvarchar50
24/SAPSLL/LC_CUSMNGTS: Customs Processing: Measures Relating to Duty Rate4LAUNRSequence Numbernvarchar50
25/SAPSLL/LEGCTRCustoms Document: Involved Countries5LAUNRSequence Numbernvarchar50
26/SAPSLL/LEGCULCSLL: Customs Document: Customs Processing: Duties6LAUNRSequence Numbernvarchar50
27/SAPSLL/LEGDOCSLL: Customs Document: Documents7LAUNRSequence Numbernvarchar50
28/SAPSLL/LEGEVESLL: Customs Document: Events5LAUNRSequence Numbernvarchar50
29/SAPSLL/LEGPLOSLL: Customs Document: Seals5LAUNRSequence Numbernvarchar50
30/SAPSLL/MILOMAContent Migration Log - Header Data5LAUNRSequence Numbernvarchar50
31/SAPSLL/PRDOCProduct Master: Documents / Verifications7LAUNRSequence Numbernvarchar50
32/SAPSLL/PREVDNEGSLL: Preference: Negative Long-Term Vendor Declaration4LAUNRSequence Numbernvarchar50
33/SAPSLL/PRPREFNGSLL: Product Master: Preference Data4LAUNRSequence Numbernvarchar50
34/SAPSLL/SECADJWLWorklist for Automatic Adjustment of Securities8LAUNRSequence Numbernvarchar50
35/SAPSLL/SECFINGTS: Guarantees - Refinancing5LAUNRSequence Numbernvarchar50
36/SAPSLL/SPLAUDMAudit Trail SPL Screening - Matched Search Terms4LAUNRSequence Numbernvarchar50
37/SAPSLL/SPLAUDRAudit Trail for SPL Screening - Additional Object References4LAUNRSequence Numbernvarchar50
38/SAPSLL/TLC_ASCGTS: Customs Management: Toll Procedure3LAUNRSequence Numbernvarchar50
39/SAPSLL/TLC_ASEGTS: Customs Processing: Duty Structure for Exports3LAUNRSequence Numbernvarchar50
40/SAPSLL/TLC_ASTGTS: Customs Processing: Duty Structure for Proc. Transit.3LAUNRSequence Numbernvarchar50
41/SAPSLL/TLC_ASUAssignment of Addends to Duty Lines4LAUNRSequence Numbernvarchar50
42/SAPSLL/TLC_ASVAssignment of Addends to Duty Lines4LAUNRSequence Numbernvarchar50
43/SAPSLL/TLC_ASWAssignment of Addends to Duty Lines4LAUNRSequence Numbernvarchar50
44/SAPSLL/TSPLALegal Control: SPL Master (Address Data)9LAUNRSequence Numbernvarchar50
45/SAPSLL/TSPLAKLegal Control: SPL Master (Address Data) - Keywords9LAUNRSequence Numbernvarchar50
46/SAPSLL/TSPLBSPL Master (Dates of Birth)4LAUNRSequence Numbernvarchar50
47/SAPSLL/TSPLISPL Master (Identifications)5LAUNRSequence Numbernvarchar50
48/SAPSLL/TSPLNLegal Control: SPL Master (Name Data)9LAUNRSequence Numbernvarchar50
49/SAPSLL/TSPLNKLegal Control: SPL Master (Name Data) - Keywords9LAUNRSequence Numbernvarchar50
50/SAPSLL/TSPLRSanctioned Party List Master (References)5LAUNRSequence Numbernvarchar50