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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

160 columns | Print definition?ERP 6.0  | ZEILE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GBTINT/EVHUSGBT: Handling Units related to MDoc / WM TO6ZEILEItem in Material Documentnvarchar40
2/XFT/EPA_T0002Customizing header data3ZEILELinetinyint30
3FAGL_011QT_XBRLFin. Statement Structure: Text for Fin. Statement Items6ZEILELine number of the financial statement itemnvarchar10
4FAGL_GCDQT_VERGCD Revision: Text of GCD table8ZEILELine number of the financial statement itemnvarchar10
5FAGL_GCDQT_XBRLGCD-Structure: Text of GCD table6ZEILELine number of the financial statement itemnvarchar10
6FIEUD_GOODS_ISAFT-XML:Goods Movement Line Items5ZEILEItem in Material Documentnvarchar40
7FIEUD_SBINV_ISAFT: Self Billing Invoices ( Line Items)41ZEILEItem in Material Documentnvarchar40
8J1IEX_LICUTL_LOGEXIM : License Detail4ZEILEItem Numbernvarchar40
9J_1I_LICDTLEXIM : License Detail4ZEILEItem Numbernvarchar40
10J_1I_PMLICUTILEXIM : License Utilization4ZEILEItem Numbernvarchar40
11MWOFF_CL4ZEILEnvarchar40
12T011QTable no longer in use6ZEILELine number of the financial statement itemnvarchar10
13T237Name of report structure4ZEILEFormula of a Key Figure Schemenvarchar40
14TDMFCADW Data with Incorrect Code1ZEILELine numbernvarchar60
15TER14Search objects2ZEILE2-Digit Numeric Valuenvarchar20
TOPAccounting Interface
16GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)378ZEILEItem in material or invoice verification documentnvarchar60
17GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)378ZEILEItem in material or invoice verification documentnvarchar60
TOPActual CostingMaterial Ledger
18CKMLDUVCOUsage Differences for Each Account Assignment Object12ZEILEItem Within a Documentnvarchar40
TOPAdvertising Management
19TJHVPLIS-M/AM: Field Selection for List Format6ZEILELine Numbernvarchar30
20TJHVPLTIS-M/AM: Field Selection For Display Variants List Tool5ZEILELine Numbernvarchar30
TOPBalance Sheet Valuation Procedures
21MYSEG_EXTRACTDocument Segment: Material7ZEILEItem in Material Documentnvarchar40
TOPBank Customer Accounts
22BKKPOREFRReferences for EDI Payments, Position, Ref. Data Segment8ZEILEItem numbernvarchar60
23FINSTA_POSTable for FINSTA Items (Used, e.g.,in CREATE_FINSTA)3ZEILEVersion Number Componentnvarchar20
TOPBasic Data
24TNS22IS-H: Line Texts for Statistics3ZEILEIS-H: Identification of a Row Within Statisticsnvarchar50
25TNS23IS-H: Assignment of Services to Lines in Statistics4ZEILEIS-H: Identification of a Row Within Statisticsnvarchar50
26TNS27IS-H: Variable Totaling of Geog. Statistics3ZEILEIS-H: Statistics Row of Geographical Area Statisticsnvarchar50
TOPBasic functions
27HUWM_LOAD_PROTLog Table of Initial Data Transfer for Subsequent Posting64ZEILEID for an HU Item Lineint100
TOPConsumer Products for Food Beverage
28CFB_WEIGH_LISTDatabase of Weigh List4ZEILEItem in Material Documentnvarchar40
TOPContract Billing
29TEPREPAY_NATUREDescription of Complaint Reason3ZEILEPrepayment Document Linenvarchar60
TOPControlling
30COPPP_ITMCO Postprocessing List - Items6ZEILEAccounting Document Line Item Numbernvarchar100
TOPCost Object
31FCO_DOC_POSFailure Cost Document Item3ZEILEItem of Failure Cost Documentnvarchar60
TOPData Modeler
32TDM01Data Model Conversion Log1ZEILELine numbernvarchar60
TOPData Retention Tool
33TXW_S_MSEGRetrieve MSEG from archive10ZEILEItem in Material Documentnvarchar40
TOPDevice Management
34TE554Random No. Table acc. to DIN 57411ZEILEStarting line in random number tablenvarchar20
TOPDistribution of Usage Variances
35CKMLDUVNCOUsage Differences for Each Account Assignment Object12ZEILEItem Within a Documentnvarchar40
36DUVMSEG_EXTRACTduv mseg extract for performance4ZEILEItem in Material Documentnvarchar40
TOPExchanges
37OIA11Exchange assignment for deliveries17ZEILELine Numbernvarchar30
38OIA12Exchange assignment for bulk shipments18ZEILELine Numbernvarchar30
39OIA12IMovement Based Netting document item11ZEILEItem numbernvarchar60
40OIAQBExchange Movements Index16ZEILEItem numbernvarchar60
TOPExcise Duty
41/BEV2/CS_ITEMCS Process: Items4ZEILEItem in Material Documentnvarchar40
42/BEV2/CS_IT_HEMCS Process: Items - History5ZEILEItem in Material Documentnvarchar40
43/BEV2/CS_MSEGARCEMCS Process: ARC in Material Document Items4ZEILEItem in Material Documentnvarchar40
44/BEV2/CS_MSEGA_HEMCS Process: ARC in Material Document Items - History4ZEILEItem in Material Documentnvarchar40
45/BEV2/ED922Header Lines for Tax Warehouse4ZEILELine Numbernvarchar30
46/BEV2/ED922THeader Lines for Tax Warehouse5ZEILELine Numbernvarchar30
47/BEV2/EDMSEExcise Duty Document Table4ZEILEItem in Material Documentnvarchar40
48/BEV2/EDMSSMaterial Documents Whose Processing Flags Have to Be Reset4ZEILEItem in Material Documentnvarchar40
49/BEV2/EDMSTDocument Texts for Manual Corrections4ZEILEItem in Material Documentnvarchar40
50/BEV2/ED_LDS_POSAAD: France: AAD Header4ZEILEItem in Material Documentnvarchar40
TOPExternal Services
51ESLTService Item Short Texts5ZEILELine Numbernvarchar100
52ESLZService Type Lines4ZEILELine Numbernvarchar100
53ESSTService Item Short Texts5ZEILELine Numbernvarchar100
TOPF1 Help
54GCTABTable with lines of chosen values1ZEILELine counter type I for performance reasonsint100
TOPFinancial Accounting
55/CCEE/SIFIDDVSpecial Tax Table6ZEILEItem in Material Documentnvarchar40
56/CCEE/SIFIPE17Temporary import of goods4ZEILEItem in Material Documentnvarchar40
57ACCTITCompressed Data from FI/CO Document134ZEILEItem in material or invoice verification documentnvarchar60
TOPForeign Trade
58/SAPSLL/CUWLAR3Relevant Goods Issues for Transfer to SAP GTS4ZEILEItem in Material Documentnvarchar40
TOPGeneral Ledger Accounting
59FAGL_011QTFin. Statement Structure: Text for Fin. Statement Items6ZEILELine number of the financial statement itemnvarchar10
TOPHydrocarbon Product Management
60MSEGO1Quantity Conversion Parameters for Material Documents4ZEILEItem in Material Documentnvarchar40
61MSEGO2Material Document Quantities in Additional Units of Measure4ZEILEItem in Material Documentnvarchar40
62OIB09Log for missing MSEGO1 and MSEGO2 documents4ZEILEItem in Material Documentnvarchar40
63OIB_MIGO_HQCIStore the QCI-GOITEM for MIGOs hold/restore feature7ZEILEItem in Material Documentnvarchar40
64OIB_MIGO_HTSTStore the TST-GOITEM for MIGOs hold/restore feature6ZEILEItem in Material Documentnvarchar40
TOPIncentive and Commission Management ICM
65CACS_BUFFLOGCommissions: Log Table of Commission Objects7ZEILEIdentification of an Item in (Sub)Objectnvarchar40
66CACS_EDTPROTCommissions: Log for EDT Interface Supply10ZEILEIdentification of an Item in (Sub)Objectnvarchar40
TOPInspection Lot Completion
67QAMBQM: Link Between Inspection Lot and Material Document7ZEILEItem in Material Documentnvarchar40
TOPInventory Management
68CHVWTable CHVW for Batch Where-Used List14ZEILEItem in Material Documentnvarchar40
69IMEXTEnhancement Fields for Goods Receipt4ZEILEItem in Material Documentnvarchar40
70ISEGPhysical Inventory Document Items37ZEILEItem in Material Documentnvarchar40
71MARIShort document: material movement4ZEILELine Numbernvarchar30
72MIGO_BADI_EXAMPLBADI in MIGO: Example Table4ZEILEItem in Material Documentnvarchar40
73MMINKON_UPCorrections due to Technical Problems with Stock37ZEILEItem in Material Documentnvarchar40
74MSEGDocument Segment: Material4ZEILEItem in Material Documentnvarchar40
75MWXMSEGZMSEG: Interface for Posting of Value4ZEILEItem in Material Documentnvarchar40
76MWXVM07MFields: Update Control of Module Pool SAPMM07M4ZEILEItem in Material Documentnvarchar40
77MWYMBUZLine Assignment4ZEILEItem in Material Documentnvarchar40
78MWZDM07M1ZDM07M14ZEILEItem in Material Documentnvarchar40
79MWZDM07M2ZDM07M24ZEILEItem in Material Documentnvarchar40
80MWZMBUZZMBUZ4ZEILEItem in Material Documentnvarchar40
81MWZMSEGZMSEG:Interface for Posting of Value4ZEILEItem in Material Documentnvarchar40
82MWZVM07MFields: Update Control of Module Pool SAPMM07M4ZEILEItem in Material Documentnvarchar40
TOPInvoice Verification
83RKWAConsignment Withdrawals4ZEILEItem in Material Documentnvarchar40
84RSEGDocument Item: Incoming Invoice93ZEILEItem Numbernvarchar40
TOPJoint Venture und Production Sharing Accounting
85CRP_MIGO_BADI_TBBADI in MIGO: Example Table4ZEILEItem in Material Documentnvarchar40
TOPLoans Management
86TSZE1Sales data for acct statements3ZEILEVersion Number Componentnvarchar20
TOPLocalization
87J_1BFIFOINIncoming FIFO relevant Consignment movements (BRAZIL)7ZEILEItem in Material Documentnvarchar40
88J_1BFIFOOUTOutgoing FIFO relevant Consignment movements (BRAZIL)7ZEILEItem in Material Documentnvarchar40
89J_1IBONDExcise Bonding: Bonds/UT-/Running Bond master4ZEILEItem Numbernvarchar40
90J_1ICALOCAllocation of materials to assets7ZEILELine Numbernvarchar30
91J_1IEXCDEPExcise information of vendor at detail level for depot5ZEILEItem Numbernvarchar40
92J_1IEXCDTLExcise invoice line item details5ZEILEItem Numbernvarchar40
93J_1IGRXREFGoods Receipt to Excise Invoice Coss Reference4ZEILEItem in Material Documentnvarchar40
94J_1IGRXSUBGR reference to subcontracting challans4ZEILEItem in Material Documentnvarchar40
95J_1IITMDTLItem Details - for Capital goods and subcontracting5ZEILELine Numbernvarchar30
96J_1IKONVExcise recalculated conditions9ZEILELine Numbernvarchar30
97J_1IPART1Excise part I detials8ZEILEItem in Material Documentnvarchar40
98J_1IQRDEPQuarterly Returns Depot structure3ZEILEItem Numbernvarchar40
99J_1IRAINDTLArticle Inward Note Detail29ZEILEItem in Material Documentnvarchar40
100J_1IRG1Excise RG1 details8ZEILEItem in Material Documentnvarchar40
101J_1IRG23DRG23D register for the depot5ZEILEItem number - GR at depotnvarchar40
102J_1ISUBBYPSubcontracting Scrap/ Byproduct5ZEILEItem Numbernvarchar40
103J_3RFGTDMATGTD usage in material documents11ZEILEItem in Material Documentnvarchar40
104J_3RMWOINMaterial issues without invoices.4ZEILEItem in Material Documentnvarchar40
105J_3RSCCDSUBITMCargo Customs Declaration Subitems14ZEILEItem in Material Documentnvarchar40
TOPMaintenance Orders
106AUFMGoods movements for order4ZEILEItem in Material Documentnvarchar40
TOPManufacturer Part Number
107ADPIC_HOLD_MIGOStore BADI goitem for MIGO hold / restore functionality7ZEILEItem in Material Documentnvarchar40
TOPMaterial Categories
108/ISDFPS/MPO_TEXTStructure of Long Text MPO2ZEILELine numbernvarchar20
TOPMaterial Master
109WSTN_AL_MSGPrepack allocation table posting messages4ZEILELine numbernvarchar220
TOPMaterials Management
110/SAPNEA/ROWAChargeable component consumptions4ZEILEItem in Material Documentnvarchar40
111ROWAIndex table : Chargeable component consumptions4ZEILEItem in Material Documentnvarchar40
112RPOD_IDXGoods Movement Synchronized with a SUS/ICH System4ZEILEItem in Material Documentnvarchar40
TOPMaterials Management MM enhancements
113/SAPMP/MIGOBPMNGBAdI in MIGO: Cumulated Order Price Quantity4ZEILEItem in Material Documentnvarchar40
TOPPatient Management
114TNS28IS-H: Assignment of org. units to services in statistics4ZEILEIS-H: Identification of a Row Within Statisticsnvarchar50
TOPPayment Transactions
115CRFILESTATPayment Card File: Status Information for Individual Records24ZEILELine numbernvarchar220
TOPPegging, Grouping, and Distribution
116PEG_CNSMPTN2WBSPegging: Consumption Posting to WBS element details4ZEILEItem in Material Documentnvarchar40
117PEG_TGTG_EXCA&D GPD: Group to group initial peg10ZEILEItem in Material Documentnvarchar40
TOPPersonnel Time Management
118HRAAERRError Table for Activity Allocation Documents in HR3ZEILEDocument itemnvarchar30
TOPPrint and Output Management
119TSP0LSpool events38ZEILELog linenvarchar50
TOPProduct Safety
120CCRCT_PULOEHS: Reference to Confirmed Purchased Quantities4ZEILEItem in Material Documentnvarchar40
121CCRCT_SOLOEHS: Reference to Confirmed Sold Quantities (CCRCT_SO)4ZEILEItem in Material Documentnvarchar40
TOPProduction Orders
122COWIPB_CHVWWIP Batches with Where-Used List23ZEILEItem in Material Documentnvarchar40
TOPProduction Planning and Control PP enhancements
123MILL_PBWUMill: Process Batches with Usage22ZEILEItem in Material Documentnvarchar40
TOPProfitability Analysis
124T237ADisplay control for T2374ZEILEFormula of a Key Figure Schemenvarchar40
125T237TText table for T2375ZEILEFormula of a Key Figure Schemenvarchar40
126TKEBWKYFAssignment of Key Figure Scheme Rows to Fields in CEBWKYF5ZEILEFormula of a Key Figure Schemenvarchar40
TOPPublic Sector
127T5D5RSupp. Pension Pub. Sector: Customizing fr Contrib. Statement4ZEILELine numbernvarchar20
TOPPurchasing
128T16LDRoutines for Structure of Requisition Lists4ZEILELine Categorynvarchar10
TOPQuality Certificates
129QCPRQM quality certificates in procurement15ZEILEItem in Material Documentnvarchar40
TOPQuality Inspection
130QALSInspection lot record119ZEILEItem in Material Documentnvarchar40
131QAPPInspection point42ZEILEItem in Material Documentnvarchar40
TOPRegulatory reporting for insurance companies
132ISSR_CUSTOUT_FMTOutput Format5ZEILEnvarchar30
133ISSR_CUST_ROWSUMRow sum information.7ZEILEnvarchar30
134ISSR_OUT_BUFFERISSR: var. Plazierung der Felder auf SF mit Hilfe Methoden6ZEILEZeile pro Andrucknvarchar30
135TISSR_OUT_BUFFERISSR: var. Plazierung der Felder auf SF mit Hilfe Methoden6ZEILEZeile pro Andrucknvarchar30
136TISSR_OUT_CTFIBLISSR: var. Plazierung der Felder mit Hilfe von Methoden6ZEILEZeile pro Andrucknvarchar30
137TISSR_OUT_FICUS2ISSR: var. Plazierung der Felder auf SF mit Hilfe Methoden5ZEILEZeile pro Andrucknvarchar30
138TISSR_OUT_FICUS3ISSR: var. Plazierung der Felder auf SF mit Hilfe Methoden5ZEILEZeile pro Andrucknvarchar30
139TISSR_OUT_FICUSTISSR: var. Plazierung der Felder auf SF mit Hilfe Methoden5ZEILEZeile pro Andrucknvarchar30
140TISSR_OUT_HEADERISSR: variable Köpfe für Listausgabe SMARTFORMS5ZEILEZeile pro Andrucknvarchar30
TOPSample Management
141QPRNSample drawing of phys. samples12ZEILEItem in Material Documentnvarchar40
TOPSAP Healthcare - Industry-Specific Components for Hospitals
142TNA30EIS-H: Geographical areas - locations (AT)4ZEILEIS-H: Statistics Row of Geographical Area Statisticsnvarchar50
143TNA30VIS-H: Insurance statistics (AT)13ZEILEIS-H: Statistics Row of Geographical Area Statisticsnvarchar50
TOPSAP Retail Store
144WSTI_ART_RELPhysical Inventory During Open Time: Material Assignment4ZEILEItem in Material Documentnvarchar40
145WSTI_POS_EVENTPhysical Inventory in an Opened Store: POS Trans by Receipt10ZEILEItem in Material Documentnvarchar40
TOPSerial Numbers
146SER03Document Header for Serial Numbers for Goods Movements5ZEILEItem in Material Documentnvarchar40
147T377XDocuments Allowed for Serial Number Management27ZEILEOptionality of Parameter Transfernvarchar10
TOPSession Manager
148SSM_STARTTable for specifying the initial menu in the Session Manager1ZEILELine numbernvarchar10
TOPTariffs, Duties and Permits
149OIHLTRExcise license tracking pointer file6ZEILELine Numbernvarchar30
150OIH_J_1BMSEG_NFLink between Gain and Losses Movements and Nota Fiscal5ZEILEItem in Material Documentnvarchar40
TOPTime Sheet
151CATS_TEMPCATS: Database Table for Templates5ZEILELine Position in CATS Templatenvarchar30
TOPTraders and Schedulers Workbench
152OIJ03_LOVTSW: Table for Left on Vehicle Entries27ZEILEItem in Material Documentnvarchar40
153OIJ03_LOVGLREFTSW Gain loss/LOV Reference table9ZEILEItem in Material Documentnvarchar40
TOPTransaction Manager
154VTBMMORMM: open requests4ZEILEItem in Material Documentnvarchar40
TOPTransportation and Distribution
155OIGSMVTD Material Balance on Vehicle10ZEILEItem in Material Documentnvarchar40
TOPTravel Planning
156FTPT_VAR_INFOInfo texts for travel plan variants10ZEILELines of info text for a variantnvarchar1320
157TA22RSASTART: Train Attributes3ZEILELine for attribute textsmallint50
TOPTreasury
158SMESGTMessage collector with time stamp2ZEILELine numbernvarchar220
TOPVariant Configuration
159TCULConfiguration: Configuration Result Layout3ZEILELinenvarchar20
160TCUZConfiguration: Configuration Result Layout -Line-3ZEILE2-Digit Numeric Valuenvarchar20