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  | VSVBAP_CN
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
Project System :: Simulation
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VSVBAP_CN2103Version: Sales document: Item dataSimulation
SQL:  selectupdate insert create

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

SELECT MANDT, VSNMR, VBELN, POSNR, MATNR, MATWA, PMATN, CHARG, MATKL, ARKTX, PSTYV, POSAR, LFREL, FKREL, UEPOS, GRPOS, ABGRU, PRODH, ZWERT, ZMENG, ZIEME, UMZIZ, UMZIN, MEINS, SMENG, ABLFZ, ABDAT, ABSFZ, POSEX, KDMAT, KBVER, KEVER, VKGRU, VKAUS, GRKOR, FMENG, UEBTK, UEBTO, UNTTO, FAKSP, ATPKZ, RKFKF, SPART, GSBER, NETWR, WAERK, ANTLF, KZTLF, CHSPL, KWMENG, LSMENG, KBMENG, KLMENG, VRKME, UMVKZ, UMVKN, BRGEW, NTGEW, GEWEI, VOLUM, VOLEH, VBELV, POSNV, VGBEL, VGPOS, VOREF, UPFLU, ERLRE, LPRIO, WERKS, LGORT, VSTEL, ROUTE, STKEY, STDAT, STLNR, STPOS, AWAHR, ERDAT, ERNAM, ERZET, TAXM1, TAXM2, TAXM3, TAXM4, TAXM5, TAXM6, TAXM7, TAXM8, TAXM9, VBEAF, VBEAV, VGREF, NETPR, KPEIN, KMEIN, SHKZG, SKTOF, MTVFP, SUMBD, KONDM, KTGRM, BONUS, PROVG, EANNR, PRSOK, BWTAR, BWTEX, XCHPF, XCHAR, LFMNG, STAFO, WAVWR, KZWI1, KZWI2, KZWI3, KZWI4, KZWI5, KZWI6, STCUR, AEDAT, EAN11, FIXMG, PRCTR, MVGR1, MVGR2, MVGR3, MVGR4, MVGR5, KMPMG, SUGRD, SOBKZ, VPZUO, PAOBJNR, PS_PSP_PNR, AUFNR, VPMAT, VPWRK, PRBME, UMREF, KNTTP, KZVBR, SERNR, OBJNR, ABGRS, BEDAE, CMPRE, CMTFG, CMPNT, CMKUA, CUOBJ, CUOBJ_CH, CEPOK, KOUPD, SERAIL, ANZSN, NACHL, MAGRV, MPROK, VGTYP, PROSA, UEPVW, KALNR, KLVAR, SPOSN, KOWRR, STADAT, EXART, PREFE, KNUMH, CLINT, CHMVS, STLTY, STLKN, STPOZ, STMAN, ZSCHL_K, KALSM_K, KALVAR, KOSCH, UPMAT, UKONM, MFRGR, PLAVO, KANNR, CMPRE_FLT, ABFOR, ABGES, J_1BCFOP, J_1BTAXLW1, J_1BTAXLW2, J_1BTXSDC, WKTNR, WKTPS, SKOPF, KZBWS, WGRU1, WGRU2, KNUMA_PI, KNUMA_AG, KZFME, LSTANR, TECHS, MWSBP, BERID, PCTRF, FERC_IND, ARSNUM, ARSPOS, WTYSC_CLMITEM FROM VSVBAP_CN
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2VSNMRNumber or description of a versionnvarchar120CHAR(N' ')NoVSNMR Allow NULL? 
3VBELNSales Documentnvarchar100CHAR(N' ')No*VBELN_VA Allow NULL? 
4POSNRSales Document Itemnvarchar60NUMC(N'000000')No*POSNR_VA Allow NULL? 
5MATNRMaterial Numbernvarchar180CHAR(N' ')No*MATNR Allow NULL? 
6MATWAMaterial enterednvarchar180CHAR(N' ')No*MATWA Allow NULL? 
7PMATNPricing Reference Materialnvarchar180CHAR(N' ')No*PMATN Allow NULL? 
8CHARGBatch Numbernvarchar100CHAR(N' ')No*CHARG_D Allow NULL? 
9MATKLMaterial Groupnvarchar90CHAR(N' ')No*MATKL Allow NULL? 
10ARKTXShort text for sales order itemnvarchar400CHAR(N' ')NoARKTX Allow NULL? 
11PSTYVSales document item categorynvarchar40CHAR(N' ')No*PSTYV Allow NULL? 
12POSARItem typechar10CHAR(N' ')NoPOSAR Allow NULL? 
13LFRELItem is relevant for deliverychar10CHAR(N' ')NoLFREL_AP Allow NULL? 
14FKRELRelevant for Billingchar10CHAR(N' ')NoFKREL Allow NULL? 
15UEPOSHigher-level item in bill of material structuresnvarchar60NUMC(N'000000')No*UEPOS Allow NULL? 
16GRPOSItem for which this item is an alternativenvarchar60NUMC(N'000000')NoGRPOS Allow NULL? 
17ABGRUReason for rejection of quotations and sales ordersnvarchar20CHAR(N' ')No*ABGRU_VA Allow NULL? 
18PRODHProduct hierarchynvarchar180CHAR(N' ')No*PRODH_D Allow NULL? 
19ZWERTTarget Value for Outline Agreement in Document Currencydecimal132CURR((0))NoDZWERT
20ZMENGTarget quantity in sales unitsdecimal133QUAN((0))NoDZMENG
21ZIEMETarget quantity UoMnvarchar30UNIT(N' ')No*DZIEME Allow NULL? 
22UMZIZFactor for converting sales units to base units (target qty)decimal50DEC((0))NoUMZIZ
23UMZINFactor for converting sales units to base units (target qty)decimal50DEC((0))NoUMZIN
24MEINSBase Unit of Measurenvarchar30UNIT(N' ')No*MEINS Allow NULL? 
25SMENGScale quantity in base unit of measuredecimal133QUAN((0))NoSMENG
26ABLFZRounding quantity for deliverydecimal133QUAN((0))NoABLFZ
27ABDATReconciliation Date for Agreed Cumulative Quantitynvarchar80DATS(N'00000000')NoABDAT Allow NULL? 
28ABSFZAllowed deviation in quantity (absolute)decimal133QUAN((0))NoABSFZ
29POSEXItem Number of the Underlying Purchase Ordernvarchar60CHAR(N' ')NoPOSEX Allow NULL? 
30KDMATMaterial Number Used by Customernvarchar350CHAR(N' ')NoMATNR_KU Allow NULL? 
31KBVERAllowed deviation in quantity (in percent)decimal30DEC((0))NoKBVER
32KEVERDays by which the quantity can be shifteddecimal30DEC((0))NoKEVER
33VKGRURepair Processing: Classification of Itemsnvarchar30CHAR(N' ')No*VKGRU Allow NULL? 
34VKAUSUnused - Reserve Length 3nvarchar30CHAR(N' ')NoVKAUS Allow NULL? 
35GRKORDelivery group (items are delivered together)nvarchar30NUMC(N'000')NoGRKOR Allow NULL? 
36FMENGQuantity is Fixedchar10CHAR(N' ')NoFMENG Allow NULL? 
37UEBTKUnlimited overdelivery allowedchar10CHAR(N' ')NoUEBTK_V Allow NULL? 
38UEBTOOverdelivery Tolerance Limitdecimal31DEC((0))NoUEBTO
39UNTTOUnderdelivery Tolerance Limitdecimal31DEC((0))NoUNTTO
40FAKSPBilling block for itemnvarchar20CHAR(N' ')No*FAKSP_AP Allow NULL? 
41ATPKZReplacement partchar10CHAR(N' ')NoATPKZ Allow NULL? 
42RKFKFMethod of billing for CO/PPC orderschar10CHAR(N' ')NoRKFKF Allow NULL? 
43SPARTDivisionnvarchar20CHAR(N' ')No*SPART Allow NULL? 
44GSBERBusiness Areanvarchar40CHAR(N' ')No*GSBER Allow NULL? 
45NETWRNet value of the order item in document currencydecimal152CURR((0))NoNETWR_AP
46WAERKSD Document Currencynvarchar50CUKY(N' ')No*WAERK Allow NULL? 
47ANTLFMaximum Number of Partial Deliveries Allowed Per Itemdecimal10DEC((0))NoANTLF
48KZTLFPartial delivery at item levelchar10CHAR(N' ')NoKZTLF Allow NULL? 
49CHSPLBatch split allowedchar10CHAR(N' ')NoCHSPL Allow NULL? 
50KWMENGCumulative Order Quantity in Sales Unitsdecimal153QUAN((0))NoKWMENG
51LSMENGCumulative required delivery qty (all dlv-relev.sched.lines)decimal153QUAN((0))NoLSMENG
52KBMENGCumulative confirmed quantity in sales unitdecimal153QUAN((0))NoKBMENG
53KLMENGCumulative confirmed quantity in base unitdecimal153QUAN((0))NoKLMENG
54VRKMESales unitnvarchar30UNIT(N' ')No*VRKME Allow NULL? 
55UMVKZNumerator (factor) for conversion of sales quantity into SKUdecimal50DEC((0))NoUMVKZ
56UMVKNDenominator (Divisor) for Conversion of Sales Qty into SKUdecimal50DEC((0))NoUMVKN
57BRGEWGross Weight of the Itemdecimal153QUAN((0))NoBRGEW_AP
58NTGEWNet Weight of the Itemdecimal153QUAN((0))NoNTGEW_AP
59GEWEIWeight Unitnvarchar30UNIT(N' ')No*GEWEI Allow NULL? 
60VOLUMVolume of the itemdecimal153QUAN((0))NoVOLUM_AP
61VOLEHVolume unitnvarchar30UNIT(N' ')No*VOLEH Allow NULL? 
62VBELVOriginating documentnvarchar100CHAR(N' ')No*VBELV Allow NULL? 
63POSNVOriginating itemnvarchar60NUMC(N'000000')No*POSNV Allow NULL? 
64VGBELDocument number of the reference documentnvarchar100CHAR(N' ')No*VGBEL Allow NULL? 
65VGPOSItem number of the reference itemnvarchar60NUMC(N'000000')No*VGPOS Allow NULL? 
66VOREFComplete reference indicatorchar10CHAR(N' ')NoVOREF Allow NULL? 
67UPFLUUpdate indicator for flow tablechar10CHAR(N' ')NoUPFLU Allow NULL? 
68ERLRECompletion rule for quotation / contractchar10CHAR(N' ')NoERLRE Allow NULL? 
69LPRIODelivery Prioritynvarchar20NUMC(N'00')No*LPRIO Allow NULL? 
70WERKSPlantnvarchar40CHAR(N' ')No*WERKS_D Allow NULL? 
71LGORTStorage Locationnvarchar40CHAR(N' ')No*LGORT_D Allow NULL? 
72VSTELShipping Point/Receiving Pointnvarchar40CHAR(N' ')No*VSTEL Allow NULL? 
73ROUTERoutenvarchar60CHAR(N' ')No*ROUTE Allow NULL? 
74STKEYOrigin of the bill of materialchar10CHAR(N' ')NoSTKEY Allow NULL? 
75STDATKey date of the bill of materialnvarchar80DATS(N'00000000')NoSTDAT Allow NULL? 
76STLNRBill of materialnvarchar80CHAR(N' ')NoSTNUM Allow NULL? 
77STPOSBill of material item number VBAP not useddecimal50DEC((0))NoSTPOS_VBAP
78AWAHROrder probability of the itemnvarchar30NUMC(N'000')NoAWAHR Allow NULL? 
79ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')NoERDAT Allow NULL? 
80ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')NoERNAM Allow NULL? 
81ERZETEntry timenvarchar60TIMS(N'000000')NoERZET Allow NULL? 
82TAXM1Tax classification materialchar10CHAR(N' ')No*TAXMT Allow NULL? 
83TAXM2Tax classification materialchar10CHAR(N' ')No*TAXMT Allow NULL? 
84TAXM3Tax classification materialchar10CHAR(N' ')No*TAXMT Allow NULL? 
85TAXM4Tax classification materialchar10CHAR(N' ')No*TAXMT Allow NULL? 
86TAXM5Tax classification materialchar10CHAR(N' ')No*TAXMT Allow NULL? 
87TAXM6Tax classification materialchar10CHAR(N' ')No*TAXMT Allow NULL? 
88TAXM7Tax classification materialchar10CHAR(N' ')No*TAXMT Allow NULL? 
89TAXM8Tax classification materialchar10CHAR(N' ')No*TAXMT Allow NULL? 
90TAXM9Tax classification materialchar10CHAR(N' ')No*TAXMT Allow NULL? 
91VBEAFFixed shipping processing time in days (= setup time)decimal52DEC((0))NoVBEAF
92VBEAVVariable shipping processing time in daysdecimal52DEC((0))NoVBEAV
93VGREFPreceding document has resulted from referencechar10CHAR(N' ')NoVGREF Allow NULL? 
94NETPRNet pricedecimal112CURR((0))NoNETPR
95KPEINCondition pricing unitdecimal50DEC((0))NoKPEIN
96KMEINCondition unitnvarchar30UNIT(N' ')No*KMEIN Allow NULL? 
97SHKZGReturns Itemchar10CHAR(N' ')NoSHKZG_VA Allow NULL? 
98SKTOFCash discount indicatorchar10CHAR(N' ')NoSKTOF Allow NULL? 
99MTVFPChecking Group for Availability Checknvarchar20CHAR(N' ')No*MTVFP Allow NULL? 
100SUMBDSumming up of requirementschar10CHAR(N' ')NoSUMBD Allow NULL? 
101KONDMMaterial Pricing Groupnvarchar20CHAR(N' ')No*KONDM Allow NULL? 
102KTGRMAccount assignment group for this materialnvarchar20CHAR(N' ')No*KTGRM Allow NULL? 
103BONUSVolume rebate groupnvarchar20CHAR(N' ')No*BONUS Allow NULL? 
104PROVGCommission groupnvarchar20CHAR(N' ')No*PROVG Allow NULL? 
105EANNREuropean Article Number (EAN) - obsolete!!!!!nvarchar130CHAR(N' ')NoEANNR Allow NULL? 
106PRSOKPricing is OKchar10CHAR(N' ')NoPRSOK Allow NULL? 
107BWTARValuation Typenvarchar100CHAR(N' ')No*BWTAR_D Allow NULL? 
108BWTEXIndicator: Separate valuationchar10CHAR(N' ')NoBWTEX Allow NULL? 
109XCHPFBatch management requirement indicatorchar10CHAR(N' ')NoXCHPF Allow NULL? 
110XCHARBatch management indicator (internal)char10CHAR(N' ')NoXCHAR Allow NULL? 
111LFMNGMinimum delivery quantity in delivery note processingdecimal133QUAN((0))NoMINLF
112STAFOUpdate group for statistics updatenvarchar60CHAR(N' ')No*STAFO Allow NULL? 
113WAVWRCost in document currencydecimal132CURR((0))NoWAVWR
114KZWI1Subtotal 1 from pricing procedure for conditiondecimal132CURR((0))NoKZWI1
115KZWI2Subtotal 2 from pricing procedure for conditiondecimal132CURR((0))NoKZWI2
116KZWI3Subtotal 3 from pricing procedure for conditiondecimal132CURR((0))NoKZWI3
117KZWI4Subtotal 4 from pricing procedure for conditiondecimal132CURR((0))NoKZWI4
118KZWI5Subtotal 5 from pricing procedure for conditiondecimal132CURR((0))NoKZWI5
119KZWI6Subtotal 6 from pricing procedure for conditiondecimal132CURR((0))NoKZWI6
120STCURExchange rate for statistics (Exch.rate at time of creation)decimal95DEC((0))NoSTCUR_AP
121AEDATChanged Onnvarchar80DATS(N'00000000')NoAEDAT Allow NULL? 
122EAN11International Article Number (EAN/UPC)nvarchar180CHAR(N' ')NoEAN11 Allow NULL? 
123FIXMGDelivery date and quantity fixedchar10CHAR(N' ')NoFIXMG Allow NULL? 
124PRCTRProfit Centernvarchar100CHAR(N' ')No*PRCTR Allow NULL? 
125MVGR1Material group 1nvarchar30CHAR(N' ')No*MVGR1 Allow NULL? 
126MVGR2Material group 2nvarchar30CHAR(N' ')No*MVGR2 Allow NULL? 
127MVGR3Material group 3nvarchar30CHAR(N' ')No*MVGR3 Allow NULL? 
128MVGR4Material group 4nvarchar30CHAR(N' ')No*MVGR4 Allow NULL? 
129MVGR5Material group 5nvarchar30CHAR(N' ')No*MVGR5 Allow NULL? 
130KMPMGComponent quantitydecimal133QUAN((0))NoKMPMG
131SUGRDReason for material substitutionnvarchar40CHAR(N' ')No*SUGRD Allow NULL? 
132SOBKZSpecial Stock Indicatorchar10CHAR(N' ')No*SOBKZ Allow NULL? 
133VPZUOAllocation Indicatorchar10CHAR(N' ')NoVPZUO Allow NULL? 
134PAOBJNRProfitability Segment Number (CO-PA)nvarchar100NUMC(N'0000000000')NoRKEOBJNR Allow NULL? 
135PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')No*PS_PSP_PNR Allow NULL? 
136AUFNROrder Numbernvarchar120CHAR(N' ')No*AUFNR Allow NULL? 
137VPMATPlanning materialnvarchar180CHAR(N' ')No*VPMAT Allow NULL? 
138VPWRKPlanning plantnvarchar40CHAR(N' ')No*VPWRK Allow NULL? 
139PRBMEBase unit of measure for product groupnvarchar30UNIT(N' ')No*PRBME Allow NULL? 
140UMREFConversion factor: quantitiesfloat1516FLTP((0))NoUMREFF
141KNTTPAccount Assignment Categorychar10CHAR(N' ')No*KNTTP Allow NULL? 
142KZVBRConsumption Postingchar10CHAR(N' ')NoKZVBR Allow NULL? 
143SERNRBOM explosion numbernvarchar80CHAR(N' ')No*SERNR Allow NULL? 
144OBJNRObject number at item levelnvarchar220CHAR(N' ')No*OBJPO Allow NULL? 
145ABGRSResults Analysis Keynvarchar60CHAR(N' ')No*ABGR_SCHL Allow NULL? 
146BEDAERequirements typenvarchar40CHAR(N' ')No*BEDAE Allow NULL? 
147CMPREItem credit pricedecimal112CURR((0))NoCMPRE
148CMTFGID for partial release of order item, credit blockchar10CHAR(N' ')NoCMTFG Allow NULL? 
149CMPNTID: Item with active credit function / relevant for creditchar10CHAR(N' ')NoCMPNT Allow NULL? 
150CMKUACredit data exchange rate for requested delivery datedecimal95DEC((0))NoCMKUA
151CUOBJConfigurationnvarchar180NUMC(N'000000000000000000')NoCUOBJ_VA Allow NULL? 
152CUOBJ_CHInternal object number of the batch classificationnvarchar180NUMC(N'000000000000000000')NoCUOBJ_CH Allow NULL? 
153CEPOKStatus expected pricechar10CHAR(N' ')NoCEPOK Allow NULL? 
154KOUPDCondition updatechar10CHAR(N' ')NoKOUPD Allow NULL? 
155SERAILSerial Number Profilenvarchar40CHAR(N' ')No*SERAIL Allow NULL? 
156ANZSNNumber of serial numbersint100INT4((0))NoANZSN Allow NULL? 
157NACHLCustomer has not posted goods receiptchar10CHAR(N' ')NoNACHL Allow NULL? 
158MAGRVMaterial Group: Packaging Materialsnvarchar40CHAR(N' ')No*MAGRV Allow NULL? 
159MPROKStatus manual price changechar10CHAR(N' ')NoMPROK Allow NULL? 
160VGTYPDocument category of preceding SD documentchar10CHAR(N' ')NoVBTYP_V Allow NULL? 
161PROSAID for material determinationchar10CHAR(N' ')NoPROSA Allow NULL? 
162UEPVWID for higher-level item usagechar10CHAR(N' ')NoUEPVW Allow NULL? 
163KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120NUMC(N'000000000000')No*CK_KALNR Allow NULL? 
164KLVARCosting Variantnvarchar40CHAR(N' ')No*CK_KLVAR Allow NULL? 
165SPOSNBOM Item Numbernvarchar40CHAR(N' ')NoSPOSN Allow NULL? 
166KOWRRStatistical valueschar10CHAR(N' ')NoKOWRR Allow NULL? 
167STADATStatistics datenvarchar80DATS(N'00000000')NoSTADAT Allow NULL? 
168EXARTBusiness Transaction Type for Foreign Tradenvarchar20CHAR(N' ')No*EXART Allow NULL? 
169PREFEPreference indicator in export/importchar10CHAR(N' ')NoPREFE Allow NULL? 
170KNUMHNumber of condition record from batch determinationnvarchar100CHAR(N' ')NoKNUMH_CH Allow NULL? 
171CLINTInternal Class Numbernvarchar100NUMC(N'0000000000')No*CLINT Allow NULL? 
172CHMVSBatches: Exit to quantity proposalnvarchar30NUMC(N'000')NoCHMVS Allow NULL? 
173STLTYBOM categorychar10CHAR(N' ')NoSTLTY Allow NULL? 
174STLKNBOM item node numbernvarchar80NUMC(N'00000000')NoSTLKN Allow NULL? 
175STPOZInternal counternvarchar80NUMC(N'00000000')NoCIM_COUNT Allow NULL? 
176STMANIndicator: manual change to sales order BOMchar10CHAR(N' ')NoCS_KNDVB Allow NULL? 
177ZSCHL_KOverhead keynvarchar60CHAR(N' ')NoAUFZSCHL Allow NULL? 
178KALSM_KCosting Sheetnvarchar60CHAR(N' ')No*AUFKALSM Allow NULL? 
179KALVARCosting Variantnvarchar40CHAR(N' ')No*CK_KLVAR Allow NULL? 
180KOSCHProduct allocation determination procedurenvarchar180CHAR(N' ')No*KOSCH Allow NULL? 
181UPMATPricing reference material of main itemnvarchar180CHAR(N' ')No*UPMAT Allow NULL? 
182UKONMMaterial pricing group of main itemnvarchar20CHAR(N' ')No*UKONM Allow NULL? 
183MFRGRMaterial freight groupnvarchar80CHAR(N' ')Yes*MFRGR Allow NULL? 
184PLAVOPlanning delivery schedule instructionnvarchar40CHAR(N' ')Yes*PLAVO Allow NULL? 
185KANNRKANBAN/sequence numbernvarchar350CHAR(N' ')YesKANNR Allow NULL? 
186CMPRE_FLTItem credit pricefloat1516FLTP((0))YesCMPRE_FLT
187ABFORForm of payment guaranteenvarchar20CHAR(N' ')YesABSFORM_CM Allow NULL? 
188ABGESGuaranteed (factor between 0 and 1)float1516FLTP((0))YesABGES_CM
189J_1BCFOPCFOP Code and Extensionnvarchar100CHAR(N' ')Yes*J_1BCFOP Allow NULL? 
190J_1BTAXLW1Tax law: ICMSnvarchar30CHAR(N' ')Yes*J_1BTAXLW1 Allow NULL? 
191J_1BTAXLW2Tax law: IPInvarchar30CHAR(N' ')Yes*J_1BTAXLW2 Allow NULL? 
192J_1BTXSDCSD tax codenvarchar20CHAR(N' ')Yes*J_1BTXSDC_ Allow NULL? 
193WKTNRValue contract no.nvarchar100CHAR(N' ')Yes*WKTNR Allow NULL? 
194WKTPSValue contract itemnvarchar60NUMC(N'000000')Yes*WKTPS Allow NULL? 
195SKOPFAssortment modulenvarchar180CHAR(N' ')Yes*W_SORTK Allow NULL? 
196KZBWSValuation of Special Stockchar10CHAR(N' ')YesKZBWS Allow NULL? 
197WGRU1Material group hierarchy 1nvarchar180CHAR(N' ')YesMCW_WGRU1 Allow NULL? 
198WGRU2Material group hierarchy 2nvarchar180CHAR(N' ')YesMCW_WGRU2 Allow NULL? 
199KNUMA_PIPromotionnvarchar100CHAR(N' ')Yes*KNUMA_PI Allow NULL? 
200KNUMA_AGSales dealnvarchar100CHAR(N' ')Yes*KNUMA_AG Allow NULL? 
201KZFMEID: Leading unit of measure for completing a transactionchar10CHAR(N' ')YesKZFME Allow NULL? 
202LSTANRFree goods delivery controlchar10CHAR(N' ')YesLSTANR Allow NULL? 
203TECHSParameter Variant/Standard Variantnvarchar120CHAR(N' ')YesTECHS Allow NULL? 
204MWSBPTax amount in document currencydecimal132CURR((0))YesMWSBP
205BERIDMRP Areanvarchar100CHAR(N' ')Yes*BERID Allow NULL? 
206PCTRFProfit Center for Billingnvarchar100CHAR(N' ')Yes*PCTRF Allow NULL? 
207FERC_INDRegulatory indicatornvarchar40CHAR(N' ')YesFERC_C7FE_IND Allow NULL? 
208ARSNUMNumber of reservation/dependent requirementsnvarchar100NUMC(N'0000000000')Yes*WTYSC_RSNUM Allow NULL? 
209ARSPOSItem number of reservation/dependent requirementsnvarchar40NUMC(N'0000')YesWTYSC_RSPOS Allow NULL? 
210WTYSC_CLMITEMClaim item numbernvarchar160CHAR(N' ')YesWTYSC_CLMITEM Allow NULL? 
NamePrimaryUniqueTypeColumns
VSVBAP_CN~0YesYesCLUSTEREDMANDT, VSNMR, VBELN, POSNR
VSVBAP_CN~ANoNoNONCLUSTEREDMANDT, PS_PSP_PNR, VBELN, POSNR, VSNMR
VSVBAP_CN~BNoNoNONCLUSTEREDMANDT, VBELN, POSNR, PS_PSP_PNR, VSNMR

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