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

16 columns | Print definition?ERP 6.0  | KOKEY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAustria
1PA0131HR Master Record: Infotype 0131 (Garnishment/Cession A)46KOKEYCorrespondence keynvarchar80
TOPGermany
2PA0111HR Master Record: Infotype 0111 (Garnishment/Cession - D)53KOKEYCorrespondence keynvarchar80
TOPPayroll General Parts
3PA0611HR Master Record: Infotype 061144KOKEYLawyer's Keynvarchar80
TOPPublic Sector
4T5D5GSupplementary Pension Public Sector: Combination Table2KOKEYCombination Keynvarchar20
5T5D5ZSupplementary Pension Public Sector: SPI Data6KOKEYCombination Keynvarchar20
TOPRecycling Administration Core Functions
6J_7LC191REA Data Filters: Splitting for Sales Transactions14KOKEYCondition Type Assignment Keynvarchar60
7J_7LC192REA Data Filters: Splitting for Purchasing Transactions12KOKEYCondition Type Assignment Keynvarchar60
8J_7LC21REA Special Condition Types9KOKEYCondition Type Assignment Keynvarchar60
9J_7LC37REA Condition type assignment: Versions4KOKEYCondition Type Assignment Keynvarchar60
10J_7LC38REA Condition type assignment: Items4KOKEYCondition Type Assignment Keynvarchar60
11J_7LM05REA Article Master: Recycling Partner Assignment12KOKEYCondition Type Assignment Keynvarchar60
12J_7LM10REA Article Master: Filters for Regional Processing17KOKEYCondition Type Assignment Keynvarchar60
13J_7LP01REA Price List: Versions10KOKEYCondition Type Assignment Keynvarchar60
14J_7LV03REA Packaging Master Data: Recycling Partner Assignment11KOKEYCondition Type Assignment Keynvarchar60
15J_7LV1PREA Document: Item Data43KOKEYCondition Type Assignment Keynvarchar60
TOPTravel Expenses
16PTRV_DOC_ITTransfer Travel -> FI/CO: Lines of TRV interm. document29KOKEYAccount Assignment Allocationnvarchar20