SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8BSEG345Accounting Document Segment
9AUDLORIPR7KPro: Logical Information Object Attribute Values
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

TableColumnsDescription
1OINV386A/R Invoice
2OITM299Items
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OPOR386Purchase Order
9JDT1124Journal Entry - Rows
10OACT114G/L Accounts

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OPCH268A/P Invoice
6OIVL77Whse Journal
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

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