VBRP - Billing Document: Item Data

Billing Document: Item Data information is stored in SAP table VBRP.
It is part of development package VF in software component SD-BIL. This development package consists of objects that can be grouped under "Application development R/3 invoice".

Fields for table VBRP

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
VBELNBilling DocumentXVBELN_VFCHAR20VBRK
POSNRBilling ItemXPOSNR_VFNUMC12
UEPOSHigher-Level Item in Bill of Material StructuresUEPOSNUMC12
FKIMGActual billed quantityFKIMGQUAN7
VRKMESales unitVRKMEUNIT6T006
UMVKZNumerator (factor) for conversion of sales quantity into SKUUMVKZDEC3
UMVKNDenominator (divisor) for conversion of sales Qty into SKUUMVKNDEC3
MEINSBase Unit of MeasureMEINSUNIT6T006
SMENGScale Quantity in base unit of measureSMENGQUAN7
FKLMGBilling quantity in stock keeping unitFKLMGQUAN7
LMENGRequired quantity for mat.management in stockkeeping unitsLMENGQUAN7
NTGEWNet weightNTGEW_15QUAN8
BRGEWGross weightBRGEW_15QUAN8
GEWEIWeight UnitGEWEIUNIT6T006
VOLUMVolumeVOLUM_15QUAN8
VOLEHVolume unitVOLEHUNIT6T006
GSBERBusiness AreaGSBERCHAR8TGSB
PRSDTDate for Pricing and Exchange RatePRSDTDATS16
FBUDADate on which services are renderedFBUDADATS16
KURSKExchange Rate for Price DeterminationKURSKDEC5
NETWRNet Value of Billing item in Document CurrencyNETWR_FPCURR8
VBELVOriginating DocumentVBELVCHAR20
POSNVOriginating ItemPOSNVNUMC12
VGBELDocument number of the reference documentVGBELCHAR20
VGPOSItem number of the reference itemVGPOSNUMC12
VGTYPDocument Category of Preceding SD DocumentVBTYPL_VCHAR8
AUBELSales DocumentVBELN_VACHAR20VBAK
AUPOSSales Document ItemPOSNR_VANUMC12VBAP
AUREFSales document was created from referenceAUREFCHAR2
MATNRMaterial NumberMATNRCHAR80MARA
ARKTXShort text for sales order itemARKTXCHAR80
PMATNPricing Reference MaterialPMATNCHAR80MARA
CHARGBatch NumberCHARG_DCHAR20MCHA
MATKLMaterial GroupMATKLCHAR18T023
PSTYVSales document item categoryPSTYVCHAR8
POSARItem TypePOSARCHAR2
PRODHProduct hierarchyPRODH_DCHAR36T179
VSTELShipping Point / Receiving PointVSTELCHAR8TVST
ATPKZReplacement partATPKZCHAR2
SPARTDivisionSPARTCHAR4TSPA
POSPAItem Number in the Partner SegmentPOSPANUMC12VBRP
WERKSPlantWERKS_DCHAR8T001W
ALANDDeparture Country/Region (from which the goods are sent)ALANDCHAR6T005
WKREGRegion in which plant is locatedWKREGCHAR6T005S
WKCOUCounty in which plant is locatedWKCOUCHAR6
WKCTYCity in which plant is locatedWKCTYCHAR8
TAXM1Tax classification materialTAXM1CHAR2
TAXM2Tax Classification 2 for MaterialTAXM2CHAR2
TAXM3Tax Classification 3 for MaterialTAXM3CHAR2
TAXM4Tax Classification 4 for MaterialTAXM4CHAR2
TAXM5Tax Classification 5 for MaterialTAXM5CHAR2
TAXM6Tax Classification 6 for MaterialTAXM6CHAR2
TAXM7Tax Classification 7 for MaterialTAXM7CHAR2
TAXM8Tax Classification 8 for MaterialTAXM8CHAR2
TAXM9Tax Classification 9 for MaterialTAXM9CHAR2
KOWRRStatistical ValuesKOWRRCHAR2
PRSFDCarry out pricingPRSFDCHAR2
SKTOFCash Discount IndicatorSKTOFCHAR2
SKFBPAmount eligible for cash discount in document currencySKFBPCURR7
KONDMMaterial Price GroupKONDMCHAR4T178
KTGRMAccount Assignment Group for MaterialKTGRMCHAR4TVKM
KOSTLCost CenterKOSTLCHAR20
BONUSVolume rebate groupBONUSCHAR4TVBO
PROVGCommission GroupPROVGCHAR4TVPR
EANNREuropean Article Number (EAN) - obsolete!!!!!EANNRCHAR26
VKGRPSales groupVKGRPCHAR6TVKGR
VKBURSales officeVKBURCHAR8TVBUR
SPARADivision for order headerSPART_AKCHAR4TSPA
SHKZGReturns itemSHKZG_VFCHAR2
ERNAMName of Person Responsible for Creating the ObjectERNAMCHAR24
ERDATDate on which the record was createdERDATDATS16
ERZETEntry timeERZETTIMS12
BWTARValuation TypeBWTAR_DCHAR20T149D
LGORTStorage locationLGORT_DCHAR8T001L
STAFOUpdate Group for statistics updateSTAFOCHAR12
WAVWRCost in Document CurrencyWAVWRCURR7
KZWI1Subtotal 1 from Pricing Procedure for Price ElementKZWI1CURR7
KZWI2Subtotal 2 from Pricing Procedure for Price ElementKZWI2CURR7
KZWI3Subtotal 3 from Pricing Procedure for Price ElementKZWI3CURR7
KZWI4Subtotal 4 from Pricing Procedure for Price ElementKZWI4CURR7
KZWI5Subtotal 5 from Pricing Procedure for Price ElementKZWI5CURR7
KZWI6Subtotal 6 from Pricing Procedure for Price ElementKZWI6CURR7
STCURExchange rate for statistics (Exch.rate at time of creation)STCUR_APDEC5
UVPRSIncomplete with respect to pricingUVPRSCHAR2
UVALLGenerally incompleteUVALLCHAR2
EAN11International Article Number (EAN/UPC)EAN11CHAR36
PRCTRProfit CenterPRCTRCHAR20
KVGR1Customer Group 1KVGR1CHAR6TVV1
KVGR2Customer Group 2KVGR2CHAR6TVV2
KVGR3Customer Group 3KVGR3CHAR6TVV3
KVGR4Customer Group 4KVGR4CHAR6TVV4
KVGR5Customer Group 5KVGR5CHAR6TVV5
MVGR1Material Group 1MVGR1CHAR6TVM1
MVGR2Material Group 2MVGR2CHAR6TVM2
MVGR3Material Group 3MVGR3CHAR6TVM3
MVGR4Material Group 4MVGR4CHAR6TVM4
MVGR5Material Group 5MVGR5CHAR6TVM5
MATWAMaterial EnteredMATWACHAR80MARA
BONBARebate Basis 1BONBACURR7
KOKRSControlling AreaKOKRSCHAR8TKA01
PAOBJNRProfitability Segment Number (CO-PA)RKEOBJNRNUMC20
PS_PSP_PNRWork Breakdown Structure Element (WBS Element)PS_PSP_PNRNUMC16
AUFNROrder NumberAUFNRCHAR24AUFK
TXJCDTax JurisdictionTXJCDCHAR30
CMPREItem credit priceCMPRECURR6
CMPNTID: Item with active credit function / relevant for creditCMPNTCHAR2
CUOBJConfigurationCUOBJ_VANUMC36
CUOBJ_CHInternal object number of the batch classificationCUOBJ_CHNUMC36
KOUPDCondition UpdateKOUPDCHAR2
UECHAHigher-Level Item of Batch Split ItemUECHANUMC12
XCHARBatch management indicator (internal)XCHARCHAR2
ABRVWUsage IndicatorABRVWCHAR6TVLV
SERNRBOM explosion numberSERNRCHAR16SNUM
BZIRK_AUFTSales district of sales orderBZIRK_AUFTCHAR12T171
KDGRP_AUFTCustomer group of sales orderKDGRP_AUFTCHAR4T151
KONDA_AUFTPrice group of sales orderKONDA_AUFTCHAR4T188
LLAND_AUFTDestination Country/Region of Sales OrderLLAND_AUFTCHAR6T005
MPROKStatus manual price changeMPROKCHAR2
PLTYP_AUFTPrice list type of sales orderPLTYP_AUFTCHAR4T189
REGIO_AUFTRegion of Sales OrderREGIO_AUFTCHAR6T005S
VKORG_AUFTSales organization of sales orderVKORG_AUFTCHAR8TVKO
VTWEG_AUFTDistribution channel of sales orderVTWEG_AUFTCHAR4TVTW
ABRBGStart of accounting settlement periodABRBGDATS16
PROSAID for material determinationPROSACHAR2
UEPVWID for higher-level item usageUEPVWCHAR2
AUTYPSD Document CategoryVBTYPLCHAR8
STADATStatistics dateSTADATDATS16
FPLNRBilling plan number / invoicing plan numberFPLNRCHAR20FPLA
FPLTRItem for billing plan/invoice plan/payment cardsFPLTRNUMC12
AKTNRPromotionWAKTIONCHAR20WAKH
KNUMA_PISales PromotionKNUMA_PICHAR20KONA
KNUMA_AGSales DealKNUMA_AGCHAR20KONA
MWSBPTax Amount in Document CurrencyMWSBPCURR7
AUGRU_AUFTOrder Reason (Reason for the Business Transaction)AUGRUCHAR6TVAU
FAREGRule in billing plan/invoice planFAREGCHAR2
UPMATPricing reference material of main itemUPMATCHAR80MARA
UKONMMaterial pricing group of main itemUKONMCHAR4T178
CMPRE_FLTItem Credit PriceCMPRE_FLTFLTP8
ABFORForm of payment guaranteeABSFORM_CMCHAR4T691K
ABGESGuaranteed (factor between 0 and 1)ABGES_CMFLTP8
J_1ARFZReason for Zero VATJ_1ARFZVATCHAR2J_1ARFZ
J_1AREGIORegion (State, Province, County)REGIOCHAR6T005S
J_1AGICDActivity Code for Gross Income TaxJ_1AGICD_DCHAR4J_1AGICD
J_1ADTYPDistribution Type for Employment TaxJ_1ADTYP_DCHAR4J_1ADTYP
J_1ATXRELTax relevant classificationJ_1ATXREL_CHAR20J_1ATXREL
J_1BCFOPCFOP Code and ExtensionJ_1BCFOPCHAR20J_1BAG
J_1BTAXLW1Tax law: ICMSJ_1BTAXLW1CHAR6J_1BATL1
J_1BTAXLW2Tax law: IPIJ_1BTAXLW2CHAR6J_1BATL2
J_1BTXSDCSD tax codeJ_1BTXSDC_CHAR4J_1BTXSDC
BRTWRGross Value of the Billing Item in Document CurrencyBRTWR_FPCURR8
WKTNRValue Contract No.WKTNRCHAR20VBAK
WKTPSValue Contract ItemWKTPSNUMC12VBAP
RPLNRPayment card plan number of sales documentRPLNR_AUCHAR20FPLA
KURSK_DATTranslation dateWWERT_DDATS16
WGRU1Material group hierarchy 1WGRU_HIE1CHAR36
WGRU2Material group hierarchy 2WGRU_HIE2CHAR36
KDKG1Customer condition group 1KDKG1CHAR4TVKGG
KDKG2Customer condition group 2KDKG2CHAR4TVKGG
KDKG3Customer condition group 3KDKG3CHAR4TVKGG
KDKG4Customer condition group 4KDKG4CHAR4TVKGG
KDKG5Customer condition group 5KDKG5CHAR4TVKGG
VKAUSUsage IndicatorABRVWCHAR6TVLV
J_1AINDXPInflation IndexJ_1AINDXPCHAR10J_1AINFT20
J_1AIDATEPIndexing base dateJ_1AIDATESDATS16
KZFMEID: Leading unit of measure for completing a transactionKZFMECHAR2
MWSKZTax on sales/purchases codeMWSKZCHAR4
VERTTContract TypeRANTYPCHAR2
VERTNContract NumberRANLCHAR26
SGTXTItem TextSGTXTCHAR100
DELCOAgreed Delivery TimeDELCOCHAR6
BEMOTAccounting IndicatorBEMOTCHAR4TBMOT
RRRELRevenue recognition categoryRR_RELTYPCHAR2
WMINRProduct catalog numberWMINRCHAR20WWMI
VGBEL_EXDocument number of the reference documentVGBELCHAR20
VGPOS_EXItem number of the reference itemVGPOSNUMC12
LOGSYSLogical systemLOGSYSCHAR20
VGTYP_EXCategory of an external transaction or elementVGTYP_EXCHAR6
J_1BTAXLW3ISS Tax LawJ_1BTAXLW3CHAR6J_1BATL3
J_1BTAXLW4COFINS Tax LawJ_1BTAXLW4CHAR6J_1BATL4A
J_1BTAXLW5PIS Tax LawJ_1BTAXLW5CHAR6J_1BATL5
MSR_IDProcess Identification NumberMSR_PROCESS_IDCHAR20
MSR_REFUND_CODEReturns Refund CodeMSR_RETURNS_REFUND_CODECHAR6MSR_C_RET_REFUND
MSR_RET_REASONReturn ReasonMSR_RETURNS_REASONCHAR6MSR_C_RET_REASON
NRAB_KNUMHNumber of the Condition RecordKNUMHCHAR20
NRAB_VALUECondition ValueKWERTCURR7
DISPUTE_CASEDispute CaseDISPUTE_CASERAW16
FUND_USAGE_ITEMFund Usage ItemFUND_USAGE_ITEMRAW16
FARR_RELTYPERevenue Accounting TypeFARR_RELTYPECHAR20
CLAIMS_TAXATIONClaims TaxationCLAIMS_TAXATIONCHAR2
KURRF_DAT_ORIGTranslation dateWWERT_DDATS16
SGT_RCATRequirement SegmentSGT_RCATCHAR80
SGT_SCATStock SegmentSGT_SCATCHAR80
PREFECustoms PreferencePREFECHAR2
AKKURExchange rate for letter-of-credit procg in foreign tradeAKKURDEC5
WAERKSD Document CurrencyWAERKCUKY10
DRAFTBoolean Variable (X = True, - = False, Space = Unknown)BOOLEANCHAR2
ACTIVEDOCUMENTSales and Distribution Document NumberVBELNCHAR20
GRWRTStatistical value for foreign tradeGRWRTCURR7
FKSAAOrder-Related Billing Status (Item)FKSAACHAR2
ABSTARejection Status for Billing Document Request ItemABSTA_BDRCHAR2
ABGRURejection Reason for Billing Document Request ItemABGRU_BDRCHAR4
MWSK1Tax on sales/purchases codeMWSKZCHAR4
TXDAT_FROMValid-From Date of the Tax RateFOT_TXDAT_FROMDATS16
PBD_IDPreliminary Billing DocumentPBD_IDCHAR20
PBD_ITEM_IDPreliminary Billing Document ItemPBD_ITEM_IDNUMC12
CATS_OVERTIME_CATEGORYOvertime CategoryCATS_OVERTIME_CATEGORYCHAR8
CONTR_DP_SETTLSettlement of Down Payment from Sales ContractCONTR_DP_SETTL_VFCHAR2
PRODH_UNIV_SALES_PARNT_NODIDNode IDNODIDCHAR80
TRANSIT_PLANTTransit PlantTRANSIT_PLANTCHAR8
VCM_CHAIN_CATEGORYValue Chain CategoryVCM_CHAIN_CATEGORYCHAR8
VCM_CHAIN_UUIDGUID in 'CHAR' Format in UppercaseGUID_32CHAR64
REASON_CODEReason for Return or Expected Delivery Quantity ChangeSD_ITEM_REASON_CODECHAR6
_DATAAGINGData Filter Value for Data AgingDATA_TEMPERATUREDATS16
SPE_HERKLCountry/Region of Origin of Material (Non-Preferential Ori.)HERKLCHAR6
SPE_HERKRRegion of Origin of Material (Non-Preferential Origin)HERKRCHAR6
ITM_COMCOCommodity Code/SAPSLL/COMCOCHAR60
VTKEYIdentification of a Provider ContractVTKEY_KKCHAR40
VTPOSContract: Item NumberVTPOS_KKNUMC12
SRCDOC_PROCESS_TYPEInternal: Special Source Document Type for BillingSRCDOC_PROCESS_TYPECHAR4
T2CCODE_CRCY_CONV_FACTORFactor for calculating Amount in company code currencyFINS_T2CCODE_CRCY_CONV_FACTORDEC16
T2CNTRY_CRCY_CONV_FACTORFactor for calculating Tax Amount in reporting currencyFINS_T2CNTRY_CRCY_CONV_FACTORDEC16
.INCLUDECI_PRS_CPILS_2CI_PRS_CPILS_20
.INCLUDEEXTSDBILLGDOCITEM_INCL_EEW_PS0
DUMMY_BILLGDOCITEM_INCL_EEW_PSDummy function in length 1DUMMYCHAR2
.INCLUDEVBRP_CRM0
SERVICE_DOC_TYPEService Document TypeFCO_SRVDOC_TYPECHAR8CRMC_PROC_TYPE
SERVICE_DOC_IDService Document IDFCO_SRVDOC_IDCHAR20
SERVICE_DOC_ITEM_IDService Document Item IDFCO_SRVDOC_ITEM_IDNUMC12
SOLUTION_ORDER_IDSolution OrderCRMS4_SOLO_OBJECT_IDCHAR20
SOLUTION_ORDER_ITEM_IDSolution Order ItemCRMS4_SOLO_NUMBER_INTNUMC12
.INCLUDE/CWM/S_VBRP0
/CWM/MENGEQuantity in Parallel Unit of Measure/CWM/MENGEQUAN7
/CWM/MEINSParallel Unit of Measure/CWM/MEINSUNIT6*
.INCLUDEVBRP_OLAPVBRP_ANALYTICS0
.INCLUDEVBRK_OLAPVBRK_ANA0
VBTYP_ANASD Document CategoryVBTYPLCHAR8
FKART_ANABilling TypeFKARTCHAR8*
VKORG_ANASales OrganizationVKORGCHAR8
VTWEG_ANADistribution ChannelVTWEGCHAR4
KONDA_ANACustomer Price GroupKONDACHAR4*
KDGRP_ANACustomer GroupKDGRPCHAR4*
LAND1_ANADestination Country/RegionLLANDCHAR6*
REGIO_ANARegion (State, Province, County)REGIOCHAR6*
CITYC_ANACity CodeCITYCCHAR8*
BZIRK_ANASales DistrictBZIRKCHAR12*
GBSTK_ANAOverall Processing Status (Header/All Items)GBSTKCHAR2
VF_STATUS_ANASD Billing StatusVF_STATUSCHAR2
KUNAG_ANASold-to PartyKUNAGCHAR20*
KUNRG_ANAPayerKUNRGCHAR20*
FKDAT_ANABilling DateFKDATDATS16
BUKRS_ANACompany CodeBUKRSCHAR8
COUNC_ANACounty CodeCOUNCCHAR6*
KNUMA_ANAAgreement (various conditions grouped together)KNUMACHAR20
FKTYP_ANABilling CategoryFKTYPCHAR2
KNUMV_ANANumber of the Document ConditionKNUMVCHAR20
SFAKN_ANANumber of canceled billing documentSFAKNCHAR20
.INCLUDEVBPA_OLAPVBPA_ANA0
KUNWE_ANAShip-to PartyKUNWECHAR20*
KUNRE_ANABill-to PartyKUNRECHAR20*
PERVE_ANASales EmployeeSALES_EMPLNUMC16
PERZM_ANAEmployee ResponsibleRESP_EMPLNUMC16
.INCLUDEVBRP_EXT_GLO0
GLO_LOG_REF1_ITCommodity Code for PolandGLO_LOG_REF1_ITCHAR50
.INCLUDETXS_ITEM_INFO_BR0
TXS_BUSINESS_TRANSACTIONTax Service Business TransactionTXS_BUSINESS_TRANSACTIONCHAR8
TXS_MATERIAL_USAGETax Service Material UsageTXS_MATERIAL_USAGECHAR2
TXS_USAGE_PURPOSETax Service Usage PurposeTXS_USAGE_PURPOSECHAR50
.INCLU--AP/ILE/TILVBRP0
APCGK_EXTENDIExtended key for annexing package/ILE/TAPCGK_EXTNUMC20
.INCLU--AP/OLC/VBRP0
AUFPLRouting number of operations in the orderCO_AUFPLNUMC20
APLZLInternal counterCIM_COUNTNUMC16
.INCLU--AP/SAPPCE/VBRP_FI_DPC0
DPCNRDown Payment Chain Number/SAPPCE/DPCNRCHAR20
DCPNRTransaction Number/SAPPCE/DPCPNRNUMC6
DPNRBSequence Number of Accounting Document in Transaction/SAPPCE/DPCPNRBNUMC6
.INCLU--APADBOSDP0
BOSFARBilling/Invoicing rule (w/o invoicing planBOSFARCHAR2
DP_BELNRDocument Number of an Accounting DocumentBELNR_DCHAR20
DP_BUKRSCompany CodeBUKRSCHAR8
DP_GJAHRFiscal YearGJAHRNUMC8
DP_BUZEINumber of Line Item Within Accounting DocumentBUZEINUMC6
.INCLU--APADBOSVBRP0
PACKNOPackage numberPACKNONUMC20ESLH
.INCLU--APAFM_PEROP_SD_VBRP0
PEROP_BEGPeriod of Performance Start DateFM_PEROP_SD_LOWDATS16
PEROP_ENDPeriod of Performance End DateFM_PEROP_SD_HIGHDATS16
.INCLU--APFMFG_VBRP_APP0
FMFGUS_KEYUnited States Federal Government FieldsFMFG_US_KEYCHAR44
.INCLU--APFSH_VBRP0
FSH_SEASON_YEARSeason YearFSH_SAISJCHAR8
FSH_SEASONSeasonFSH_SAISOCHAR20
FSH_COLLECTIONFashion CollectionFSH_COLLECTIONCHAR20*
FSH_THEMEFashion ThemeFSH_THEMECHAR20
.INCLU--APGMADDONVBRP0
FONDSFundBP_GEBERCHAR20*
FISTLFunds CenterFISTLCHAR32*
FKBERFunctional AreaFKBERCHAR32*
GRANT_NBRGrantGM_GRANT_NBRCHAR40
BUDGET_PDBudget PeriodFM_BUDGET_PERIODCHAR20*
.INCLU--APJ_3GVBRPA0
.INCLUDEJ_3GVBRPS0
J_3GBELNRIDocument NumberJ_3GBELNRICHAR20J_3GBELK
J_3GPMAUFEPM Order Number (Owner)J_3GPMAUFECHAR24AUFK
J_3GPMAUFVPM Order Number (Administrator)J_3GPMAUFVCHAR24AUFK
J_3GETYPASending Recipient TypeJ_3GETYPACHAR4*
J_3GETYPEReceiving Recipient TypeJ_3GETYPECHAR4*
J_3GORGUEBIndicator: Across All Organizational StructuresJ_3GORGUEBCHAR2
.INCLU--APPRS_VBRP_CPILS0
PRS_WORK_PERIODWork Period (Internal Representation)PRS_WORK_PERIODNUMC14
.INCLU--APRRICB_VBRP0
PPRCTRPartner Profit CenterPPRCTRCHAR20*
PARGBTrading partner's business areaPARGBCHAR8*
.INCLU--APVBRPOLC_APP0
AUFPL_OAARouting number of operations in the orderCO_AUFPLNUMC20
APLZL_OAAInternal counterCIM_COUNTNUMC16
.INCLU--APVBRP_CMPD0
CAMPAIGNGeneric project planning: GUID from external R/3 systemCGPL_GUID16_R3RAW16
.INCLU--APVBRP_COMPLAINT0
COMPREASAbbreviation for Complaints ReasonCMP_COMPREAS_COPYCHAR8
.INCLU--APWRF_VBRPDATA_APPEND0
WRF_CHARSTC1Characteristic Value 1WRF_CHARSTC1CHAR36
WRF_CHARSTC2Characteristic Value 2WRF_CHARSTC2CHAR36
WRF_CHARSTC3Characteristic Value 3WRF_CHARSTC3CHAR36
Privacy Policy