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

161 columns | Print definition?ERP 6.0  | MJAHR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GBTINT/EVHUSGBT: Handling Units related to MDoc / WM TO5MJAHRMaterial Document Yearnvarchar40
2ARBERP_D_RCTTRIGTrigger Table: Send Receipt Request cXML Messages6MJAHRMaterial Document Yearnvarchar40
3ARBERP_D_SO_RCPTReceipt Request Message Payload ID For Outbound Messages3MJAHRMaterial Document Yearnvarchar40
4CNVTDMS_05_MDOCFill Header for Material Documents (IS-OIL)4MJAHRMaterial Document Yearnvarchar40
5CNV_20551_MBLNRMaterial documents selected for deletion4MJAHRMaterial doc. yearnvarchar40
6FIEUD_GOODSCNTSAFT:MM: XML Goods movement Transaction Count and Summary3MJAHRMaterial Document Yearnvarchar40
7FIEUD_GOODS_HSAFT:XML:Goods Movement Header4MJAHRMaterial Document Yearnvarchar40
8FIEUD_GOODS_ISAFT-XML:Goods Movement Line Items4MJAHRMaterial Document Yearnvarchar40
9FIEUD_SBINV_ISAFT: Self Billing Invoices ( Line Items)40MJAHRMaterial Document Yearnvarchar40
10J_3RF_RGTORG_INIncoming Journal of Acceptance Documents9MJAHRMaterial Document Yearnvarchar40
11MWOFF_CL3MJAHRnvarchar40
12WSPT_LIKPDocuments For Portugal Webservice7MJAHRMaterial Document Yearnvarchar40
TOPActual CostingMaterial Ledger
13CKMLDUVCOUsage Differences for Each Account Assignment Object11MJAHRFiscal Year of the Documentnvarchar40
14MLITMBMaterial valuation document row information6MJAHRMaterial Document Yearnvarchar40
TOPAdditionals Management
15WTADABAdditionals: Documents9MJAHRMaterial Document Yearnvarchar40
TOPBalance Sheet Valuation Procedures
16MYML1LIFO: Transaction-Related Material Layer6MJAHRMaterial Document Yearnvarchar40
17MYML1QLIFO: Transaction-Related Material Layer (Quantity)6MJAHRMaterial Document Yearnvarchar40
18MYML1VLIFO: Transaction-Related Material Layer (Values)6MJAHRMaterial Document Yearnvarchar40
19MYMP1Receipt Data LFIO/FIFO Valuation7MJAHRMaterial Document Yearnvarchar40
20MYSEG_EXTRACTDocument Segment: Material6MJAHRMaterial Document Yearnvarchar40
TOPBasic functions
21HUINV_ITEMHandling Unit: Physical Inventory Document Item30MJAHRMaterial Document Yearnvarchar40
22HUMSEGReference-HU-Item for Material Doc.Item that was Posted Last6MJAHRMaterial Document Yearnvarchar40
TOPBasic Functions
23VBFASales Document Flow41MJAHRMaterial Document Yearnvarchar40
TOPClinical System
24N1BCPMAT_RD_MMServices: Material Integration for Additional Data4MJAHRMaterial Document Yearnvarchar40
25N1DRUGDOCIS-H*MED: Drug Documentation19MJAHRMedication: Material Document Yearnvarchar40
26N1EDRUGIS-H*MED: Drug Event - Drug Assignment21MJAHRYear for which levy is to be carried outnvarchar40
27N1OLDDOCIS-H*MED: Medication; History for N1DRUGDOC6MJAHRMaterial Document Yearnvarchar40
TOPConfirmations
28AFFWGoods Movements with Errors from Confirmations60MJAHRMaterial Document Yearnvarchar40
29AFWISubsequently posted goods movements for confirmations5MJAHRMaterial Document Yearnvarchar40
TOPConstruction Equipment Management
30J_3GBELKDocument File - Header Data150MJAHRMaterial Document Yearnvarchar40
TOPConsumer Products for Food Beverage
31CFB_WEIGH_LISTDatabase of Weigh List3MJAHRMaterial Document Yearnvarchar40
TOPCross-Application Components
32/OPT/S_GR_HDRVSS Staging Table: GR Header3MJAHRMaterial Document Yearnvarchar40
33/OPT/S_GR_LINVSS Stageing Table: GR Line3MJAHRMaterial Document Yearnvarchar40
TOPData Retention Tool
34TXW_S_MKPFRetrieve MKPF from archive10MJAHRMaterial Document Yearnvarchar40
35TXW_S_MSEGRetrieve MSEG from archive9MJAHRMaterial Document Yearnvarchar40
TOPDistribution of Usage Variances
36CKMLDUVNCOUsage Differences for Each Account Assignment Object11MJAHRFiscal Year of the Documentnvarchar40
37DUVMSEG_EXTRACTduv mseg extract for performance3MJAHRMaterial Document Yearnvarchar40
TOPExchanges
38OIA08LIA Document: Item Data3MJAHRMaterial Document Yearnvarchar40
39OIA08HLIA Document: Header Data3MJAHRMaterial Document Yearnvarchar40
40OIA11Exchange assignment for deliveries16MJAHRMaterial Document Yearnvarchar40
41OIA12Exchange assignment for bulk shipments17MJAHRMaterial Document Yearnvarchar40
42OIA12IMovement Based Netting document item10MJAHRMaterial Document Yearnvarchar40
43OIAQBExchange Movements Index15MJAHRMaterial Document Yearnvarchar40
TOPExcise Duty
44/BEV2/CS_HDEMCS Process: Header Data7MJAHRMaterial Document Yearnvarchar40
45/BEV2/CS_HD_HEMCS Process: Header Data - History8MJAHRMaterial Document Yearnvarchar40
46/BEV2/CS_MEMORYEMCS Process: Table for Shared Buffer7MJAHRMaterial Document Yearnvarchar40
47/BEV2/CS_MSEGARCEMCS Process: ARC in Material Document Items3MJAHRMaterial Document Yearnvarchar40
48/BEV2/CS_MSEGA_HEMCS Process: ARC in Material Document Items - History3MJAHRMaterial Document Yearnvarchar40
49/BEV2/EDMSEExcise Duty Document Table2MJAHRMaterial Document Yearnvarchar40
50/BEV2/EDMSSMaterial Documents Whose Processing Flags Have to Be Reset2MJAHRMaterial Document Yearnvarchar40
51/BEV2/EDMSTDocument Texts for Manual Corrections2MJAHRMaterial Document Yearnvarchar40
52/BEV2/ED_LDS_HDRAAD: France: AAD Header2MJAHRMaterial Document Yearnvarchar40
53/BEV2/ED_LDS_MNTLDS: AAD Management Table2MJAHRMaterial Document Yearnvarchar40
54/BEV2/ED_LDS_POSAAD: France: AAD Header2MJAHRMaterial Document Yearnvarchar40
TOPFinancial Accounting
55/CCEE/SIFIDDVSpecial Tax Table5MJAHRMaterial Document Yearnvarchar40
56/CCEE/SIFIPE17Temporary import of goods3MJAHRMaterial Document Yearnvarchar40
TOPForeign Trade
57/SAPSLL/BWHSTR3Customs WH-Relevant Data for Two-Step Stock Transfer Process8MJAHRMaterial Document Yearnvarchar40
58/SAPSLL/CUWLAR3Relevant Goods Issues for Transfer to SAP GTS3MJAHRMaterial Document Yearnvarchar40
TOPHydrocarbon Product Management
59MSEGO1Quantity Conversion Parameters for Material Documents3MJAHRMaterial Document Yearnvarchar40
60MSEGO2Material Document Quantities in Additional Units of Measure3MJAHRMaterial Document Yearnvarchar40
61OIB09Log for missing MSEGO1 and MSEGO2 documents3MJAHRMaterial Document Yearnvarchar40
62OIB_MIGO_HQCIStore the QCI-GOITEM for MIGOs hold/restore feature6MJAHRMaterial Document Yearnvarchar40
63OIB_MIGO_HTSTStore the TST-GOITEM for MIGOs hold/restore feature5MJAHRMaterial Document Yearnvarchar40
TOPInspection Lot Completion
64QAMBQM: Link Between Inspection Lot and Material Document6MJAHRMaterial Document Yearnvarchar40
TOPInterface to Terminal Automation System
65OIK02BIS-OIL/TAS: Status of processed functions - messages25MJAHRMaterial Document Yearnvarchar40
TOPInventory Management
66CHVWTable CHVW for Batch Where-Used List13MJAHRMaterial Document Yearnvarchar40
67IMEXTEnhancement Fields for Goods Receipt3MJAHRMaterial Document Yearnvarchar40
68ISEGPhysical Inventory Document Items36MJAHRMaterial Document Yearnvarchar40
69MARIShort document: material movement3MJAHRMaterial Document Yearnvarchar40
70MIGO_BADI_EXAMP2BADI in MIGO: Example Table (Header)3MJAHRMaterial Document Yearnvarchar40
71MIGO_BADI_EXAMPLBADI in MIGO: Example Table3MJAHRMaterial Document Yearnvarchar40
72MKPFHeader: Material Document3MJAHRMaterial Document Yearnvarchar40
73MKPF_ARIDXIndex table for single doc. access to archive MM_MATBEL3MJAHRMaterial Document Yearnvarchar40
74MMINKON_UPCorrections due to Technical Problems with Stock36MJAHRMaterial Document Yearnvarchar40
75MSEGDocument Segment: Material3MJAHRMaterial Document Yearnvarchar40
76MWMKPFHeader Table for the Interface5MJAHRMaterial Document Yearnvarchar40
77MWXMSEGZMSEG: Interface for Posting of Value3MJAHRMaterial Document Yearnvarchar40
78MWXVM07MFields: Update Control of Module Pool SAPMM07M3MJAHRMaterial Document Yearnvarchar40
79MWYMBUZLine Assignment3MJAHRMaterial Document Yearnvarchar40
80MWZDM07M1ZDM07M13MJAHRMaterial Document Yearnvarchar40
81MWZDM07M2ZDM07M23MJAHRMaterial Document Yearnvarchar40
82MWZMBUZZMBUZ3MJAHRMaterial Document Yearnvarchar40
83MWZMSEGZMSEG:Interface for Posting of Value3MJAHRMaterial Document Yearnvarchar40
84MWZVM07MFields: Update Control of Module Pool SAPMM07M3MJAHRMaterial Document Yearnvarchar40
TOPInvoice Verification
85RBDRSEGBatch IV: Invoice Document Items74MJAHRMaterial Document Yearnvarchar40
86RKWAConsignment Withdrawals3MJAHRMaterial Document Yearnvarchar40
TOPJoint Venture und Production Sharing Accounting
87CRP_MIGO_BADI_TBBADI in MIGO: Example Table3MJAHRMaterial Document Yearnvarchar40
TOPJust-In-Time Processing
88JITOGRGoods Receipts for JIT Outbound Calls5MJAHRMaterial Document Yearnvarchar40
TOPLocalization
89J_1BFIFOINIncoming FIFO relevant Consignment movements (BRAZIL)6MJAHRMaterial Document Yearnvarchar40
90J_1BFIFOOUTOutgoing FIFO relevant Consignment movements (BRAZIL)6MJAHRMaterial Document Yearnvarchar40
91J_1BPOSCOUPONSPOS-Database Coupons (Brazilian)24MJAHRMaterial Document Yearnvarchar40
92J_1ICALOCAllocation of materials to assets6MJAHRMaterial Document Yearnvarchar40
93J_1IGRXREFGoods Receipt to Excise Invoice Coss Reference3MJAHRMaterial Document Yearnvarchar40
94J_1IGRXSUBGR reference to subcontracting challans2MJAHRMaterial Document Yearnvarchar40
95J_1IITMDTLItem Details - for Capital goods and subcontracting3MJAHRMaterial Document Yearnvarchar40
96J_1IPART1Excise part I detials7MJAHRMaterial Document Yearnvarchar40
97J_1IRAINDTLArticle Inward Note Detail28MJAHRMaterial Document Yearnvarchar40
98J_1IRAINHDRArticle Inward Note Header18MJAHRMaterial Document Yearnvarchar40
99J_1IRG1Excise RG1 details7MJAHRMaterial Document Yearnvarchar40
100J_1IRG23DRG23D register for the depot9MJAHRMaterial Document Yearnvarchar40
101J_3RFGTDMATGTD usage in material documents10MJAHRMaterial Document Yearnvarchar40
102J_3RMWOINMaterial issues without invoices.3MJAHRMaterial Document Yearnvarchar40
103J_3RSCCDSUBITMCargo Customs Declaration Subitems12MJAHRMaterial Document Yearnvarchar40
TOPMaintenance Notifications
104QMELQuality Notification73MJAHRMaterial Document Yearnvarchar40
TOPMaintenance Orders
105AUFMGoods movements for order3MJAHRMaterial Document Yearnvarchar40
TOPManufacturer Part Number
106ADPIC_HOLD_MIGOStore BADI goitem for MIGO hold / restore functionality6MJAHRMaterial Document Yearnvarchar40
TOPMaterials Management
107/SAPNEA/ROWAChargeable component consumptions3MJAHRMaterial Document Yearnvarchar40
108J_1GMM2GVEnd year inventory3MJAHRMaterial Document Yearnvarchar40
109J_1GVL_MLMaterial Ledger31MJAHRMaterial Document Yearnvarchar40
110ROWAIndex table : Chargeable component consumptions3MJAHRMaterial Document Yearnvarchar40
111RPOD_IDXGoods Movement Synchronized with a SUS/ICH System3MJAHRMaterial Document Yearnvarchar40
TOPMaterials Management MM enhancements
112/SAPMP/MIGOBPMNGBAdI in MIGO: Cumulated Order Price Quantity3MJAHRMaterial Document Yearnvarchar40
TOPMeasuring Points and Counters
113EAM_IFCUGoods Movement for Technical Object6MJAHRMaterial Document Yearnvarchar40
TOPMedia Product Sales and Distribution
114JKSDUNSOLDGRFLOWIS-M: Goods Receipt Document Flow for Unsold Copies5MJAHRMaterial Document Yearnvarchar40
TOPPatient Accounting
115NMATPIS-H: Material planned for case9MJAHRIS-H MM: Material Document Yearnvarchar40
116NMATVIS-H: Material Entered for Case11MJAHRIS-H MM: Material Document Yearnvarchar40
TOPPegging, Grouping, and Distribution
117PEG_CNSMPTN2WBSPegging: Consumption Posting to WBS element details3MJAHRMaterial Document Yearnvarchar40
118PEG_TGTG_EXCA&D GPD: Group to group initial peg9MJAHRMaterial Document Yearnvarchar40
TOPProduct Safety
119CCRCT_PULOEHS: Reference to Confirmed Purchased Quantities5MJAHRMaterial Document Yearnvarchar40
120CCRCT_SOLOEHS: Reference to Confirmed Sold Quantities (CCRCT_SO)5MJAHRMaterial Document Yearnvarchar40
TOPProduction Orders
121COWIPB_CHVWWIP Batches with Where-Used List22MJAHRMaterial Document Yearnvarchar40
TOPProduction Planning and Control PP enhancements
122MILL_PBWUMill: Process Batches with Usage21MJAHRMaterial Document Yearnvarchar40
TOPQuality Certificates
123QCPRQM quality certificates in procurement13MJAHRMaterial Document Yearnvarchar40
TOPQuality Inspection
124QALSInspection lot record117MJAHRMaterial Document Yearnvarchar40
125QAPPInspection point41MJAHRMaterial Document Yearnvarchar40
TOPR2-R3 Link
126LDK01Communication Record 01 Decentralized WMS: GR/GI R/2 -> ERP25MJAHRMaterial Document Yearnvarchar40
127LDK02Communicat.Record 02 Decentralized WMS: Transfer R/2 -> ERP30MJAHRMaterial Document Yearnvarchar40
128LDK06Communic.Record 06 Decentr.WMS (R/2-ERP):Batch Status Change15MJAHRMaterial Document Yearnvarchar40
TOPRepetitive Manufacturing
129AFWISTable of Reprocessing Records Already Reposted4MJAHRMaterial Document Yearnvarchar40
130COMPMOVEGoods Movement of Components219MJAHRMaterial Document Yearnvarchar40
TOPReturnable Packaging Logistics
131RLACPOITAccount Posting Record13MJAHRMaterial Document Yearnvarchar40
132RLREPROCReprocessing Record for Returnable Packaging Acct Postings20MJAHRMaterial Document Yearnvarchar40
TOPSample Management
133QPRNSample drawing of phys. samples13MJAHRMaterial Document Yearnvarchar40
TOPSAP Retail Store
134WSTI_ART_RELPhysical Inventory During Open Time: Material Assignment3MJAHRMaterial Document Yearnvarchar40
135WSTI_MKPF_INDEXPhys. Inventory During Open Time: Material Doc. Index6MJAHRMaterial Document Yearnvarchar40
136WSTI_POS_EVENTPhysical Inventory in an Opened Store: POS Trans by Receipt9MJAHRMaterial Document Yearnvarchar40
TOPSerial Numbers
137SER03Document Header for Serial Numbers for Goods Movements4MJAHRMaterial Document Yearnvarchar40
138SER07Document Header for Serial Numbers in Physical Inventory5MJAHRFiscal Yearnvarchar40
139T377XDocuments Allowed for Serial Number Management25MJAHROptionality of Parameter Transfernvarchar10
TOPStock Visibility
140/DSD/SV_MM_DOCDSD SV Stock Transfer Documents per Tour4MJAHRMaterial Document Yearnvarchar40
TOPTariffs, Duties and Permits
141OIH30ITracking item8MJAHRMaterial Document Yearnvarchar40
142OIHLTRExcise license tracking pointer file5MJAHRMaterial Document Yearnvarchar40
143OIH_J_1BMSEG_NFLink between Gain and Losses Movements and Nota Fiscal4MJAHRMaterial Document Yearnvarchar40
TOPTraders and Schedulers Workbench
144OIGSVTD Vehicles in Transport/Shipment55MJAHRMaterial Document Yearnvarchar40
145OIJ03_LOVTSW: Table for Left on Vehicle Entries26MJAHRMaterial Document Yearnvarchar40
146OIJ03_LOVGLREFTSW Gain loss/LOV Reference table10MJAHRMaterial Document Yearnvarchar40
147OIJ_EL_DFLOW_SUBTSW - Document flow for sub items8MJAHRMaterial Document Yearnvarchar40
148OIJ_EL_DOC_FLOWOIL TSW: Document flow10MJAHRMaterial Document Yearnvarchar40
149OIJ_EL_ELOG_SUBTSW: Error log for ticketing process at sub item9MJAHRMaterial Document Yearnvarchar40
150OIJ_EL_ERROR_LOGOIL-TSW: Error log for ticketing process13MJAHRMaterial Document Yearnvarchar40
TOPTransaction Manager
151VTBMMORMM: open requests3MJAHRMaterial Document Yearnvarchar40
TOPTransportation and Distribution
152OIGSHTD Shipment History13MJAHRMaterial Document Yearnvarchar40
153OIGSMVTD Material Balance on Vehicle9MJAHRMaterial Document Yearnvarchar40
TOPVehicle Management System
154VLCGISSUEVELO : Material Document /Goods Issue6MJAHRMaterial Document Yearnvarchar40
155VLCGMOVEMVELO : Material Documents (Other)6MJAHRMaterial Document Yearnvarchar40
156VLCGRECEIPTVELO : Material Document / Goods Receipt6MJAHRMaterial Document Yearnvarchar40
TOPWarehouse Management
157LTAKWM transfer order header18MJAHRMaterial Document Yearnvarchar40
158LTBKTransfer requirement header24MJAHRMaterial Document Yearnvarchar40
159LUBUPosting Change Document5MJAHRMaterial Document Yearnvarchar40
TOPWaste Management
160EWA_ORDER_WEIGHWeighing Data for Waste Disposal Order7MJAHRMaterial Document Yearnvarchar40
161EWA_WA_WEIGHPROCWeighing Transaction72MJAHRMaterial Document Yearnvarchar40