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  | COMPMOVE
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
Production Planning and Control :: Repetitive Manufacturing
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0COMPMOVE2501Goods Movement of ComponentsRepetitive Manufacturing
SQL:  selectupdate insert create

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

SELECT MANDT, PRTNR, COMPPOS, LINE_ID, PARENT_ID, LINE_DEPTH, MAA_URZEI, CALLED_BY, BEAKZ, XNIBU, BWART, RECVSYSTEM, XRERE, XMEVO, XWAIT, XNOEQ, XDELIV, XNOCON, XMENGE, XSTOB, XSTOR, XAUTO, XWOFF, XLBTYPE, XZEROQUANTITY, MATNR, WERKS, LGORT, CHARG, INSMK, SOBKZ, KZBEW, KUNNR, BWTAR, ERFMG, ERFME, MENGE, MEINS, BPMNG, BPRME, EBELN, EBELP, ELIKZ, MIGO_ELIKZ, SGTXT, WEMPF, ABLAD, RSNUM, RSPOS, RSART, KZEAR, UMMAT, UMWRK, UMLGO, UMCHA, ZEKKN, ERFMG_ABD, BPMNG_ABD, BSTMG_ABD, XHISTMA, MULKO, SGT_SCAT, SGT_UMSCAT, SGT_UMSSREL, SGT_SSREL, SGT_RCAT, LGNUM, LGTYP, LGPLA, GRUND, EVERS, EVERE, KONTO, UMZST, UMZUS, UMBAR, LFBJA, LFBNR, LFPOS, VFDAT, CLASS, UMCLA, XCLAS, UMXCL, OBJNR, BSTMG, BSSKZ, GEBEH, ANZGEB, MAT_KDAUF, MAT_KDPOS, MAT_PSPNR, HSDAT, LICHA, MWSKZ, TXJCD, VLIEF_AVIS, VBELP_AVIS, VBELN, POSNR, ETENS, KALSM, GLOBAL_COUNTER, LSMNG, LSMEH, UPTYP, ANZSN, XSAUT, REVLV, EMATN, CUOBJ_CH, UMCUOBJ_CH, KOSTL, AUFNR, PS_PSP_PNR, KDAUF, KDPOS, KDEIN, NPLNR, VORNR, FIPOS, ANLN1, ANLN2, PAOBJNR, IMKEY, GEBER, FISTL, FKBER, LSTAR, PRZNR, KSTRG, GSBER, PRCTR, BUKRS, GRANT_NBR, MEASURE, BUDGET_PD, ZZSPREG, ZZBUSPARTN, ZZPRODUCT, ZZLOCA, ZZCHAN, ZZLOB, ZZNFAL, ZZUSERFLD1, ZZUSERFLD2, ZZUSERFLD3, ZZREGION, ZZSTATE, KBLNR, KBLPOS, FMFGUS_KEY, AUFPS, AUFPL, APLZL, DABRZ, EAN11_BME, EAN11_KON, EANME, WEANZ, WEANZX, R_MBLNR, R_MJAHR, DUMMY3, BATCH_TYPE, WRF_CHARSTC1, WRF_CHARSTC2, WRF_CHARSTC3, WTY_IND, KZVBR, WEUNB, SHKZG, WAERS, DMBTR, VPTNR, RSHKZ, BDMNG, ENMNG, QPLOS, SJAHR, SMBLN, SMBLP, QM_ZUSTD, QM_UMZST, BWLVS, UMREZ, UMREN, BDTER, TBBEL, TBBPO, TBBJR, AUTYP, QPLOA, TBPKZ, TAFKZ, KZEAR_OLD, UMLGT, UMLGP, MHDAT, EXIDV, BERKZ, PRVBE, KZECH, REFIX, ILINR, VOLUM, VOLEH, ANZL1, ANZL2, LMEN1, LMEN2, LETY1, LETY2, KZKUB, UBTYP, UBLGP, MBLNR, MBLPO, MJAHR, URZEI, KZBWS, KDAUF_SD, KDPOS_SD, BRGEW, GEWEI, WM_KZBEW, WENUM, KANBA, LFBJA_INTERNAL, LFBNR_INTERNAL, LFPOS_INTERNAL, UPVOR, BEMOT, PABNUM, PABPOS, PKKEY, PARBU, PARGB, PPRCTR, LIFNR, EXBWR, EXVKW, LLIEF, J_1BEXBASE, WEMPFX, ABLADX, OBJTYPE, SPE_GTS_STOCK_TY, SPE_UM_GTS_ST_TY, DISUB_OWNER FROM COMPMOVE
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2PRTNRConfirmation numbernvarchar100NUMC(N'0000000000')No*PRTNR Allow NULL? 
3COMPPOSInternal counternvarchar80NUMC(N'00000000')NoCIM_COUNT Allow NULL? 
4LINE_IDUnique identification of document linenvarchar60NUMC(N'000000')YesMB_LINE_ID Allow NULL? 
5PARENT_IDIdentifier of immediately superior linenvarchar60NUMC(N'000000')YesMB_PARENT_ID Allow NULL? 
6LINE_DEPTHHierarchy level of line in documentnvarchar20NUMC(N'00')YesMB_LINE_DEPTH Allow NULL? 
7MAA_URZEIOriginal Line for Account Assignment Item in Material Doc.nvarchar40NUMC(N'0000')YesMAA_URZEI Allow NULL? 
8CALLED_BYClear identification of caller of MB_CREATE_GOODS_MOVEMENTnvarchar200CHAR(N' ')Yes*CALLED_BY Allow NULL? 
9BEAKZLine already processedchar10CHAR(N' ')YesBEAKZ Allow NULL? 
10XNIBUCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
11BWARTMovement Type (Inventory Management)nvarchar30CHAR(N' ')Yes*BWART Allow NULL? 
12RECVSYSTEMReceiving logical systemnvarchar100CHAR(N' ')Yes*RECVSYSTEM Allow NULL? 
13XREREReservation reading is mandatorychar10CHAR(N' ')YesXRERE Allow NULL? 
14XMEVOPropose quantitieschar10CHAR(N' ')YesXMEVO Allow NULL? 
15XWAITCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
16XNOEQCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
17XDELIVCreate Delivery (Shipping)char10CHAR(N' ')YesXDELIV Allow NULL? 
18XNOCONQuantity conversion not necessarychar10CHAR(N' ')YesXNOCON Allow NULL? 
19XMENGEQuantity not converted for product unitschar10CHAR(N' ')YesXMENGE_PAR Allow NULL? 
20XSTOBReverse posting indicatorchar10CHAR(N' ')YesXSTOR Allow NULL? 
21XSTORReverse posting indicatorchar10CHAR(N' ')YesXSTOR Allow NULL? 
22XAUTOItem automatically createdchar10CHAR(N' ')YesMB_XAUTO Allow NULL? 
23XWOFFCalculation of val. openchar10CHAR(N' ')YesXWOFF Allow NULL? 
24XLBTYPESubcontracting item (PO item or component)char10CHAR(N' ')YesMIGO_LBITEM Allow NULL? 
25XZEROQUANTITYAllow Posting of Goods Movement Despite Zero Quantitychar10CHAR(N' ')YesXZEROQUANTITY Allow NULL? 
26MATNRMaterial Numbernvarchar180CHAR(N' ')YesMARAMATNR Allow NULL? 
27WERKSPlantnvarchar40CHAR(N' ')YesT001WWERKS_D Allow NULL? 
28LGORTStorage Locationnvarchar40CHAR(N' ')YesT001LLGORT_D Allow NULL? 
29CHARGBatch Numbernvarchar100CHAR(N' ')YesMCHACHARG_D Allow NULL? 
30INSMKStock Typechar10CHAR(N' ')YesMB_INSMK Allow NULL? 
31SOBKZSpecial Stock Indicatorchar10CHAR(N' ')YesT148SOBKZ Allow NULL? 
32KZBEWMovement Indicatorchar10CHAR(N' ')YesKZBEW Allow NULL? 
33KUNNRAccount Number of Customernvarchar100CHAR(N' ')YesKNA1EKUNN Allow NULL? 
34BWTARValuation Typenvarchar100CHAR(N' ')YesT149DBWTAR_D Allow NULL? 
35ERFMGQuantity in Unit of Entrydecimal133QUAN((0))YesMB_ERFMG
36ERFMEUnit of Entrynvarchar30UNIT(N' ')YesT006ERFME Allow NULL? 
37MENGEQuantitydecimal133QUAN((0))YesMENGE_D
38MEINSBase Unit of Measurenvarchar30UNIT(N' ')Yes*MEINS Allow NULL? 
39BPMNGQuantity in Purchase Order Price Unitdecimal133QUAN((0))YesBPMNG_INPUT
40BPRMEQuantity in Purchase Order Price Unitnvarchar30UNIT(N' ')YesT006MB_BPRME Allow NULL? 
41EBELNPurchase Order Numbernvarchar100CHAR(N' ')YesEKKOBSTNR Allow NULL? 
42EBELPItem Number of Purchasing Documentnvarchar50NUMC(N'00000')YesEKPOEBELP Allow NULL? 
43ELIKZ"Delivery Completed" Indicatorchar10CHAR(N' ')YesELIKZ Allow NULL? 
44MIGO_ELIKZ"Delivery Completed" Indicatorchar10NUMC(N'0')YesMIGO_ELIKZ Allow NULL? 
45SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
46WEMPFGoods Recipient/Ship-To Partynvarchar120CHAR(N' ')YesWEMPF Allow NULL? 
47ABLADUnloading Pointnvarchar250CHAR(N' ')YesABLAD Allow NULL? 
48RSNUMNumber of Reservation/Dependent Requirementnvarchar100NUMC(N'0000000000')Yes*RSNUM Allow NULL? 
49RSPOSItem Number of Reservation/Dependent Requirementnvarchar40NUMC(N'0000')YesRSPOS Allow NULL? 
50RSARTRecord typechar10CHAR(N' ')YesRSART Allow NULL? 
51KZEARFinal Issue for This Reservationchar10CHAR(N' ')YesKZEAR Allow NULL? 
52UMMATReceiving/Issuing Materialnvarchar180CHAR(N' ')YesMARAUMMAT Allow NULL? 
53UMWRKReceiving/Issuing Plantnvarchar40CHAR(N' ')YesT001WUMWRK Allow NULL? 
54UMLGOReceiving/Issuing Storage Locationnvarchar40CHAR(N' ')YesT001LUMLGO Allow NULL? 
55UMCHABatch Trfr Pstgnvarchar100CHAR(N' ')YesMCHAMIGO_UMCHA Allow NULL? 
56ZEKKNSequential Number of Account Assignmentnvarchar20NUMC(N'00')YesDZEKKN Allow NULL? 
57ERFMG_ABDQuantity in Unit of Entry for Amount-Based Distributionfloat1516FLTP((0))YesERFMG_ABD
58BPMNG_ABDQty in Order Price Unit for Amount-Based Distributionfloat1516FLTP((0))YesBPMNG_ABD
59BSTMG_ABDQuantity in Order Unit for Amount-Based Distributionfloat1516FLTP((0))YesBSTMG_ABD
60XHISTMAUpdate Multiple Account Assignment EKBE_MA, EKBZ_MAchar10CHAR(N' ')YesXHISTMA Allow NULL? 
61MULKOIndicator: Multiple account assignmentchar10CHAR(N' ')YesMULKO Allow NULL? 
62SGT_SCATStock Segmentnvarchar160CHAR(N' ')YesSGT_SCAT Allow NULL? 
63SGT_UMSCATReceiving/Issuing Stock Segmentnvarchar160CHAR(N' ')YesSGT_UMSCAT Allow NULL? 
64SGT_UMSSRELStock Segment Relevant Indicatorchar10CHAR(N' ')YesSGT_SSREL Allow NULL? 
65SGT_SSRELStock Segment Relevant Indicatorchar10CHAR(N' ')YesSGT_SSREL Allow NULL? 
66SGT_RCATRequirement Segmentnvarchar160CHAR(N' ')YesSGT_RCAT Allow NULL? 
67LGNUMWarehouse Number / Warehouse Complexnvarchar30CHAR(N' ')YesT300LGNUM Allow NULL? 
68LGTYPStorage Typenvarchar30CHAR(N' ')YesT301LGTYP Allow NULL? 
69LGPLAStorage Binnvarchar100CHAR(N' ')YesLAGPLGPLA Allow NULL? 
70GRUNDReason for Movementnvarchar40NUMC(N'0000')YesT157DMB_GRBEW Allow NULL? 
71EVERSShipping Instructionsnvarchar20CHAR(N' ')YesT027AEVERS Allow NULL? 
72EVERECompliance with Shipping Instructionsnvarchar20CHAR(N' ')YesT027CEVERE Allow NULL? 
73KONTOG/L Account Numbernvarchar100CHAR(N' ')Yes*SAKNR Allow NULL? 
74UMZSTStatus of Transfer Batchchar10CHAR(N' ')YesUMZST Allow NULL? 
75UMZUSStatus key of transfer batchchar10CHAR(N' ')YesUMZUS Allow NULL? 
76UMBARValuation Type of Transfer Posting Batchnvarchar100CHAR(N' ')YesT149DMIGO_UMBAR Allow NULL? 
77LFBJAFiscal Year of a Reference Documentnvarchar40NUMC(N'0000')YesLFBJA Allow NULL? 
78LFBNRDocument No. of a Reference Documentnvarchar100CHAR(N' ')YesLFBNR Allow NULL? 
79LFPOSItem of a Reference Documentnvarchar40NUMC(N'0000')YesLFPOS Allow NULL? 
80VFDATShelf Life Expiration or Best-Before Datenvarchar80DATS(N'00000000')YesVFDAT Allow NULL? 
81CLASSClass numbernvarchar180CHAR(N' ')YesKLASSE_D Allow NULL? 
82UMCLAClass numbernvarchar180CHAR(N' ')YesKLASSE_D Allow NULL? 
83XCLASCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
84UMXCLCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
85OBJNRObject numbernvarchar220CHAR(N' ')Yes*J_OBJNR Allow NULL? 
86BSTMGGoods receipt quantity in order unitdecimal133QUAN((0))YesMB_BSTMG
87BSSKZSpecial movement indicator for warehouse managementchar10CHAR(N' ')Yes*LVS_BSSKZ Allow NULL? 
88GEBEHLot Containernvarchar30UNIT(N' ')Yes*QGEBEH Allow NULL? 
89ANZGEBQM - No. of Containersdecimal63QUAN((0))YesQANZGEB
90MAT_KDAUFSales Order Number of Valuated Sales Order Stocknvarchar100CHAR(N' ')Yes*MAT_KDAUF Allow NULL? 
91MAT_KDPOSSales Order Item of Valuated Sales Order Stocknvarchar60NUMC(N'000000')YesMAT_KDPOS Allow NULL? 
92MAT_PSPNRValuated Sales Order Stock WBS Elementnvarchar80NUMC(N'00000000')Yes*MAT_PSPNR Allow NULL? 
93HSDATDate of Manufacturenvarchar80DATS(N'00000000')YesHSDAT Allow NULL? 
94LICHAVendor Batch Numbernvarchar150CHAR(N' ')YesLICHN Allow NULL? 
95MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')YesT007AMWSKZ Allow NULL? 
96TXJCDTax Jurisdictionnvarchar150CHAR(N' ')YesTTXJTXJCD Allow NULL? 
97VLIEF_AVISDeliverynvarchar100CHAR(N' ')Yes*VBELN_VL Allow NULL? 
98VBELP_AVISDelivery Itemnvarchar60NUMC(N'000000')Yes*POSNR_VL Allow NULL? 
99VBELNDeliverynvarchar100CHAR(N' ')Yes*VBELN_VL Allow NULL? 
100POSNRDelivery Itemnvarchar60NUMC(N'000000')Yes*POSNR_VL Allow NULL? 
101ETENSSequential Number of Vendor Confirmationnvarchar40NUMC(N'0000')YesETENS Allow NULL? 
102KALSMProcedure (Pricing, Output Control, Acct. Det., Costing,...)nvarchar60CHAR(N' ')Yes*KALSM_D Allow NULL? 
103GLOBAL_COUNTERUnique number for one linenvarchar60NUMC(N'000000')YesMIGO_GLOBAL_COUNTER Allow NULL? 
104LSMNGQuantity in Unit of Measure from Delivery Notedecimal133QUAN((0))YesLSMNG
105LSMEHUnit of Measure From Delivery Notenvarchar30UNIT(N' ')Yes*LSMEH Allow NULL? 
106UPTYPSubitem Category, Purchasing Documentchar10CHAR(N' ')Yes*UPTYP Allow NULL? 
107ANZSNNumber of Serial Numbers/Pieces of Equipment to be Createdint100INT4((0))YesANZSER Allow NULL? 
108XSAUTCreate serial number automaticallychar10CHAR(N' ')YesXSAUT Allow NULL? 
109REVLVRevision Levelnvarchar20CHAR(N' ')YesREVLV Allow NULL? 
110EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180CHAR(N' ')Yes*EMATN Allow NULL? 
111CUOBJ_CHInternal object number of the batch classificationnvarchar180NUMC(N'000000000000000000')YesCUOBJ_CH Allow NULL? 
112UMCUOBJ_CHInternal object number of the batch classificationnvarchar180NUMC(N'000000000000000000')YesCUOBJ_CH Allow NULL? 
113KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
114AUFNROrder Numbernvarchar120CHAR(N' ')YesAUFKAUFNR Allow NULL? 
115PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')YesPRPSPS_PSP_PNR Allow NULL? 
116KDAUFSales Order Numbernvarchar100CHAR(N' ')YesVBUKKDAUF Allow NULL? 
117KDPOSItem Number in Sales Ordernvarchar60NUMC(N'000000')YesKDPOS Allow NULL? 
118KDEINDelivery Schedule for Sales Ordernvarchar40NUMC(N'0000')YesKDEIN Allow NULL? 
119NPLNRNetwork Number for Account Assignmentnvarchar120CHAR(N' ')YesAUFKNPLNR Allow NULL? 
120VORNROperation/Activity Numbernvarchar40CHAR(N' ')YesVORNR Allow NULL? 
121FIPOSCommitment Itemnvarchar140CHAR(N' ')Yes*FIPOS Allow NULL? 
122ANLN1Main Asset Numbernvarchar120CHAR(N' ')Yes*ANLN1 Allow NULL? 
123ANLN2Asset Subnumbernvarchar40CHAR(N' ')Yes*ANLN2 Allow NULL? 
124PAOBJNRProfitability Segment Number (CO-PA)nvarchar100NUMC(N'0000000000')YesRKEOBJNR Allow NULL? 
125IMKEYInternal Key for Real Estate Objectnvarchar80CHAR(N' ')YesIMKEY Allow NULL? 
126GEBERFundnvarchar100CHAR(N' ')Yes*BP_GEBER Allow NULL? 
127FISTLFunds Centernvarchar160CHAR(N' ')Yes*FISTL Allow NULL? 
128FKBERFunctional Areanvarchar160CHAR(N' ')Yes*FKBER Allow NULL? 
129LSTARActivity Typenvarchar60CHAR(N' ')Yes*LSTAR Allow NULL? 
130PRZNRBusiness Processnvarchar120CHAR(N' ')Yes*CO_PRZNR Allow NULL? 
131KSTRGCost Objectnvarchar120CHAR(N' ')Yes*KSTRG Allow NULL? 
132GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
133PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
134BUKRSCompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
135GRANT_NBRGrantnvarchar200CHAR(N' ')YesGM_GRANT_NBR Allow NULL? 
136MEASUREFunded Programnvarchar240CHAR(N' ')Yes*FM_MEASURE Allow NULL? 
137BUDGET_PDFM: Budget Periodnvarchar100CHAR(N' ')Yes*FM_BUDGET_PERIOD Allow NULL? 
138ZZSPREGSpecial Regionnvarchar50CHAR(N' ')YesZZSPREGZREGION Allow NULL? 
139ZZBUSPARTNBusiness partnernvarchar100CHAR(N' ')YesZZBUSPARTN Allow NULL? 
140ZZPRODUCTProduct groupnvarchar100CHAR(N' ')YesZZPRODUCT Allow NULL? 
141ZZLOCACitynvarchar40CHAR(N' ')YesZZLOCA Allow NULL? 
142ZZCHANDistribution channelnvarchar40CHAR(N' ')YesZZCHAN Allow NULL? 
143ZZLOBBUSINESS LINEnvarchar70CHAR(N' ')Yes*ZZLOB Allow NULL? 
144ZZNFALnvarchar100(N' ')Yes Allow NULL? 
145ZZUSERFLD1Territorynvarchar90CHAR(N' ')YesZFU1ZZUSERFLD1 Allow NULL? 
146ZZUSERFLD2Owner/Cont.nvarchar120CHAR(N' ')YesZZUSERFLD2 Allow NULL? 
147ZZUSERFLD3Veinnvarchar220CHAR(N' ')YesZZUSERFLD3 Allow NULL? 
148ZZREGIONLocationnvarchar30CHAR(N' ')YesZREGZZREGION Allow NULL? 
149ZZSTATEState/Province Codenvarchar30CHAR(N' ')YesT005SZZSTATE Allow NULL? 
150KBLNRDocument Number for Earmarked Fundsnvarchar100CHAR(N' ')Yes*KBLNR_FI Allow NULL? 
151KBLPOSEarmarked Funds: Document Itemnvarchar30NUMC(N'000')Yes*KBLPOS Allow NULL? 
152FMFGUS_KEYUnited States Federal Government Fieldsnvarchar220CHAR(N' ')YesFMFG_US_KEY Allow NULL? 
153AUFPSOrder Item Numbernvarchar40NUMC(N'0000')YesCO_POSNR Allow NULL? 
154AUFPLRouting number of operations in the ordernvarchar100NUMC(N'0000000000')YesCO_AUFPL Allow NULL? 
155APLZLGeneral counter for ordernvarchar80NUMC(N'00000000')Yes*CO_APLZL Allow NULL? 
156DABRZReference Date for Settlementnvarchar80DATS(N'00000000')YesDABRBEZ Allow NULL? 
157EAN11_BMEInternational Article Number (EAN/UPC) in Order Unitnvarchar180CHAR(N' ')YesEAN11_BME Allow NULL? 
158EAN11_KONInternational Article Number (EAN/UPC) Checknvarchar180CHAR(N' ')YesEAN11_KON Allow NULL? 
159EANMEBase Unit of Measurenvarchar30UNIT(N' ')Yes*MEINS Allow NULL? 
160WEANZNumber of GR/GI Slips to Be Printednvarchar30NUMC(N'000')YesWEANZ Allow NULL? 
161WEANZXUpdated information in related user data fieldchar10CHAR(N' ')YesBAPIUPDATE Allow NULL? 
162R_MBLNRNumber of Material Documentnvarchar100CHAR(N' ')YesMBLNR Allow NULL? 
163R_MJAHRMaterial Document Yearnvarchar40NUMC(N'0000')YesMJAHR Allow NULL? 
164DUMMY3Checkboxchar10CHAR(N' ')YesXFELD Allow NULL? 
165BATCH_TYPEType of Batchchar10CHAR(N' ')YesBATCH_TYPE Allow NULL? 
166WRF_CHARSTC1Characteristic Value 1nvarchar180CHAR(N' ')YesWRF_CHARSTC1 Allow NULL? 
167WRF_CHARSTC2Characteristic Value 2nvarchar180CHAR(N' ')YesWRF_CHARSTC2 Allow NULL? 
168WRF_CHARSTC3Characteristic Value 3nvarchar180CHAR(N' ')YesWRF_CHARSTC3 Allow NULL? 
169WTY_INDWarranty indicatorchar10CHAR(N' ')YesWTYSC_WTY_INDICATOR Allow NULL? 
170KZVBRConsumption Postingchar10CHAR(N' ')YesKZVBR Allow NULL? 
171WEUNBGoods Receipt, Non-Valuatedchar10CHAR(N' ')YesWEUNB Allow NULL? 
172SHKZGDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
173WAERSCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
174DMBTRAmount in Local Currencydecimal132CURR((0))YesDMBTR
175VPTNRPartner account numbernvarchar100CHAR(N' ')YesKNA1JV_PART Allow NULL? 
176RSHKZDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
177BDMNGRequirement Quantitydecimal133QUAN((0))YesBDMNG
178ENMNGQuantity Withdrawndecimal133QUAN((0))YesENMNG
179QPLOSInspection Lot Numbernvarchar120NUMC(N'000000000000')YesQALSQPLOS Allow NULL? 
180SJAHRMaterial Document Yearnvarchar40NUMC(N'0000')YesMJAHR Allow NULL? 
181SMBLNNumber of Material Documentnvarchar100CHAR(N' ')YesMBLNR Allow NULL? 
182SMBLPItem in Material Documentnvarchar40NUMC(N'0000')YesMBLPO Allow NULL? 
183QM_ZUSTDBatch status with status changed in QM (internal)char10CHAR(N' ')YesQM_ZUSTD Allow NULL? 
184QM_UMZSTStatus of receiv. batch when status changed in QM (intern.)char10CHAR(N' ')YesQM_UMZST Allow NULL? 
185BWLVSMovement Type for Warehouse Managementnvarchar30NUMC(N'000')Yes*BWLVS Allow NULL? 
186UMREZNumerator for Conversion to Base Units of Measuredecimal50DEC((0))YesUMREZ
187UMRENDenominator for conversion to base units of measuredecimal50DEC((0))YesUMREN
188BDTERRequirement Date for the Componentnvarchar80DATS(N'00000000')YesBDTER Allow NULL? 
189TBBELMaterial doc. no. of transfer requirement to be cancellednvarchar100CHAR(N' ')YesLVS_TBBEL Allow NULL? 
190TBBPOMaterial doc. item of transf.reqmnt item to be cancellednvarchar40NUMC(N'0000')YesLVS_TBBPO Allow NULL? 
191TBBJRMaterial doc. year of transfer requirement to be cancellednvarchar40NUMC(N'0000')YesLVS_TBBJR Allow NULL? 
192AUTYPOrder categorynvarchar20NUMC(N'00')YesAUFTYP Allow NULL? 
193QPLOAInspection Lot on Which the Usage Decision is Basednvarchar120NUMC(N'000000000000')Yes*QPLOA Allow NULL? 
194TBPKZIndicator: No Transfer Requirement Createdchar10CHAR(N' ')YesLVS_TBFKZ Allow NULL? 
195TAFKZIndicator: do not cal up automatic TO creationchar10CHAR(N' ')YesLVS_TAFKZ Allow NULL? 
196KZEAR_OLDFinal Issue for This Reservationchar10CHAR(N' ')YesKZEAR Allow NULL? 
197UMLGTStorage type for stock transfernvarchar30CHAR(N' ')Yes*UMLGT Allow NULL? 
198UMLGPStorage bin for stock transfernvarchar100CHAR(N' ')Yes*UMLGP Allow NULL? 
199MHDATSLED/Best-Before Date or Date of Productionnvarchar80DATS(N'00000000')YesTMHHD Allow NULL? 
200EXIDVExternal Handling Unit Identificationnvarchar200CHAR(N' ')YesEXIDV Allow NULL? 
201BERKZMaterial Staging Indicator for Production Supplychar10CHAR(N' ')YesBERKZ Allow NULL? 
202PRVBEProduction Supply Areanvarchar100CHAR(N' ')Yes*PRVBE Allow NULL? 
203KZECHDetermination of batch entry in the production/process orderchar10CHAR(N' ')YesKZECH Allow NULL? 
204REFIXField defined as in SY-TABIXint100INT4((0))YesTABIX_D Allow NULL? 
205ILINRIDoc line item numbernvarchar60NUMC(N'000000')YesILINR Allow NULL? 
206VOLUMVolumedecimal153QUAN((0))YesVOLUM_15
207VOLEHVolume unitnvarchar30UNIT(N' ')Yes*VOLEH Allow NULL? 
208ANZL1Number of Storage Units to be Placed Into Storagedecimal30DEC((0))YesLVS_ANZLE
209ANZL2Number of Storage Units to be Placed Into Storagedecimal30DEC((0))YesLVS_ANZLE
210LMEN1Quantity per Storage Unit to be Placed into Stock in Alt.UoMdecimal133QUAN((0))YesLVS_LEMEN
211LMEN2Quantity per Storage Unit to be Placed into Stock in Alt.UoMdecimal133QUAN((0))YesLVS_LEMEN
212LETY1Storage Unit Typenvarchar30CHAR(N' ')Yes*LVS_LETYP Allow NULL? 
213LETY2Storage Unit Typenvarchar30CHAR(N' ')Yes*LVS_LETYP Allow NULL? 
214KZKUBIndicator: Do not create posting change noticechar10CHAR(N' ')YesLVS_KZKUB Allow NULL? 
215UBTYPStorage type for transfer postingnvarchar30CHAR(N' ')Yes*UBTYP Allow NULL? 
216UBLGPStorage bin for transfer postingnvarchar100CHAR(N' ')Yes*UBPLA Allow NULL? 
217MBLNRNumber of Material Documentnvarchar100CHAR(N' ')YesMBLNR Allow NULL? 
218MBLPOItem in Material Documentnvarchar40NUMC(N'0000')YesMBLPO Allow NULL? 
219MJAHRMaterial Document Yearnvarchar40NUMC(N'0000')YesMJAHR Allow NULL? 
220URZEIOriginal line in material documentnvarchar40NUMC(N'0000')YesURZEI Allow NULL? 
221KZBWSValuation of Special Stockchar10CHAR(N' ')YesKZBWS Allow NULL? 
222KDAUF_SDSales Order Numbernvarchar100CHAR(N' ')Yes*KDAUF Allow NULL? 
223KDPOS_SDItem Number in Sales Ordernvarchar60NUMC(N'000000')YesKDPOS Allow NULL? 
224BRGEWGross weightdecimal153QUAN((0))YesBRGEW_15
225GEWEIWeight Unitnvarchar30UNIT(N' ')Yes*GEWEI Allow NULL? 
226WM_KZBEWMovement Indicatorchar10CHAR(N' ')YesKZBEW Allow NULL? 
227WENUMGoods Receipt Numbernvarchar100CHAR(N' ')YesLVS_WENUM Allow NULL? 
228KANBAKanban Indicatorchar10CHAR(N' ')YesKBNKZ Allow NULL? 
229LFBJA_INTERNALFiscal Year of a Reference Documentnvarchar40NUMC(N'0000')YesLFBJA Allow NULL? 
230LFBNR_INTERNALDocument No. of a Reference Documentnvarchar100CHAR(N' ')YesLFBNR Allow NULL? 
231LFPOS_INTERNALItem of a Reference Documentnvarchar40NUMC(N'0000')YesLFPOS Allow NULL? 
232UPVORSubitems Existchar10CHAR(N' ')YesUPVOR Allow NULL? 
233BEMOTAccounting Indicatornvarchar20CHAR(N' ')YesTBMOTBEMOT Allow NULL? 
234PABNUMJIT Call Numbernvarchar100CHAR(N' ')Yes*PABNUM Allow NULL? 
235PABPOSJIT call itemnvarchar40NUMC(N'0000')YesPABPOS Allow NULL? 
236PKKEYIdentification Numbernvarchar100NUMC(N'0000000000')Yes*PKKEY Allow NULL? 
237PARBUClearing company codenvarchar40CHAR(N' ')Yes*PARBU Allow NULL? 
238PARGBTrading partner's business areanvarchar40CHAR(N' ')Yes*PARGB Allow NULL? 
239PPRCTRPartner Profit Centernvarchar100CHAR(N' ')Yes*PPRCTR Allow NULL? 
240LIFNRVendor Account Numbernvarchar100CHAR(N' ')Yes*ELIFN Allow NULL? 
241EXBWRExternally Entered Posting Amount in Local Currencydecimal132CURR((0))YesEXBWR
242EXVKWExternally Entered Sales Value in Local Currencydecimal132CURR((0))YesEXVKW
243LLIEFSupplying Vendornvarchar100CHAR(N' ')Yes*LLIEF Allow NULL? 
244J_1BEXBASEAlternate base amount in document currencydecimal132CURR((0))YesJ_1BEXBASE
245WEMPFXUpdated information in related user data fieldchar10CHAR(N' ')YesBAPIUPDATE Allow NULL? 
246ABLADXUpdated information in related user data fieldchar10CHAR(N' ')YesBAPIUPDATE Allow NULL? 
247OBJTYPEChange indicatorchar10CHAR(N' ')YesOCM_OBJ_TYPE Allow NULL? 
248SPE_GTS_STOCK_TYGTS Stock Typechar10CHAR(N' ')Yes/SPE/GTS_STOCK_TYPE Allow NULL? 
249SPE_UM_GTS_ST_TYGTS Stock Typechar10CHAR(N' ')Yes/SPE/GTS_STOCK_TYPE Allow NULL? 
250DISUB_OWNEROwner of stocknvarchar100CHAR(N' ')Yes*OWNER_D Allow NULL? 
NamePrimaryUniqueTypeColumns
COMPMOVE~0YesYesCLUSTEREDCOMPPOS, PRTNR, 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