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

Home | ERP 6.0  | /OPT/VIM_1ITEM
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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OINM101Whse Journal
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Financial Accounting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/OPT/VIM_1ITEM1381Document ItemFinancial Accounting
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, DOCID, ITEMID, BUKRS, EBELN, EBELP, MATNR, MAKTX, MENGE, BSTME, BPRME, WRBTR, WERKS, LFSNR, SHKZG, COND_TYPE, NETPR, TAX_RATE1, TAX_CODE1, TAX_AMOUNT, ZERO_TAX_RATE1, LSTAR, ANLN2, ZUONR, SGENR, GSBER, KOSTL, KSTRG, KBLNR, EREKZ, FKONT, FIPOS, FKBER, GEBER, FISTL, HKONT, AUFNR, SGTXT, KOKRS, SMIVE, NPLNR, PARGB, PPRCT, PRCTR, PROJK, WRBTR_PROP, SGRNR, RECNNR, VBELN, VBELP, ETENR, SNKSL, SMENR, MWSKZ, TXJCD, VBUND, VORNR, PS_POSID, XSKRL, BWTAR, SVWNR, PAOBJNR, PASUBNR, CURR_APPROVER, REF_DOC, REF_DOC_YEAR, REF_DOC_IT, SHEET_NO, SHEET_ITEM, BUPLA, TAXRATE1_1, TAXRATE2_2, TAXRATE3_3, TAXRATE4_4, TAXAMT_1, TAXAMT_2, TAXAMT_3, TAXAMT_4, SERIAL_NO, CFOP, XREF1, XREF2, FIKRS, KUNNR, PRZNR, ANLN1, HRKFT, ZEKKN, VPTNR, BWKEY, GRANT_NBR, BEWAR, VALUT, PERNR, KBLPOS, SEMPSL, DABRZ, VERTN, VNAME, EGRUP, RECID, PRODPER, SWENR, CUSTOM_FIELD1, CUSTOM_FIELD2, CUSTOM_FIELD3, CUSTOM_FIELD4, CUSTOM_FIELD5, CUSTOM_FIELD6, CUSTOM_FIELD7, CUSTOM_FIELD8, CUSTOM_FIELD9, CUSTOM_FIELD10, PACKNO, INTROW, BSMNG, REMNG, WEMNG, QUALIFIER, MATCH_STATUS, FLAG_WORKED, ALTERNATIVE, TBTKZ, COSTS, FLAG_ADDED, HERKL, LANDX, DECLARATION, EXTINDEX, NFNET, ITMNUM, ICMS_BASE, ICMS_RATE, ICMS_VALUE, IPI_BASE, IPI_RATE, IPI_VALUE, NBM FROM /OPT/VIM_1ITEM
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2DOCIDDocument Ledger Numbernvarchar120NUMC(N'000000000000')No/OPT/VIM_1HEAD/OPT/DOCID Allow NULL? 
3ITEMIDDocument Item Idnvarchar50NUMC(N'00000')No/OPT/DOCITEMID Allow NULL? 
4BUKRSCompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
5EBELNPurchasing Document Numbernvarchar100CHAR(N' ')Yes*/OPT/EBELN Allow NULL? 
6EBELPItem Number of Purchasing Documentnvarchar50NUMC(N'00000')Yes*/OPT/EBELP Allow NULL? 
7MATNRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
8MAKTXMaterial Description (Short Text)nvarchar400CHAR(N' ')YesMAKTX Allow NULL? 
9MENGEQuantitydecimal133QUAN((0))YesMENGE_D
10BSTMEPurchase Order Unit of Measurenvarchar30UNIT(N' ')Yes*/OPT/BSTME Allow NULL? 
11BPRMEOrder Price Unit (Purchasing)nvarchar30UNIT(N' ')Yes*/OPT/BBPRM Allow NULL? 
12WRBTRAmount in document currencydecimal132CURR((0))YesWRBTR
13WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
14LFSNRNumber of External Delivery Notenvarchar160CHAR(N' ')YesLFSNR Allow NULL? 
15SHKZGDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
16COND_TYPECondition Typenvarchar40CHAR(N' ')Yes*KSCHL Allow NULL? 
17NETPRNet Price in Purchasing Document (in Document Currency)decimal112CURR((0))YesBPREI
18TAX_RATE1Data element for Tax ratedecimal123DEC((0))Yes/OPT/VIM_TAX_RATE
19TAX_CODE1Tax Codenvarchar20CHAR(N' ')Yes*/OPT/VIM_TAX_CODE Allow NULL? 
20TAX_AMOUNTAmount in document currencydecimal132CURR((0))YesWRBTR
21ZERO_TAX_RATE1Commentnvarchar500CHAR(N' ')YesCHAR50 Allow NULL? 
22LSTARActivity Typenvarchar60CHAR(N' ')Yes*LSTAR Allow NULL? 
23ANLN2Asset Subnumbernvarchar40CHAR(N' ')Yes*ANLN2 Allow NULL? 
24ZUONRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
25SGENRBuilding Numbernvarchar80CHAR(N' ')Yes*SGENR Allow NULL? 
26GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
27KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
28KSTRGCost Objectnvarchar120CHAR(N' ')Yes*KSTRG Allow NULL? 
29KBLNRDocument Number for Earmarked Fundsnvarchar100CHAR(N' ')Yes*KBLNR Allow NULL? 
30EREKZFinal Invoice Indicatorchar10CHAR(N' ')YesEREKZ Allow NULL? 
31FKONTFinancial Budget Itemnvarchar30NUMC(N'000')YesFIPLS Allow NULL? 
32FIPOSCommitment Itemnvarchar140CHAR(N' ')Yes*FIPOS Allow NULL? 
33FKBERFunctional Areanvarchar160CHAR(N' ')Yes*FKBER Allow NULL? 
34GEBERFundnvarchar100CHAR(N' ')Yes*BP_GEBER Allow NULL? 
35FISTLFunds Centernvarchar160CHAR(N' ')Yes*FISTL Allow NULL? 
36HKONTGeneral Ledger Accountnvarchar100CHAR(N' ')Yes*HKONT Allow NULL? 
37AUFNROrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
38SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
39KOKRSControlling Areanvarchar40CHAR(N' ')Yes*KOKRS Allow NULL? 
40SMIVELease-Out Numbernvarchar130CHAR(N' ')YesSMIVE Allow NULL? 
41NPLNRNetwork Number for Account Assignmentnvarchar120CHAR(N' ')Yes*NPLNR Allow NULL? 
42PARGBTrading partner's business areanvarchar40CHAR(N' ')Yes*PARGB Allow NULL? 
43PPRCTPartner Profit Centernvarchar100CHAR(N' ')Yes*PPRCTR Allow NULL? 
44PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
45PROJKWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')Yes*PS_PSP_PNR Allow NULL? 
46WRBTR_PROPAmount in document currencydecimal132CURR((0))YesWRBTR
47SGRNRProperty Number for BEnvarchar80CHAR(N' ')Yes*SGRNR Allow NULL? 
48RECNNRReal Estate Contract Numbernvarchar130CHAR(N' ')YesRECNNR Allow NULL? 
49VBELNSales and Distribution Document Numbernvarchar100CHAR(N' ')Yes*VBELN Allow NULL? 
50VBELPSales document itemnvarchar60NUMC(N'000000')Yes*VBELP Allow NULL? 
51ETENRDelivery Schedule Line Numbernvarchar40NUMC(N'0000')Yes*ETENR Allow NULL? 
52SNKSLService Charge Keynvarchar40CHAR(N' ')Yes*SNKSL Allow NULL? 
53SMENRNumber of Rental Unitnvarchar80CHAR(N' ')Yes*SMENR Allow NULL? 
54MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
55TXJCDTax Jurisdictionnvarchar150CHAR(N' ')Yes*TXJCD Allow NULL? 
56VBUNDCompany IDnvarchar60CHAR(N' ')Yes*VBUND Allow NULL? 
57VORNROperation/Activity Numbernvarchar40CHAR(N' ')YesVORNR Allow NULL? 
58PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240CHAR(N' ')YesPS_POSID Allow NULL? 
59XSKRLIndicator: Line item not liable to cash discount?char10CHAR(N' ')YesXSKRL Allow NULL? 
60BWTARValuation Typenvarchar100CHAR(N' ')Yes*BWTAR_D Allow NULL? 
61SVWNRManagement Contract Numbernvarchar130CHAR(N' ')Yes*VVSVWNR Allow NULL? 
62PAOBJNRProfitability Segment Number (CO-PA)nvarchar100NUMC(N'0000000000')YesRKEOBJNR Allow NULL? 
63PASUBNRProfitability segment changes (CO-PA)nvarchar40NUMC(N'0000')YesRKESUBNR Allow NULL? 
64CURR_APPROVEROpen Text User Mapping Object IDnvarchar350CHAR(N' ')Yes*/ORS/UMOID Allow NULL? 
65REF_DOCNumber of Material Documentnvarchar100CHAR(N' ')YesMBLNR Allow NULL? 
66REF_DOC_YEARMaterial Document Yearnvarchar40NUMC(N'0000')YesMJAHR Allow NULL? 
67REF_DOC_ITItem in Material Documentnvarchar40NUMC(N'0000')YesMBLPO Allow NULL? 
68SHEET_NODocument No. of a Reference Documentnvarchar100CHAR(N' ')YesLFBNR Allow NULL? 
69SHEET_ITEMItem of a Reference Documentnvarchar40NUMC(N'0000')YesLFPOS Allow NULL? 
70BUPLABusiness Placenvarchar40CHAR(N' ')Yes*BUPLA Allow NULL? 
71TAXRATE1_1Data element for Tax ratedecimal123DEC((0))Yes/OPT/VIM_TAX_RATE
72TAXRATE2_2Data element for Tax ratedecimal123DEC((0))Yes/OPT/VIM_TAX_RATE
73TAXRATE3_3Data element for Tax ratedecimal123DEC((0))Yes/OPT/VIM_TAX_RATE
74TAXRATE4_4Data element for Tax ratedecimal123DEC((0))Yes/OPT/VIM_TAX_RATE
75TAXAMT_1Amountdecimal132CURR((0))Yes/OPT/RMWWR
76TAXAMT_2Amountdecimal132CURR((0))Yes/OPT/RMWWR
77TAXAMT_3Amountdecimal132CURR((0))Yes/OPT/RMWWR
78TAXAMT_4Amountdecimal132CURR((0))Yes/OPT/RMWWR
79SERIAL_NOSerial Numbernvarchar200CHAR(N' ')Yes/OPT/VIM_SERIAL_NO Allow NULL? 
80CFOPCFOP Code and Extensionnvarchar100CHAR(N' ')Yes*J_1BCFOP Allow NULL? 
81XREF1Business partner reference keynvarchar120CHAR(N' ')YesXREF1 Allow NULL? 
82XREF2Business partner reference keynvarchar120CHAR(N' ')YesXREF2 Allow NULL? 
83FIKRSFinancial Management Areanvarchar40CHAR(N' ')Yes*FIKRS Allow NULL? 
84KUNNRCustomer Numbernvarchar100CHAR(N' ')Yes*KUNNR Allow NULL? 
85PRZNRBusiness Processnvarchar120CHAR(N' ')Yes*CO_PRZNR Allow NULL? 
86ANLN1Main Asset Numbernvarchar120CHAR(N' ')Yes*ANLN1 Allow NULL? 
87HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40CHAR(N' ')Yes*HRKFT Allow NULL? 
88ZEKKNSequential Number of Account Assignmentnvarchar20NUMC(N'00')YesDZEKKN Allow NULL? 
89VPTNRPartner account numbernvarchar100CHAR(N' ')Yes*JV_PART Allow NULL? 
90BWKEYValuation Areanvarchar40CHAR(N' ')Yes*BWKEY Allow NULL? 
91GRANT_NBRGrantnvarchar200CHAR(N' ')YesGM_GRANT_NBR Allow NULL? 
92BEWARTransaction Typenvarchar30CHAR(N' ')Yes*RMVCT Allow NULL? 
93VALUTValue datenvarchar80DATS(N'00000000')YesVALUT Allow NULL? 
94PERNRPersonnel Numbernvarchar80NUMC(N'00000000')YesPERNR_D Allow NULL? 
95KBLPOSEarmarked Funds: Document Itemnvarchar30NUMC(N'000')Yes*KBLPOS Allow NULL? 
96SEMPSLSettlement Unitnvarchar50CHAR(N' ')Yes*SEMPSL Allow NULL? 
97DABRZReference Date for Settlementnvarchar80DATS(N'00000000')YesDABRBEZ Allow NULL? 
98VERTNContract Numbernvarchar130CHAR(N' ')YesRANL Allow NULL? 
99VNAMEJoint Venturenvarchar60CHAR(N' ')Yes*JV_NAME Allow NULL? 
100EGRUPEquity groupnvarchar30CHAR(N' ')Yes*JV_EGROUP Allow NULL? 
101RECIDRecovery Indicatornvarchar20CHAR(N' ')Yes*JV_RECIND Allow NULL? 
102PRODPERProduction Month (Date to find period and year)nvarchar80DATS(N'00000000')YesJV_PRODPER Allow NULL? 
103SWENRSite Numbernvarchar80CHAR(N' ')Yes*SWENR Allow NULL? 
104CUSTOM_FIELD1Character Field Length = 10nvarchar100CHAR(N' ')YesCHAR10 Allow NULL? 
105CUSTOM_FIELD2Char 20nvarchar200CHAR(N' ')YesCHAR20 Allow NULL? 
106CUSTOM_FIELD3Character field of length 40nvarchar400CHAR(N' ')YesCHAR40 Allow NULL? 
107CUSTOM_FIELD4Char 80nvarchar800CHAR(N' ')YesCHAR80 Allow NULL? 
108CUSTOM_FIELD5Field of type DATSnvarchar80DATS(N'00000000')YesDATS Allow NULL? 
109CUSTOM_FIELD62-Digit Numeric Valuenvarchar20NUMC(N'00')YesNUM2 Allow NULL? 
110CUSTOM_FIELD7Four-digit numbernvarchar40NUMC(N'0000')YesNUM4 Allow NULL? 
111CUSTOM_FIELD8Internal pointernvarchar50NUMC(N'00000')YesNUM5 Allow NULL? 
112CUSTOM_FIELD9Single-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
113CUSTOM_FIELD10Text (20 Characters)nvarchar200CHAR(N' ')YesTEXT20 Allow NULL? 
114PACKNOPackage Number of Servicenvarchar100NUMC(N'0000000000')Yes*PACKNO_EKBE Allow NULL? 
115INTROWLine Number of Servicenvarchar100NUMC(N'0000000000')YesINTROW_EKBE Allow NULL? 
116BSMNGQuantity Ordered Against this Purchase Requisitiondecimal133QUAN((0))YesBSMNG
117REMNGQuantity invoiceddecimal133QUAN((0))YesREMNG
118WEMNGQuantity of Goods Receiveddecimal133QUAN((0))YesWEMNG
119QUALIFIERQualifier for additional costsnvarchar300CHAR(N' ')Yes/OPT/IC_QUALIFIER Allow NULL? 
120MATCH_STATUSStatus item matchingchar10CHAR(N' ')Yes/OPT/ITEM_MATCHSTATUS Allow NULL? 
121FLAG_WORKEDFlag for accountant to mark items "work finished"char10CHAR(N' ')Yes/OPT/FLAG_WORK_FINISHED Allow NULL? 
122ALTERNATIVECost handling alternativenvarchar20CHAR(N' ')Yes/OPT/ALTERNATIVE Allow NULL? 
123TBTKZIndicator: subsequent debit/creditchar10CHAR(N' ')YesTBTKZ Allow NULL? 
124COSTSAdditional Costs Amountdecimal132CURR((0))Yes/OPT/COSTS
125FLAG_ADDEDIndicator whether add. costs have been added to line itemchar10CHAR(N' ')Yes/OPT/VIM_FLAG_COSTS_ADD Allow NULL? 
126HERKLCountry of origin of the materialnvarchar30CHAR(N' ')Yes*HERKL Allow NULL? 
127LANDXCountry Namenvarchar150CHAR(N' ')YesLANDX Allow NULL? 
128DECLARATIONCharacter field, length 28nvarchar280CHAR(N' ')YesCHAR28 Allow NULL? 
129EXTINDEXDocument Item Idnvarchar50NUMC(N'00000')Yes*/OPT/DOCITEMID Allow NULL? 
130NFNETNet Value including taxesdecimal152CURR((0))YesJ_1BNFNET
131ITMNUMDocument Item Numbernvarchar60NUMC(N'000000')YesJ_1BITMNUM Allow NULL? 
132ICMS_BASEBase amountdecimal152CURR((0))YesJ_1BBASE
133ICMS_RATETax Ratedecimal62DEC((0))YesJ_1BTXRATE
134ICMS_VALUETax valuedecimal152CURR((0))YesJ_1BTAXVAL
135IPI_BASEBase amountdecimal152CURR((0))YesJ_1BBASE
136IPI_RATETax Ratedecimal62DEC((0))YesJ_1BTXRATE
137IPI_VALUETax valuedecimal152CURR((0))YesJ_1BTAXVAL
138NBMControl code for consumption taxes in foreign tradenvarchar160CHAR(N' ')Yes*STEUC Allow NULL? 
NamePrimaryUniqueTypeColumns
/OPT/VIM_1ITEM~0YesYesCLUSTEREDITEMID, DOCID, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy