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
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FCO_DOC_HEAD61Failure Cost Document Header
8/OPT/Z1344Reporting table: Text table for exception definitions
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

162 columns | Print definition?ERP 6.0  | MBLNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GBTINT/EVHUSGBT: Handling Units related to MDoc / WM TO4MBLNRNumber of Material Documentnvarchar100
2ARBERP_D_RCTTRIGTrigger Table: Send Receipt Request cXML Messages5MBLNRNumber of Material Documentnvarchar100
3ARBERP_D_SO_RCPTReceipt Request Message Payload ID For Outbound Messages2MBLNRNumber of Material Documentnvarchar100
4CMM_MTM_POMtM per Purchase Order8MBLNRNumber of Material Documentnvarchar100
5CNVTDMS_05_MDOCFill Header for Material Documents (IS-OIL)3MBLNRMBLNR for TDMSnvarchar100
6CNV_20551_MBLNRMaterial documents selected for deletion3MBLNRNumber of material documentnvarchar100
7FIEUD_GOODS_HSAFT:XML:Goods Movement Header3MBLNRNumber of Material Documentnvarchar100
8FIEUD_GOODS_ISAFT-XML:Goods Movement Line Items3MBLNRNumber of Material Documentnvarchar100
9FIEUD_SBINV_ISAFT: Self Billing Invoices ( Line Items)39MBLNRNumber of Material Documentnvarchar100
10J_3RF_RGTORG_INIncoming Journal of Acceptance Documents8MBLNRNumber of Material Documentnvarchar100
11MWOFF_CL2MBLNRnvarchar100
12WB2B_CMM_MTM_TCMtM per Trading Contract8MBLNRNumber of Material Documentnvarchar100
13WSPT_LIKPDocuments For Portugal Webservice6MBLNRNumber of Material Documentnvarchar100
14ZCMM_MTM_01MtM Persistency per Transaction10MBLNRDocument Number of an Invoice Documentnvarchar100
15ZCMM_MTM_TCMtM per TC9MBLNRDocument Number of an Invoice Documentnvarchar100
TOPActual CostingMaterial Ledger
16CKMLDUVCOUsage Differences for Each Account Assignment Object10MBLNRNumber of a material/FI documentnvarchar100
17MLITMBMaterial valuation document row information5MBLNRNumber of Material Documentnvarchar100
TOPAllocation
18AULWDelivery Phases14MBLNRNumber of Material Documentnvarchar100
19AUVWDelivery Phase for Distribution Center13MBLNRNumber of Material Documentnvarchar100
TOPBalance Sheet Valuation Procedures
20MYML1LIFO: Transaction-Related Material Layer5MBLNRNumber of Material Documentnvarchar100
21MYML1QLIFO: Transaction-Related Material Layer (Quantity)5MBLNRNumber of Material Documentnvarchar100
22MYML1VLIFO: Transaction-Related Material Layer (Values)5MBLNRNumber of Material Documentnvarchar100
23MYMP1Receipt Data LFIO/FIFO Valuation6MBLNRNumber of Material Documentnvarchar100
24MYSEG_EXTRACTDocument Segment: Material5MBLNRNumber of Material Documentnvarchar100
TOPBasic functions
25HUINV_ITEMHandling Unit: Physical Inventory Document Item29MBLNRNumber of Material Documentnvarchar100
26HUMSEGReference-HU-Item for Material Doc.Item that was Posted Last5MBLNRNumber of Material Documentnvarchar100
TOPClinical System
27N1BCPMAT_RD_MMServices: Material Integration for Additional Data3MBLNRNumber of Material Documentnvarchar100
28N1DRUGDOCIS-H*MED: Drug Documentation15MBLNRMedication: Number of Material Documentnvarchar100
29N1OLDDOCIS-H*MED: Medication; History for N1DRUGDOC4MBLNRNumber of Material Documentnvarchar100
TOPConfirmations
30AFWISubsequently posted goods movements for confirmations4MBLNRNumber of Material Documentnvarchar100
TOPConstruction Equipment Management
31J_3GBELKDocument File - Header Data149MBLNRNumber of Material Documentnvarchar100
TOPConsumer Products for Food Beverage
32CFB_WEIGH_LISTDatabase of Weigh List2MBLNRNumber of Material Documentnvarchar100
TOPCross-Application Components
33/OPT/S_GR_HDRVSS Staging Table: GR Header2MBLNRNumber of Material Documentnvarchar100
34/OPT/S_GR_LINVSS Stageing Table: GR Line2MBLNRNumber of Material Documentnvarchar100
TOPData Collection
35S033Statistics: Movements for Current Stock (Individual Records)11MBLNRNumber of Material Documentnvarchar100
36S033ES033 - Structural information6MBLNRNumber of Material Documentnvarchar100
TOPData Retention Tool
37TXW_S_MKPFRetrieve MKPF from archive9MBLNRNumber of Material Documentnvarchar100
38TXW_S_MSEGRetrieve MSEG from archive8MBLNRNumber of Material Documentnvarchar100
TOPDistribution of Usage Variances
39CKMLDUVNCOUsage Differences for Each Account Assignment Object10MBLNRNumber of a material/FI documentnvarchar100
40DUVMSEG_EXTRACTduv mseg extract for performance2MBLNRNumber of Material Documentnvarchar100
TOPExchanges
41OIA11Exchange assignment for deliveries15MBLNRNumber of Material Documentnvarchar100
42OIA12Exchange assignment for bulk shipments16MBLNRNumber of Material Documentnvarchar100
43OIA12IMovement Based Netting document item9MBLNRNumber of Material Documentnvarchar100
44OIAQBExchange Movements Index14MBLNRNumber of Material Documentnvarchar100
TOPExcise Duty
45/BEV2/CS_HDEMCS Process: Header Data6MBLNRNumber of Material Documentnvarchar100
46/BEV2/CS_HD_HEMCS Process: Header Data - History7MBLNRNumber of Material Documentnvarchar100
47/BEV2/CS_MEMORYEMCS Process: Table for Shared Buffer6MBLNRNumber of Material Documentnvarchar100
48/BEV2/CS_MSEGARCEMCS Process: ARC in Material Document Items2MBLNRNumber of Material Documentnvarchar100
49/BEV2/CS_MSEGA_HEMCS Process: ARC in Material Document Items - History2MBLNRNumber of Material Documentnvarchar100
50/BEV2/EDMSEExcise Duty Document Table3MBLNRNumber of Material Documentnvarchar100
51/BEV2/EDMSSMaterial Documents Whose Processing Flags Have to Be Reset3MBLNRNumber of Material Documentnvarchar100
52/BEV2/EDMSTDocument Texts for Manual Corrections3MBLNRNumber of Material Documentnvarchar100
TOPFinancial Accounting
53/CCEE/SIFIDDVSpecial Tax Table4MBLNRNumber of Material Documentnvarchar100
54/CCEE/SIFIPE17Temporary import of goods2MBLNRNumber of Material Documentnvarchar100
TOPForeign Trade
55/SAPSLL/BWHSTR3Customs WH-Relevant Data for Two-Step Stock Transfer Process7MBLNRNumber of Material Documentnvarchar100
56/SAPSLL/CUWLAR3Relevant Goods Issues for Transfer to SAP GTS2MBLNRNumber of Material Documentnvarchar100
TOPHydrocarbon Product Management
57MSEGO1Quantity Conversion Parameters for Material Documents2MBLNRNumber of Material Documentnvarchar100
58MSEGO2Material Document Quantities in Additional Units of Measure2MBLNRNumber of Material Documentnvarchar100
59OIB09Log for missing MSEGO1 and MSEGO2 documents2MBLNRNumber of Material Documentnvarchar100
60OIB_MIGO_HQCIStore the QCI-GOITEM for MIGOs hold/restore feature5MBLNRNumber of Material Documentnvarchar100
61OIB_MIGO_HTSTStore the TST-GOITEM for MIGOs hold/restore feature4MBLNRNumber of Material Documentnvarchar100
TOPIndustry Solution Oil
62OI0_PROPT_OBDETOutbound notif pgm run4MBLNRNumber of Material Documentnvarchar100
TOPInspection Lot Completion
63QAMBQM: Link Between Inspection Lot and Material Document5MBLNRNumber of Material Documentnvarchar100
TOPInterface to Terminal Automation System
64OIK02BIS-OIL/TAS: Status of processed functions - messages24MBLNRNumber of Material Documentnvarchar100
TOPInventory Management
65CHVWTable CHVW for Batch Where-Used List12MBLNRNumber of Material Documentnvarchar100
66IMEXTEnhancement Fields for Goods Receipt2MBLNRNumber of Material Documentnvarchar100
67ISEGPhysical Inventory Document Items35MBLNRNumber of Material Documentnvarchar100
68MARIShort document: material movement2MBLNRNumber of Material Documentnvarchar100
69MIGO_BADI_EXAMP2BADI in MIGO: Example Table (Header)2MBLNRNumber of Material Documentnvarchar100
70MIGO_BADI_EXAMPLBADI in MIGO: Example Table2MBLNRNumber of Material Documentnvarchar100
71MKPFHeader: Material Document2MBLNRNumber of Material Documentnvarchar100
72MKPF_ARIDXIndex table for single doc. access to archive MM_MATBEL2MBLNRNumber of Material Documentnvarchar100
73MMINKON_UPCorrections due to Technical Problems with Stock35MBLNRNumber of Material Documentnvarchar100
74MSEGDocument Segment: Material2MBLNRNumber of Material Documentnvarchar100
75MWMKPFHeader Table for the Interface4MBLNRNumber of Material Documentnvarchar100
76MWXMSEGZMSEG: Interface for Posting of Value2MBLNRNumber of Material Documentnvarchar100
77MWXVM07MFields: Update Control of Module Pool SAPMM07M2MBLNRNumber of Material Documentnvarchar100
78MWYMBUZLine Assignment2MBLNRNumber of Material Documentnvarchar100
79MWZDM07M1ZDM07M12MBLNRNumber of Material Documentnvarchar100
80MWZDM07M2ZDM07M22MBLNRNumber of Material Documentnvarchar100
81MWZMBUZZMBUZ2MBLNRNumber of Material Documentnvarchar100
82MWZMSEGZMSEG:Interface for Posting of Value2MBLNRNumber of Material Documentnvarchar100
83MWZVM07MFields: Update Control of Module Pool SAPMM07M2MBLNRNumber of Material Documentnvarchar100
84UKPFRetail Revaluation Document: Revaluation Header11MBLNRNumber of Material Documentnvarchar100
TOPInvoice Verification
85RBDRSEGBatch IV: Invoice Document Items73MBLNRNumber of Material Documentnvarchar100
86RKWAConsignment Withdrawals2MBLNRNumber of Material Documentnvarchar100
TOPJoint Venture und Production Sharing Accounting
87CRP_MIGO_BADI_TBBADI in MIGO: Example Table2MBLNRNumber of Material Documentnvarchar100
TOPJust-In-Time Processing
88JITOGRGoods Receipts for JIT Outbound Calls4MBLNRNumber of Material Documentnvarchar100
TOPKANBAN
89PKPSControl Cycle Item / Kanban22MBLNRNumber of Material Documentnvarchar100
TOPLocalization
90J_1BFIFOINIncoming FIFO relevant Consignment movements (BRAZIL)5MBLNRNumber of Material Documentnvarchar100
91J_1BFIFOOUTOutgoing FIFO relevant Consignment movements (BRAZIL)5MBLNRNumber of Material Documentnvarchar100
92J_1BPOSCOUPONSPOS-Database Coupons (Brazilian)23MBLNRNumber of Material Documentnvarchar100
93J_1ICALOCAllocation of materials to assets5MBLNRNumber of Material Documentnvarchar100
94J_1IGRXREFGoods Receipt to Excise Invoice Coss Reference2MBLNRNumber of Material Documentnvarchar100
95J_1IGRXSUBGR reference to subcontracting challans3MBLNRNumber of Material Documentnvarchar100
96J_1IITMDTLItem Details - for Capital goods and subcontracting4MBLNRNumber of Material Documentnvarchar100
97J_1IPART1Excise part I detials6MBLNRNumber of Material Documentnvarchar100
98J_1IQRDEPQuarterly Returns Depot structure47MBLNRNumber of Material Documentnvarchar100
99J_1IRAINDTLArticle Inward Note Detail27MBLNRNumber of Material Documentnvarchar100
100J_1IRAINHDRArticle Inward Note Header17MBLNRNumber of Material Documentnvarchar100
101J_1IRG1Excise RG1 details6MBLNRNumber of Material Documentnvarchar100
102J_1IRG23DRG23D register for the depot8MBLNRNumber of Material Documentnvarchar100
103J_3RFGTDMATGTD usage in material documents9MBLNRNumber of Material Documentnvarchar100
104J_3RMWOINMaterial issues without invoices.2MBLNRNumber of Material Documentnvarchar100
105J_3RSCCDSUBITMCargo Customs Declaration Subitems13MBLNRNumber of Material Documentnvarchar100
TOPMaintenance Notifications
106QMELQuality Notification74MBLNRNumber of Material Documentnvarchar100
TOPMaintenance Orders
107AUFMGoods movements for order2MBLNRNumber of Material Documentnvarchar100
TOPManufacturer Part Number
108ADPIC_HOLD_MIGOStore BADI goitem for MIGO hold / restore functionality5MBLNRNumber of Material Documentnvarchar100
TOPMaterials Management
109/ISDFPS/CHVW_EExternal Batch Where-Used List12MBLNRNumber of Material Documentnvarchar100
110/SAPNEA/ROWAChargeable component consumptions2MBLNRNumber of Material Documentnvarchar100
111ROWAIndex table : Chargeable component consumptions2MBLNRNumber of Material Documentnvarchar100
112RPOD_IDXGoods Movement Synchronized with a SUS/ICH System2MBLNRNumber of Material Documentnvarchar100
TOPMaterials Management MM enhancements
113/SAPMP/MIGOBPMNGBAdI in MIGO: Cumulated Order Price Quantity2MBLNRNumber of Material Documentnvarchar100
TOPMeasuring Points and Counters
114EAM_IFCUGoods Movement for Technical Object5MBLNRNumber of Material Documentnvarchar100
TOPMedia Product Sales and Distribution
115JKSDUNSOLDGRFLOWIS-M: Goods Receipt Document Flow for Unsold Copies4MBLNRNumber of Material Documentnvarchar100
TOPPatient Accounting
116NMATOIS-H: Material requisition by nurse station4MBLNRNumber of a Material Documentnvarchar100
117NMATPIS-H: Material planned for case7MBLNRNumber of a Material Documentnvarchar100
118NMATVIS-H: Material Entered for Case9MBLNRNumber of a Material Documentnvarchar100
TOPPegging, Grouping, and Distribution
119PEG_CNSMPTN2WBSPegging: Consumption Posting to WBS element details2MBLNRNumber of Material Documentnvarchar100
120PEG_TGTG_EXCA&D GPD: Group to group initial peg8MBLNRNumber of Material Documentnvarchar100
TOPProduct Safety
121CCRCT_PULOEHS: Reference to Confirmed Purchased Quantities3MBLNRNumber of Material Documentnvarchar100
122CCRCT_SOLOEHS: Reference to Confirmed Sold Quantities (CCRCT_SO)3MBLNRNumber of Material Documentnvarchar100
TOPProduction Orders
123COWIPB_CHVWWIP Batches with Where-Used List21MBLNRNumber of Material Documentnvarchar100
TOPProduction Planning and Control PP enhancements
124MILL_PBWUMill: Process Batches with Usage20MBLNRNumber of Material Documentnvarchar100
TOPQuality Certificates
125QCPRQM quality certificates in procurement14MBLNRNumber of Material Documentnvarchar100
TOPQuality Inspection
126QALSInspection lot record118MBLNRNumber of Material Documentnvarchar100
127QAPPInspection point40MBLNRNumber of Material Documentnvarchar100
TOPR2-R3 Link
128LDK01Communication Record 01 Decentralized WMS: GR/GI R/2 -> ERP24MBLNRNumber of Material Documentnvarchar100
129LDK02Communicat.Record 02 Decentralized WMS: Transfer R/2 -> ERP29MBLNRNumber of Material Documentnvarchar100
130LDK06Communic.Record 06 Decentr.WMS (R/2-ERP):Batch Status Change14MBLNRNumber of Material Documentnvarchar100
TOPRepetitive Manufacturing
131AFWISTable of Reprocessing Records Already Reposted3MBLNRNumber of Material Documentnvarchar100
132COMPMOVEGoods Movement of Components217MBLNRNumber of Material Documentnvarchar100
TOPResults Recording
133QIWLTransfer table for QM subsystems27MBLNRNumber of Material Documentnvarchar100
TOPReturnable Packaging Logistics
134RLACPOITAccount Posting Record12MBLNRNumber of Material Documentnvarchar100
135RLREPROCReprocessing Record for Returnable Packaging Acct Postings19MBLNRNumber of Material Documentnvarchar100
TOPSample Management
136QPRNSample drawing of phys. samples11MBLNRNumber of Material Documentnvarchar100
TOPSAP Retail Store
137WSTI_ART_RELPhysical Inventory During Open Time: Material Assignment2MBLNRNumber of Material Documentnvarchar100
138WSTI_MKPF_INDEXPhys. Inventory During Open Time: Material Doc. Index5MBLNRNumber of Material Documentnvarchar100
139WSTI_POS_EVENTPhysical Inventory in an Opened Store: POS Trans by Receipt7MBLNRNumber of Material Documentnvarchar100
TOPSerial Numbers
140SER03Document Header for Serial Numbers for Goods Movements3MBLNRNumber of Material Documentnvarchar100
141T377XDocuments Allowed for Serial Number Management23MBLNROptionality of Parameter Transfernvarchar10
TOPStock Visibility
142/DSD/SV_MM_DOCDSD SV Stock Transfer Documents per Tour3MBLNRNumber of Material Documentnvarchar100
TOPTariffs, Duties and Permits
143OIH30ITracking item7MBLNRNumber of Material Documentnvarchar100
144OIHLTRExcise license tracking pointer file4MBLNRNumber of Material Documentnvarchar100
145OIH_J_1BMSEG_NFLink between Gain and Losses Movements and Nota Fiscal3MBLNRNumber of Material Documentnvarchar100
TOPTraders and Schedulers Workbench
146OIGSVTD Vehicles in Transport/Shipment54MBLNRNumber of Material Documentnvarchar100
147OIJ03_LOVTSW: Table for Left on Vehicle Entries25MBLNRNumber of Material Documentnvarchar100
148OIJ03_LOVGLREFTSW Gain loss/LOV Reference table8MBLNRNumber of Material Documentnvarchar100
TOPTransaction Manager
149VTBMMORMM: open requests2MBLNRNumber of Material Documentnvarchar100
TOPTransportation and Distribution
150OIGSHTD Shipment History12MBLNRNumber of Material Documentnvarchar100
151OIGSMVTD Material Balance on Vehicle8MBLNRNumber of Material Documentnvarchar100
TOPVehicle Management System
152VLCGISSUEVELO : Material Document /Goods Issue5MBLNRNumber of Material Documentnvarchar100
153VLCGMOVEMVELO : Material Documents (Other)5MBLNRNumber of Material Documentnvarchar100
154VLCGRECEIPTVELO : Material Document / Goods Receipt5MBLNRNumber of Material Documentnvarchar100
TOPVendor Master
155PDTC_T_MBLNRMaterial Document Number2MBLNRNumber of Material Documentnvarchar100
TOPWarehouse Management
156LTAKWM transfer order header17MBLNRNumber of Material Documentnvarchar100
157LTBKTransfer requirement header23MBLNRNumber of Material Documentnvarchar100
158LUBUPosting Change Document6MBLNRNumber of Material Documentnvarchar100
TOPWaste Management
159EWA_ORDER_OBJECTItem Table for Waste Disposal Order56MBLNRNumber of Material Documentnvarchar100
160EWA_ORDER_WEIGHWeighing Data for Waste Disposal Order5MBLNRNumber of Material Documentnvarchar100
161EWA_WA_PCKGDSREGGeneral Cargo Entry28MBLNRNumber of Material Documentnvarchar100
162EWA_WA_WEIGHPROCWeighing Transaction71MBLNRNumber of Material Documentnvarchar100