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

55 columns | Print definition?ERP 6.0  | KZBWS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ZEIM_AFPOOrder item81KZBWSValuation of Special Stocknvarchar10
2ZEIM_LIPSSD document: Delivery: Item data192KZBWSValuation of Special Stocknvarchar10
3ZEIM_VBAPSales Document: Item Data195KZBWSValuation of Special Stocknvarchar10
TOPAccounting Interface
4GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)200KZBWSValuation of Special Stocknvarchar10
5GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)200KZBWSValuation of Special Stocknvarchar10
TOPActual CostingMaterial Ledger
6CKMI1Index for Accounting Documents for Material21KZBWSValuation of Special Stocknvarchar10
7CKMLHDMaterial Ledger: Header Record11KZBWSValuation of Special Stocknvarchar10
8CKMLHD_AGGRMaterial Ledger: Header Record11KZBWSValuation of Special Stocknvarchar10
9CKMLMV013Assignment table: Process for production order12KZBWSValuation of Special Stocknvarchar10
10MLITMaterial Ledger Document: Items36KZBWSValuation of Special Stocknvarchar10
TOPAlternative Valuation Run
11CKMLAVRDOCITLines for Cumulation Posting Document18KZBWSValuation of Special Stocknvarchar10
TOPBasic Functions
12VBBESales Requirements: Individual Records39KZBWSValuation of Special Stocknvarchar10
TOPCross-Application Components
13VVBAPSales Document: Item Data195KZBWSValuation of Special Stocknvarchar10
TOPDefense Forces and Public Security
14/ISDFPS/ZEBANCopy of EBAN98KZBWSValuation of Special Stocknvarchar10
TOPDemand Management
15PBIDPlanned independent requirements index: MRP area35KZBWSValuation of Special Stocknvarchar10
16PBIMIndependent Requirements for Material33KZBWSValuation of Special Stocknvarchar10
17T459KControl table for customer requirements31KZBWSValuation of Special Stocknvarchar10
TOPFinancial Accounting
18ACCTITCompressed Data from FI/CO Document73KZBWSValuation of Special Stocknvarchar10
TOPInventory Management
19MSEGDocument Segment: Material164KZBWSValuation of Special Stocknvarchar10
20MWXMSEGZMSEG: Interface for Posting of Value164KZBWSValuation of Special Stocknvarchar10
21MWZMSEGZMSEG:Interface for Posting of Value164KZBWSValuation of Special Stocknvarchar10
22RESBReservation/dependent requirements169KZBWSValuation of Special Stocknvarchar10
TOPInvoice Verification
23RBDRSEGBatch IV: Invoice Document Items110KZBWSValuation of Special Stocknvarchar10
TOPMaster Data
24MDSMSimulative dependent requirements103KZBWSValuation of Special Stocknvarchar10
25PLAFPlanned Order103KZBWSValuation of Special Stocknvarchar10
TOPMaterial Master
26MSSATotal Customer Orders on Hand14KZBWSValuation of Special Stocknvarchar10
27MSSQProject Stock Total13KZBWSValuation of Special Stocknvarchar10
TOPMaterials Management
28/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions103KZBWSValuation of Special Stocknvarchar10
TOPOperative Structures
29PROJProject definition61KZBWSValuation of Special Stocknvarchar10
30PRPSWBS (Work Breakdown Structure) Element Master Data80KZBWSValuation of Special Stocknvarchar10
31TCJ41Default Values for Work Breakdown Structure77KZBWSValuation of Special Stocknvarchar10
TOPProduct Cost by Period
32KOSA_BALTProcurement Alternative for Prod Cost Coll. in Make-to-Order6KZBWSValuation of Special Stocknvarchar10
TOPProduction Backflush
33PPC_COMATMaximum Bill of Material of Backflushed Materials (for CO)7KZBWSValuation of Special Stocknvarchar10
34PPC_HEADDocument PP Backflush - Header12KZBWSValuation of Special Stocknvarchar10
35PPC_MATSuper BOM for Backflushed Materials9KZBWSValuation of Special Stocknvarchar10
36PPC_STEP2Goods Movements Table for New PPCGO Logic (2 Steps)18KZBWSValuation of Special Stocknvarchar10
TOPProduction Orders
37AFPOOrder item81KZBWSValuation of Special Stocknvarchar10
TOPPurchasing
38EBANPurchase Requisition98KZBWSValuation of Special Stocknvarchar10
39EKPOPurchasing Document Item178KZBWSValuation of Special Stocknvarchar10
40MEREQXPurchase Requisition Change Parameter98KZBWSUpdated information in related user data fieldnvarchar10
TOPRemaining Beverage - Obsolete Objects
41/BEV1/RBVBAPSales Document: Item Data195KZBWSValuation of Special Stocknvarchar10
TOPRepetitive Manufacturing
42COMPMOVEGoods Movement of Components221KZBWSValuation of Special Stocknvarchar10
TOPSales
43VBAPSales Document: Item Data195KZBWSValuation of Special Stocknvarchar10
TOPSelf-Service Procurement
44/SRMERP/D_SC_ITMShopping Cart Item43KZBWSValuation of Special Stocknvarchar10
TOPShipping
45LIPSSD document: Delivery: Item data192KZBWSValuation of Special Stocknvarchar10
TOPSimulation
46VSAFPO_CNVersion: Order items in PP orders82KZBWSValuation of Special Stocknvarchar10
47VSEBAN_CNVersion: Purchase requisition99KZBWSValuation of Special Stocknvarchar10
48VSPLAF_CNVersion: Planned order104KZBWSValuation of Special Stocknvarchar10
49VSPROJ_CNVersion: Project definition62KZBWSValuation of Special Stocknvarchar10
50VSPRPS_CNVersion: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data81KZBWSValuation of Special Stocknvarchar10
51VSRESB_CNVersion: Reservation/Dependent requirements170KZBWSValuation of Special Stocknvarchar10
52VSVBAP_CNVersion: Sales document: Item data196KZBWSValuation of Special Stocknvarchar10
TOPSpare Part Sharing and Stock Providede by Customer
53MCSSTotal Customer Stock13KZBWSValuation of Special Stocknvarchar10
TOPTemplates
54PROJSStandard project definition61KZBWSValuation of Special Stocknvarchar10
55PRPSSStandard WBS Element (WBS element) - Master Data80KZBWSValuation of Special Stocknvarchar10