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

47 columns | Print definition?ERP 6.0  | BDATJ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMS_05_CKMLHCollect Table for Material Ledger4BDATJFiscal Yearnvarchar40
2MLAUFHHistory table for summarized MLAUF data12BDATJPosting Date YYYYnvarchar40
3RSDHA_009BFiscal year variant periods3BDATJPosting Date YYYYnvarchar40
4T009BFiscal year variant periods3BDATJPosting Date YYYYnvarchar40
5T009CPeriod names5BDATJPosting Date YYYYnvarchar40
TOPActual CostingMaterial Ledger
6CKMI1Index for Accounting Documents for Material3BDATJPosting Date YYYYnvarchar40
7CKML1Material Ledger Period Totals Records (Release 3.xx)4BDATJPosting Date YYYYnvarchar40
8CKMLCRMaterial Ledger: Period Totals Records Values3BDATJPosting Date YYYYnvarchar40
9CKMLCRWIPMaterial Ledger: WIP Period Records (Values)3BDATJPosting Date YYYYnvarchar40
10CKMLKEKOMaterial Ledger: Cost Component Split (Header)3BDATJPosting Date YYYYnvarchar40
11CKMLKEPHMaterial Ledger: Cost Component Split (Elements)3BDATJPosting Date YYYYnvarchar40
12CKMLKEVMaterial Ledger: Cost Component Split (Control Record)3BDATJPosting Date YYYYnvarchar40
13CKMLLACRML Activity Type: Period Record/Currency Record3BDATJPosting Date YYYYnvarchar40
14CKMLLACRWIPML Activity Types: Period/ Currency Records WIP (Values)3BDATJPosting Date YYYYnvarchar40
15CKMLLAPPML Activity Types: Period Records3BDATJPosting Date YYYYnvarchar40
16CKMLLAPPWIPMl Activity Types: Period Records WIP (Quantities)3BDATJPosting Date YYYYnvarchar40
17CKMLMYMPPeriodic Receipt Values for Consumption Sequence Procedure3BDATJPosting Date YYYYnvarchar40
18CKMLOMaterial Ledger: Organizational Jobs3BDATJPosting Date YYYYnvarchar40
19CKMLPPMaterial Ledger Period Totals Records Quantity3BDATJPosting Date YYYYnvarchar40
20CKMLPPWIPMaterial-Ledger: Period Records WIP (Quantities)3BDATJPosting Date YYYYnvarchar40
21CKMLPRKEKOMaterial Ledger: Cost Component Split (Header) for Prices3BDATJPosting Date YYYYnvarchar40
22CKMLPRKEPHMaterial Ledger: Cost Component Split (Elements) for Prices3BDATJPosting Date YYYYnvarchar40
23CKMLPR_EBPrices for Ending Inventory/Balance Sheet Valuation3BDATJPosting Date YYYYnvarchar40
24CKMVFM_EXTRACTTransaction CKMVFM, Extracts, see SAP Note 9129848BDATJPosting Date YYYYnvarchar40
25CKMVFM_OUTOutput for the Value_Flow_Monitor, see SAP Note 9129848BDATJPosting Date YYYYnvarchar40
26FCML_CCS_REPHDB Reporting Structure for ML4BDATJPosting Date YYYYnvarchar40
27FCML_REPML Reporting Structure4BDATJPosting Date YYYYnvarchar40
28MLARC_IDXIndex for ML Document2BDATJPosting Date YYYYnvarchar40
29MLAUFMaterial Ledger Item Table for Order History11BDATJPosting Date YYYYnvarchar40
30MLBEMaterial Ledger FS Item Table for GR/IR relevant transaction13BDATJPosting Date YYYYnvarchar40
31MLBEHMaterial Ledger FS Item Table for GR/IR relevant transaction13BDATJPosting Date YYYYnvarchar40
32MLCDMaterial Ledger: Summarization Record (from Documents)3BDATJPosting Date YYYYnvarchar40
33MLCRMaterial Ledger Document: Currencies and Values5BDATJPosting Date YYYYnvarchar40
34MLCRFMaterial Ledger Document: Field Groups (Currencies)5BDATJPosting Date YYYYnvarchar40
35MLCRPMaterial Ledger Document: Price Changes (Currencies, Prices)5BDATJPosting Date YYYYnvarchar40
36MLKEPHML Document: Cost Component Split (Elements) for Values5BDATJPosting Date YYYYnvarchar40
37MLPPMaterial Ledger Document: Posting Periods and Quantities5BDATJPosting Date YYYYnvarchar40
38MLPPFMaterial Ledger Document: Field Groups (Posting Periods)5BDATJPosting Date YYYYnvarchar40
39MLPRKEKOML Document: Cost Component Split (Header)for Prices5BDATJPosting Date YYYYnvarchar40
40MLPRKEPHML Document: Cost Component Split (Components)for Prices5BDATJPosting Date YYYYnvarchar40
TOPBasic Functions
41T090ZPeriod control for transactions4BDATJPosting Date YYYYnvarchar40
TOPData Transfer
42T51A1HR: Final Date for HR Postings (Accruals)3BDATJFiscal Yearnvarchar40
TOPLocalization
43J_1AINFINVInflation: Invoices for Replacement Value Determination3BDATJPosting Date YYYYnvarchar40
44J_1ISERUTZTracking accounting docs already utilized for service tax9BDATJPosting Date YYYYnvarchar40
TOPProduct Cost Planning
45FVMKMarking File for Release of Std Cost Est in Company Code3BDATJPosting Date YYYYnvarchar40
46KEKOProduct Costing - Header Data65BDATJPosting Date YYYYnvarchar40
TOPRegulatory reporting for insurance companies
47ISSR_T009BISSR: Mustertabelle Perioden SR-Geschäftsjahresvariante3BDATJBuchungsdatum JJJJnvarchar40