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

61 columns | Print definition?ERP 6.0  | REFNO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/KPCC_LOGLog Credit Card Interface2REFNOReferencenvarchar190
2P2FI_CSISocial ins & result structure for Finland13REFNOReference number for paymentsnvarchar200
3P2FI_SISocial ins & result structure for Finland13REFNOReference number for paymentsnvarchar200
4P2RG_COURTTypes of Court Order (GB)11REFNOReference number (GB)nvarchar200
5T7ID1REmployee Reference Number for Tax Form 1721-A15REFNOEmployee Reference No. for Tax form 1721-A1nvarchar70
TOPBank Customer Accounts
6BKKPOGISLEDI Payments: Reporting Data to Clearing, Seg. E1IDT024REFNOReference no.nvarchar30
7BKKPOREFAReferences for EDI Payments, Position, Amount Segment5REFNOReference no.nvarchar30
8BKKPOREFDReferences to EDI Payments, Item, Date Segment5REFNOReference no.nvarchar30
9BKKPOREFLReferences for EDI Payments, Header data, Long Texts4REFNOReference no.nvarchar30
10BKKPOREFRReferences for EDI Payments, Position, Ref. Data Segment5REFNOReference no.nvarchar30
TOPClaims Management
11ICLITEMClaim Item59REFNOExternal Reference Numbernvarchar150
12ICLITEMAUDamaged Vehicle73REFNOExternal Reference Numbernvarchar150
13ICLITEMSVSalvage Item Evaluation12REFNOReference numbernvarchar100
14ICLPAYIClaim Payment Item25REFNOExternal Reference Numbernvarchar150
15ICLREFCoverage Referral in Claim6REFNOCoverage Referral Numbernvarchar30
16ICSITEMClaim Item59REFNOExternal Reference Numbernvarchar150
17ICSITEMAUDamaged Vehicle73REFNOExternal Reference Numbernvarchar150
18ICSITEMSVSalvage Item Evaluation12REFNOReference numbernvarchar100
19ICSPAYIPayment Item25REFNOExternal Reference Numbernvarchar150
20ICSREFCoverage Referral in Claim6REFNOCoverage Referral Numbernvarchar30
TOPCorporate Performance Monitor
21UMK_MB020Measure Hierarchy4REFNOReference Numbernvarchar320
TOPFinland
22T7FI02Pension insurance table (Finland)7REFNOReference number for paymentsnvarchar200
TOPForeign Trade
23/SAPSLL/OBJIDXSLL: R/3 BS: Index of Documents Not Transferred4REFNOReference Number of a Document from Backend System for SLLnvarchar400
24/SAPSLL/OBJSSFGTS: R/3 FS: Index of Documents to Be Released3REFNOReference Number of a Document from Backend System for SLLnvarchar400
25/SAPSLL/OBJSYNCGTS: R/3 Feeder System: Index of Generated Documents2REFNOReference Number of a Document from Backend System for SLLnvarchar400
TOPGlobal Trade Services
26/SAPSLL/CORREFReference Data6REFNOReference Numbernvarchar400
27/SAPSLL/CWLPCPWorklist: Installation Statement FC w/PEU3REFNOReference Numbernvarchar400
28/SAPSLL/KMATWLGTS: KMAT Worklist6REFNOReference Numbernvarchar400
29/SAPSLL/LEGCOLContainer Management in Safekeeping7REFNOReference Numbernvarchar400
30/SAPSLL/LEGCOMSLL: Customs Document: Communiation Numbers6REFNOReference Numbernvarchar400
31/SAPSLL/LEGMESSLL: Customs Document: Messages for Each Activity27REFNOReference Numbernvarchar400
32/SAPSLL/LEGPEUClosing of Free Circulation with Prescribed End Use4REFNOReference Numbernvarchar400
33/SAPSLL/LEGREFSLL: Customs Document: External Reference Objects6REFNOReference Numbernvarchar400
34/SAPSLL/MODKMATSLL: KMAT Model5REFNOReference Numbernvarchar400
35/SAPSLL/PREVDAUDSLL: Preference: Vend.Decl. for Customer Purp.: Audit5REFNOReference Numbernvarchar400
36/SAPSLL/PREVDHPreference: Long-Term Vendor Declaration Header29REFNOReference Numbernvarchar400
37/SAPSLL/PREVDWLOSLL: Preference: Vend.Decl. f. Cust. Purp. - Worklist6REFNOReference Numbernvarchar400
38/SAPSLL/SPLAUDLegal Control - SPL - Audit30REFNOReference Numbernvarchar400
39/SAPSLL/SPLAUDRAudit Trail for SPL Screening - Additional Object References17REFNOReference Numbernvarchar400
40/SAPSLL/VDOWLWorklist: Vendor Declaration for Customer's Purpose10REFNOReference Numbernvarchar400
TOPGreat Britain
41PA0070HR Master Record: Infotype 0070 (Court Orders - GB)24REFNOReference number (GB)nvarchar200
TOPHong Kong
42T7HK3BEntitlement plan attributes6REFNOProvider's plan reference numbernvarchar200
TOPIndonesia
43PA0241Indonesian Tax Data27REFNOUnemployment Reference Numbernvarchar300
TOPIntercompany Data Exchange
44IUEEDPPLOTATREFDistr. Aggr. Payments: Ref. btwn MR and Distributed Objects4REFNOConsecutive Number for Referencing a Payment Lot Itemnvarchar30
45IUEEDPPLOTATREF1Distr. Aggr. Payments: Ref. Between Pymt St. and Aggr. Pymt4REFNOConsecutive Number for Referencing a Payment Lot Itemnvarchar30
TOPJoint Venture und Production Sharing Accounting
46T8JDKJV EDI Inbound: 819 Cost Object (Ref) Mapping Table6REFNOReference Numbernvarchar300
47T8JDLJV EDI Inbound: 819 Cost Object (Ref + Class) Mapping6REFNOReference Numbernvarchar300
48T8JDMJV EDI Inbound: 819 Cost Object (Ref, Class, Subclass A)6REFNOReference Numbernvarchar300
49T8JDPJV EDI Inbound: Memo AFE Table5REFNOReference Numbernvarchar300
TOPMalaysia
50T5LESESS Malaysia: TP1 TP28REFNOReference No.nvarchar170
TOPNew Zealand
51T7NZSFSuperannuation Fund Code Designation NZ6REFNOSuperannuation Fund Employer Numbernvarchar150
TOPPersonnel Administration
52PA0811HR Master Record: Infotype 081126REFNOPension Reference Numbernvarchar100
TOPPublic Sector
53PA0487HR-SG-PS: Security / medical Clearance27REFNOMINDEF Reference Numbernvarchar200
54PA0502Letter of appointment28REFNOMINDEF Reference Numbernvarchar200
55PB0502Letter of appointment28REFNOMINDEF Reference Numbernvarchar200
TOPSecurity Deposits
56FKK_SEC_NNoncash Security Deposit5REFNOReference number for non-cash security depositnvarchar400
TOPSouth Africa
57PA0149HR Master Record Infotype 0149 (Tax Data South Africa)25REFNOTax Reference Number ZAnvarchar100
58T5WERSouth Africa - IRP5 Company Contact Person Details2REFNOTax Reference Number ZAnvarchar100
59T5WITA88ITA88 Transaction Table14REFNOTax Reference Number ZAnvarchar100
TOPWarranty Claim Processing
60PNWTYHWarranty Claim Header (PVS Node)8REFNOExternal Number of Claimnvarchar400
61WTY_ARCH_IDXIndex Table for Archiving Warranty Claims4REFNOExternal Number of Claimnvarchar400