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

24 columns | Print definition?ERP 6.0  | IBLNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMERP/STG_PM001Data staging - Equipment complex table108IBLNRPhysical Inventory Documentnvarchar100
2/SMERP/STG_PM003Data staging - Equipment List Set - Hdr - complex tab108IBLNRPhysical Inventory Documentnvarchar100
3CNVTDMS_05_IKPFFill Header Physical Inventory Document3IBLNRBELNR for CNVTDMS_05_*nvarchar100
4CNV_20000_IKPFBackup copy of IKPF (header for phys. inventory document)2IBLNRPhysical inventory documentnvarchar100
5TXSTAMM Inventory Mngmt: Work Table for Phys. Inv. Doc. Archiving1IBLNRPhysical Inventory Documentnvarchar100
TOPActual CostingMaterial Ledger
6CKMLDUVDistribution of Usage Diff.(Status for each ISEG entry)2IBLNRPhysical Inventory Documentnvarchar100
7CKMLDUVCOUsage Differences for Each Account Assignment Object2IBLNRPhysical Inventory Documentnvarchar100
TOPContract Accounts Receivable and Payable
8EKLPCIHistory of Charges for Installment Plan Items (LPC in USA)4IBLNRNumber of Contract Accts Rec. & Payable Doc.nvarchar120
TOPDistribution of Usage Variances
9CKMLDUVNDistribution of Usage Diff.(Status for each ISEG entry)2IBLNRPhysical Inventory Documentnvarchar100
10CKMLDUVNCOUsage Differences for Each Account Assignment Object2IBLNRPhysical Inventory Documentnvarchar100
TOPEquipment
11EQUZEquipment time segment39IBLNRPhysical Inventory Documentnvarchar100
12IEQT_WL_ITEMSInterim Statuses - Items57IBLNRPhysical Inventory Documentnvarchar100
13IEQT_WL_ITM_BACInterim Statuses - Items (Backup)58IBLNRPhysical Inventory Documentnvarchar100
TOPHydrocarbon Product Management
14ISEGO1Appendix for Physical Inventory Conversion Parameters2IBLNRPhysical Inventory Documentnvarchar100
15ISEGO2Appendix for Physical Inventory Additional Quantities2IBLNRPhysical Inventory Documentnvarchar100
TOPIndustry Solution Catch Weight Management
16/CWM/QM_COUNTCount Data Table for Insp. Lot-Related Phys. Inv. in CWM2IBLNRPhysical Inventory Documentnvarchar100
TOPInterface to Terminal Automation System
17OIK02BIS-OIL/TAS: Status of processed functions - messages27IBLNRPhysical Inventory Documentnvarchar100
TOPInventory Management
18IKPFHeader: Physical Inventory Document2IBLNRPhysical Inventory Documentnvarchar100
19ISEGPhysical Inventory Document Items2IBLNRPhysical Inventory Documentnvarchar100
20T159ITest Data for Batch Input in Inventory Management (Phys.Inv)11IBLNRPhysical Inventory Documentnvarchar100
TOPInvoicing
21EKLPCINVHistory of Charges for Installment Plan Items (LPC in USA)4IBLNRNumber of Contract Accts Rec. & Payable Doc.nvarchar120
TOPLocalization
22J_3R_INVDIFFOffsetting inventory differences of goods2IBLNRPhysical Inventory Documentnvarchar100
TOPSAP Retail Store
23WSTI_PDC_EVENTRetail Store Physical Inventory: PDC Transactions6IBLNRPhysical Inventory Documentnvarchar100
TOPSerial Numbers
24SER07Document Header for Serial Numbers in Physical Inventory3IBLNRPhysical Inventory Documentnvarchar100