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

95 columns | Print definition?ERP 6.0  | REFNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IBS/TRB_ECF_PCFRBD ECF - Provision Cash Flow20REFNRRBD: Referencenvarchar350
2/IBS/TRB_ECF_PCORBD ECF - Provision Collateral25REFNRRBD: Referencenvarchar350
3/IBS/TRB_ECF_PUTRBD ECF - Provision Utilization18REFNRRBD: Referencenvarchar350
4/IBS/TRB_ECF_VCFRBD ECF - Value Adjustment - Cash Flow18REFNRRBD: Referencenvarchar350
5/IBS/TRB_ECF_VCORBD ECF - Value Adjustment - Collateral23REFNRRBD: Referencenvarchar350
6/IBS/TRB_ECH_PCFRBD ECF - Provision History - Cash Flow21REFNRRBD: Referencenvarchar350
7/IBS/TRB_ECH_PCORBD ECF - Provision History - Collateral26REFNRRBD: Referencenvarchar350
8/IBS/TRB_ECH_PUTRBD ECF - Provision History - Utilization19REFNRRBD: Referencenvarchar350
9/IBS/TRB_ECH_VCFRBD ECF - Value Adjustment History - Cash Flow19REFNRRBD: Referencenvarchar350
10/IBS/TRB_ECH_VCORBD ECF - Value Adjustment History - Collateral24REFNRRBD: Referencenvarchar350
11/IBS/TRB_ECI_CFRBD ECF - Cash Flow Import Table14REFNRRBD: Referencenvarchar350
12/IBS/TRB_ECI_CORBD ECF - Import Table for Collateral19REFNRRBD: Referencenvarchar350
13/IBS/TRB_KTO_PRPRBD Account. Master Data11REFNRRBD: Reference Number Source Systemnvarchar1000
14P2PL_EABPayroll Result PL: Split Y, absences15REFNRReference numbernvarchar80
15P2RB_PENSPensioner's data (B)13REFNRReference numbernvarchar200
16P2RO_RO_ABXExtension of AB table7REFNRReference numbernvarchar80
17P2UA_UAILLstruc.UAILL - information about sick-list compensation calc.19REFNRReference numbernvarchar80
18PA3347HR Master Record Infotype 334724REFNRRelationship Between Periodsnvarchar20
19T77WWW_CLFDATTable to store the file data stored in third party server3REFNRRequest Reference Numbernvarchar130
20T77WWW_CLTRANSDCluster table for storing transaction data.4REFNRRequest Reference Numbernvarchar130
21T77WWW_CLTRAN_BUBackup Table for Storing Transaction Data4REFNRRequest Reference Numbernvarchar130
22TKO01Control parameters for order type3REFNRReference order numbernvarchar120
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
23CRM_CATLCATT: Log Process Data7REFNRCATT - Referred test casenvarchar300
24CRM_CATMCATT: Log for model and function data10REFNRCATT - Referred test casenvarchar300
TOPAddress ManagementBusiness Address
25SADRPAddress Management: Personal Data32REFNRAddress reference for alias namesnvarchar100
TOPAustria
26T5A1O_REFELDA: Reference Number2REFNRReference Numbernvarchar300
27T5A71L16 Consolidation File35REFNRReference Numbernvarchar300
28T5A74E18 Consolidation File35REFNRReference Numbernvarchar300
TOPBasic Functions
29EIEIForeign Trade: Export/Import Communication Data9REFNRSales and Distribution Document Numbernvarchar100
30EIKPForeign Trade: Export/Import Header Data67REFNRSales and Distribution Document Numbernvarchar100
TOPBelgium
31PA0504Pensioner's Advantage B25REFNRReference numbernvarchar200
32PA0735HR Master Record: Infotype 0735 (Dimona B)46REFNRDimona Declaration Numbernvarchar200
33T5BDI0HR-BE: Dimona Central Table3REFNRDimona Declaration Numbernvarchar200
34T5BX2Assign Description text to BELCOTAX form, BOW (Obsolete)9REFNRFiche Codenvarchar30
TOPBenefits
35PA0211HR Master Record: Infotype 0211 (COBRA Beneficiaries)37REFNRCOBRA reference number of COBRA-insured personnvarchar30
TOPCanada
36T5KYSNo longer used6REFNRSequential numbernvarchar40
TOPCATT Computer Aided Test Tool
37CATFCATT: Subsequent Data in Test Procedure7REFNRCATT - Referred test casenvarchar300
38CATLCATT: Log Process Data6REFNRCATT - Referred test casenvarchar300
39CATMCATT: Log for model and function data9REFNRCATT - Referred test casenvarchar300
40CATOCATT - Static TCD data from CATF log8REFNRCATT - Referred test casenvarchar300
41CATPCATT - Parameters and variants3REFNRCATT - Referred test casenvarchar300
TOPContract Accounts Receivable and Payable
42DFKKESRPOR Payment Supplement3REFNRPOR Reference Keynvarchar240
43DFKKREP06Tax Report Data (Invoicing Time or Triggered)33REFNRNumber of Contract Accts Rec. & Payable Doc.nvarchar120
44DFKKREP06_STax Report Data - Shadow Table for Posting Date33REFNRNumber of Contract Accts Rec. & Payable Doc.nvarchar120
45DFKKREP07Tax Report Data (Clearing Time)38REFNRNumber of Contract Accts Rec. & Payable Doc.nvarchar120
46DFKKREV06Report for Tax on Sales/Purchases (bill. time or triggered)29REFNRNumber of Contract Accts Rec. & Payable Doc.nvarchar120
47DFKKREV07Report on Tax on Sales/Purchases (clearing time)35REFNRNumber of Contract Accts Rec. & Payable Doc.nvarchar120
TOPCross-Application Components
48AAUUFKOrder master data5REFNRReference order numbernvarchar120
TOPFinancial Accounting
49FBICRC001AICRC: Open Items GL Accounts: Documents37REFNRReference Numbernvarchar300
50FBICRC002AICRC: GL Accounts: Documents37REFNRReference Numbernvarchar300
51FBICRC003AICRC: Open Items Customers/Vendors: Documents38REFNRReference Numbernvarchar300
52ICRCAICRC: Items to be Reconciled24REFNRICRC: Reference Number for Related Invoice Itemsnvarchar270
53ICRCUICRC: Potentially Differing Document Groups24REFNRICRC: Reference Number for Related Invoice Itemsnvarchar270
54ICRCZICRC: Reconciled, Completed Items24REFNRICRC: Reference Number for Related Invoice Itemsnvarchar270
TOPIntercompany Data Exchange
55EMRDETAILIDE: detailed information on MR results (ISU_USAGE_DATA)2REFNRReference numbernvarchar300
56EREFDISSUPReference Between Supplier and Distributor Documents7REFNRNumber of a billing documentnvarchar120
TOPItaly
57PA0407HR master record, infotype 0407 (Abs.addit.inf.)30REFNRReference numbernvarchar80
TOPJoint Venture und Production Sharing Accounting
58T8JEVJoint venture event table10REFNRCharacter Field of Length 12nvarchar120
59T8PSA_EVENTPSA Event table10REFNRCharacter Field of Length 12nvarchar120
TOPMaster Data
60SAFKRun Schedule Master Data4REFNRReference ordernvarchar120
TOPNetherlands
61T5N1CHealth Insurance Companies (NL)5REFNRReference Numbernvarchar100
TOPNew Zealand
62PT2001HR Time Record: Infotype 2001 (Absences)56REFNRReference numbernvarchar80
TOPOverhead Cost Orders
63AUFKOrder master data5REFNRReference order numbernvarchar120
TOPPatient Management
64NKSPIS-H: Insurance verification/certificate - item data34REFNRIS-H: Reference field of an IV item (external reference)nvarchar200
65NLEIIS-H: Services Performed47REFNR_nvarchar100
TOPPayroll
66T7PL11Configuration of data sources for ZUS reporting2REFNRReference number of data source for ZUS reportingnvarchar30
67T7RO558_ABTransfer absences (supplement to T558D)9REFNRReference numbernvarchar80
TOPPension Administration
68PA0845HR Master Record Infotype 0845 (Work Relationships)30REFNRReference Number for Uniqueness from Infotype 0845nvarchar20
TOPPeriodical Sales and Distribution
69JKAKPRAd Pre-Print Order: Header Data20REFNRIS-M: Reference number for ad pre-print ordernvarchar200
TOPPersonnel Administration
70T7PL05Configuration table for GUS forms3REFNRReference number of data source for GUS reportingnvarchar40
71T7PL0TTexts for T7PL053REFNRReference number of data source for GUS reportingnvarchar40
72T7PL1TTexts for T7PL052REFNRReference number of data source for GUS reportingnvarchar40
73T7PLC0Identyfikatory skladników dla formularza PIT-8C3REFNRNumer referencyjny-PIT 8Cnvarchar20
74T7PLC1Opisy skladników dla formularza PIT-8C2REFNRNumer referencyjny-PIT 8Cnvarchar20
TOPPersonnel Time Management
75PA2001HR Time Record: Infotype 2001 (Absences)56REFNRReference numbernvarchar80
TOPPOS Interface
76WPLSTPOS interface: processing log18REFNRExternal reference no. (GR/I slip)nvarchar150
TOPReal Estate Management
77VIMI04Old. replaced in 3.0 with VIMIMV92REFNRReference number for collateral securitiesnvarchar300
78VIMI32Other collateral11REFNRReference number for collateral securitiesnvarchar300
79VIMIMVLease-Out72REFNRReference number for collateral securitiesnvarchar300
TOPSAP Healthcare - Industry-Specific Components for Hospitals
80NWCH80IS-H CH: ELACH Datenempfang; Ablage Nachrichten feldweise13REFNRIS-H CH: N.fattura/richiesta gar.rimb.spese (rifer.a orig.)nvarchar350
81NWCH94Fees: Further Breakdown4REFNRNumber for Assignment of Further Breakdownnvarchar100
TOPSimulation
82VSAUFK_CNVersion: Order master data6REFNRReference order numbernvarchar120
TOPTools
83PA0579HR Master Record Infotype 0579 (Ext. Wage Components)25REFNRReference Numbernvarchar400
TOPTransaction Manager
84REFCCReferences between CO object numbers, currency differences3REFNRNetting numbernvarchar100
85REFHReferences between CO object numbers, header table3REFNRReference number (unit no.)nvarchar100
86REFONReferences between object numbers (CO object no.)3REFNRReference number (unit no.)nvarchar100
87THMHRT_HRHedge Relationship38REFNRReference number (unit no.)nvarchar100
TOPValue Adjustment
88/IBS/TRB_KTORBD Account. Master Data11REFNRRBD: Reference Number Source Systemnvarchar1000
TOPWarehouse Management
89LEINStorage unit header records20REFNRGroupnvarchar100
90LTAKWM transfer order header11REFNRGroupnvarchar100
91T311Definition of WM Groups3REFNRGroupnvarchar100
92T311ACross-Reference WM Group for Documents3REFNRGroupnvarchar100
93T311LDefinition of Run Within a WM Group3REFNRGroupnvarchar100
TOPWarranty Claim Processing
94PNWTYVWarranty Claim Version (PVS Node)11REFNRReference Numbernvarchar350
95PVWTYWarranty Claim Item (PPE Variant)14REFNRReference Numbernvarchar350