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

87 columns | Print definition?ERP 6.0  | PEINH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/SMR1Inventory value in "hard" currency14PEINHPrice Unitdecimal50
2/BIC/B0000187000PSA for 2LIS_02_ITM T90CLNT090 Purch. Data (Item)55PEINHdecimal50
3/BIC/B0000189000PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line44PEINHdecimal50
4BSEGAccounting Document Segment182PEINHPrice Unitdecimal50
5BSSEGAccounting Document Segment171PEINHPrice Unitdecimal50
6FUDT_VDOCBSEGVerification Document Item with Additional Info171PEINHPrice Unitdecimal50
7FUDT_VDOCBSEGEVVerification Document Item in the Entry View171PEINHPrice Unitdecimal50
8FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)171PEINHPrice Unitdecimal50
9GLPOS_C_CTFI Document: Entry View185PEINHPrice Unitdecimal50
10GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items185PEINHPrice Unitdecimal50
11GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items185PEINHPrice Unitdecimal50
12GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items185PEINHPrice Unitdecimal50
13GLPOS_N_CTNew General Ledger: Line Item with Currency Type188PEINHPrice Unitdecimal50
14GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type188PEINHPrice Unitdecimal50
TOPActual CostingMaterial Ledger
15CKMLCRMaterial Ledger: Period Totals Records Values7PEINHPrice unitdecimal50
16CKMLPRMaterial Ledger: Prices4PEINHPrice Unitdecimal50
17CKMLPR_EBPrices for Ending Inventory/Balance Sheet Valuation14PEINHPrice Unitdecimal50
18CKMVFM_OUTOutput for the Value_Flow_Monitor, see SAP Note 91298436PEINHPrice unitdecimal50
19MLCRMaterial Ledger Document: Currencies and Values13PEINHPrice unitdecimal50
TOPAgency Business Global Trade
20WBRPAgency business: Item12PEINHPrice Unit of Vendor Billing Document Itemdecimal50
21WLFD_IVRITMAgency Bus.: DB table for Invoice Request Item7PEINHPrice Unit of Vendor Billing Document Itemdecimal50
TOPBalance Sheet Valuation Procedures
22MYMFTFIFO Results Table11PEINHPrice Unitdecimal50
23MYMLLIFO Material Layer (Annual)10PEINHPrice Unitdecimal50
24MYMLMLIFO Material Layer (Monthly)11PEINHPrice Unitdecimal50
25TPOOLMaster Record, LIFO Pools5PEINHPrice Unitdecimal50
TOPBasic Functions
26T604_PREF_PARAMPreference: Preference determination parameters16PEINHPrice Unitdecimal50
TOPBatches
27WBEWActive Ingredient Valuation11PEINHPrice Unitdecimal50
TOPBills of Material
28STPOBOM item49PEINHPrice Unitdecimal50
TOPCross-Application Components
29PLLPOTask list - operation/activity103PEINHPrice Unitdecimal50
TOPDates
30PRTEScheduling Data for Project Item15PEINHUnit for duration of basic WBS element datesnvarchar30
TOPDefense Forces and Public Security
31/ISDFPS/ZEBANCopy of EBAN34PEINHPrice Unitdecimal50
TOPEmpties Management When Extension EA-CP Is Active
32/BEV1/NEINVITMEmpties Quantities and Values from Invoice Receipt18PEINHPrice Unitdecimal50
TOPExternal Services
33ESLLLines of Service Package21PEINHPrice Unitdecimal50
TOPFinancial Accounting
34VBSEGSDocument Segment for Document Parking - G/L Account Database88PEINHPrice Unitdecimal50
TOPFunctions for U.S. Federal Government
35FMFG_VEKPOJFMIP: Pending PO Line Item Changes Table8PEINHPrice Unitdecimal50
TOPFunds Management
36KBLPDocument Item: Manual Document Entry17PEINHPrice Unitdecimal50
TOPFunds Management-Specific Postings
37FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years87PEINHPrice Unitdecimal50
38PSOSEGSRecurring Request Document Segment, G/L Accounts86PEINHPrice Unitdecimal50
TOPIndustry Solution Catch Weight Management
39/FMP/D_MP_HISTMaterial Price History11PEINHPrice Unitdecimal50
40/FMP/D_MP_PRICMaterial Prices10PEINHPrice Unitdecimal50
TOPInformation System
41MCKALKVVersions: Cost Itemization20PEINHPrice Unitdecimal50
42MCKALKWVersions: Cost Itemization18PEINHPrice Unitdecimal50
TOPInventory Management
43MWZDM07M1ZDM07M138PEINHPrice Unitdecimal50
44RESBReservation/dependent requirements105PEINHPrice Unitdecimal50
45SLGHElements of Stock Population15PEINHPrice Unitdecimal50
TOPInvoice Verification
46RBMADocument Item: Incoming Invoice for Material14PEINHPrice Unitdecimal50
TOPLocalization
47J_1BNFEPARKLINNota fiscal electronica: Invoice create failed23PEINHPrice Unitdecimal50
TOPMaintenance History
48HIMAPM order history - materials23PEINHPrice Unitdecimal50
49HIVGPM order history - operations39PEINHPrice Unitdecimal50
TOPMaster Data Distribution
50/ISDFPS/TL1Task List - Operation/Activity103PEINHPrice Unitdecimal50
TOPMaterial Master
51EBEWSales Order Stock Valuation13PEINHPrice Unitdecimal50
52EBEWHValuation of Sales Order Stock: History15PEINHPrice Unitdecimal50
53MBEWMaterial Valuation11PEINHPrice Unitdecimal50
54MBEWHMaterial Valuation: History12PEINHPrice Unitdecimal50
55MBEW_TMPFile for Incorrect Data in Direct Input14PEINHPrice Unitdecimal50
56MVEWMaterial Valuation11PEINHPrice Unitdecimal50
57MVEWHMaterial Valuation: History12PEINHPrice Unitdecimal50
58OBEWValuated Stock with Subcontractor12PEINHPrice Unitdecimal50
59OBEWHValuated Stock with Subcontractor: History14PEINHPrice Unitdecimal50
60QBEWProject Stock Valuation12PEINHPrice Unitdecimal50
61QBEWHValuation of Project Stock: History14PEINHPrice Unitdecimal50
TOPMaterials Management
62/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions39PEINHPrice Unitdecimal50
63/SAPNEA/ROWAChargeable component consumptions36PEINHPrice Unitdecimal50
64ROWAIndex table : Chargeable component consumptions36PEINHPrice Unitdecimal50
TOPMedia Product
65TJP_VAL_DATAValuation Template for Unit Costs Transfer8PEINHPrice Unitdecimal50
TOPOverhead Cost Controlling
66TKAR1CO Resource Prices Valid for the Controlling Area9PEINHPrice Unitdecimal50
67TKAR2CO Resource Prices Per Cost Center10PEINHPrice Unitdecimal50
TOPPerishables Procurement
68FIP_D_ORDER_LINEOrder lines for FIP20PEINHPrice Unitdecimal50
TOPProduct Cost Planning
69CKISItems Unit Costing/Itemization Product Costing30PEINHPrice Unit of Prices in Controlling Area Currencydecimal50
70CKTC_CBEWCosting Master Data - Attributes10PEINHPrice Unitdecimal50
71TJP_ECP_KPIECP: Pricing Key Definition5PEINHPrice Unitdecimal50
TOPProduction Orders
72AFVCOperation within an order56PEINHPrice Unitdecimal50
TOPPurchasing
73EBANPurchase Requisition34PEINHPrice Unitdecimal50
74EINEPurchasing Info Record: Purchasing Organization Data36PEINHPrice Unitdecimal50
75EIPAOrder Price History: Info Record10PEINHPrice Unitdecimal50
76EKPOPurchasing Document Item26PEINHPrice Unitdecimal50
77MEREQXPurchase Requisition Change Parameter34PEINHUpdated information in related user data fieldnvarchar10
78WDFR1Requirements Planning for Perishables18PEINHPrice Unitdecimal50
79WDFR_POSPerishables Planninng Item47PEINHPrice Unitdecimal50
80WRF_POHF_POLOrder list24PEINHPrice Unitdecimal50
TOPRemaining Beverage - Obsolete Objects
81/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1173PEINHPrice Unitdecimal50
TOPRouting
82PLPOTask list - operation/activity103PEINHPrice Unitdecimal50
TOPSelf-Service Procurement
83/SRMERP/D_SC_ITMShopping Cart Item13PEINHPrice Unitdecimal50
TOPSimulation
84VSAFVC_CNVersion: Operation in order57PEINHPrice Unitdecimal50
85VSEBAN_CNVersion: Purchase requisition35PEINHPrice Unitdecimal50
86VSPRTE_CNVersion: Scheduling data for project item16PEINHUnit for duration of basic WBS element datesnvarchar30
87VSRESB_CNVersion: Reservation/Dependent requirements106PEINHPrice Unitdecimal50