VBRP

Billing Document: Item Data | #itemdata | Component: Billing
Column Name Description
MANDT FK Client
VBELN FK Billing Document
POSNR Billing Item
Column Name Description
💲 SD Document Currency (VBRK.WAERK):
NETWR Net Value of Billing item in Document Currency
SKFBP Amount eligible for cash discount in document currency
WAVWR Cost in Document Currency
KZWI1 Subtotal 1 from Pricing Procedure for Price Element
KZWI2 Subtotal 2 from Pricing Procedure for Price Element
KZWI3 Subtotal 3 from Pricing Procedure for Price Element
KZWI4 Subtotal 4 from Pricing Procedure for Price Element
KZWI5 Subtotal 5 from Pricing Procedure for Price Element
KZWI6 Subtotal 6 from Pricing Procedure for Price Element
BONBA Rebate Basis 1
CMPRE Item credit price
MWSBP Tax Amount in Document Currency
BRTWR Gross Value of the Billing Item in Document Currency
NRAB_VALUE Condition Value
💲 Currency of statistical values for foreign trade (VBRK.GRWCU):
GRWRT Statistical value for foreign trade
Column Name Description
📏 Sales unit (VRKME):
FKIMG Actual billed quantity
📏 Base Unit of Measure (MEINS):
SMENG Scale Quantity in base unit of measure
FKLMG Billing quantity in stock keeping unit
LMENG Required quantity for mat.management in stockkeeping units
📏 Weight Unit (GEWEI):
NTGEW Net weight
BRGEW Gross weight
📏 Volume unit (VOLEH):
VOLUM Volume
📏 Parallel Unit of Measure (/CWM/MEINS):
/CWM/MENGE Quantity in Parallel Unit of Measure
Column Name Description
PRSDT Date for Pricing and Exchange Rate
FBUDA Date on which services are rendered
ERDAT Date on which the record was created
ERZET Entry time
ABRBG Start of accounting settlement period
STADAT Statistics date
KURSK_DAT Translation date
J_1AIDATEP Indexing base date
KURRF_DAT_ORIG Translation date
TXDAT_FROM Valid-From Date of the Tax Rate
_DATAAGING Data Filter Value for Data Aging
FKDAT_ANA Billing Date
ZABDATI Annexing base date
PEROP_BEG Period of Performance Start Date
PEROP_END Period of Performance End Date
Column Name Description
VGTYP Document Category of Preceding SD Document Show values
AUREF Sales document was created from reference Show values
POSAR Item Type Show values
ATPKZ Replacement part Show values
KOWRR Statistical Values Show values
PRSFD Carry out pricing Show values
SKTOF Cash Discount Indicator Show values
SHKZG Returns item Show values
UVPRS Incomplete with respect to pricing Show values
UVALL Generally incomplete Show values
CMPNT ID: Item with active credit function / relevant for credit Show values
KOUPD Condition Update Show values
XCHAR Batch management indicator (internal) Show values
MPROK Status manual price change Show values
PROSA ID for material determination Show values
UEPVW ID for higher-level item usage Show values
AUTYP SD Document Category Show values
FAREG Rule in billing plan/invoice plan Show values
KZFME ID: Leading unit of measure for completing a transaction Show values
VERTT Contract Type Show values
RRREL Revenue recognition category Show values
FARR_RELTYPE Revenue Accounting Type Show values
CLAIMS_TAXATION Claims Taxation Show values
PREFE Customs Preference Show values
DRAFT Boolean Variable (X = True, - = False, Space = Unknown) Show values
FKSAA Order-Related Billing Status (Item) Show values
ABSTA Rejection Status for Billing Document Request Item Show values
ABGRU Rejection Reason for Billing Document Request Item Show values
CONTR_DP_SETTL Settlement of Down Payment from Sales Contract Show values
SRCDOC_PROCESS_TYPE Internal: Special Source Document Type for Billing Show values
VBTYP_ANA SD Document Category Show values
GBSTK_ANA Overall Processing Status (Header/All Items) Show values
VF_STATUS_ANA SD Billing Status Show values
FKTYP_ANA Billing Category Show values
BOSFAR Billing/Invoicing rule (w/o invoicing plan Show values
Column Name Description Domain name
UEPOS Higher-Level Item in Bill of Material Structures POSNR
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMBSZ
UMVKN Denominator (divisor) for conversion of sales Qty into SKU UMBSN
KURSK Exchange Rate for Price Determination KURRF
VBELV Originating Document VBELN
POSNV Originating Item POSNR
VGBEL Document number of the reference document VBELN
VGPOS Item number of the reference item POSNR
ARKTX Short text for sales order item TEXT40
PSTYV Sales document item category PSTYV
WKCOU County in which plant is located CHAR3
WKCTY City in which plant is located CHAR4
TAXM1 Tax classification material TAXKM
TAXM2 Tax Classification 2 for Material TAXKM
TAXM3 Tax Classification 3 for Material TAXKM
TAXM4 Tax Classification 4 for Material TAXKM
TAXM5 Tax Classification 5 for Material TAXKM
TAXM6 Tax Classification 6 for Material TAXKM
TAXM7 Tax Classification 7 for Material TAXKM
TAXM8 Tax Classification 8 for Material TAXKM
TAXM9 Tax Classification 9 for Material TAXKM
KOSTL Cost Center KOSTL
EANNR European Article Number (EAN) - obsolete!!!!! CHAR13
ERNAM Name of Person Responsible for Creating the Object USNAM
STAFO Update Group for statistics update STAFO
STCUR Exchange rate for statistics (Exch.rate at time of creation) KURRF
EAN11 International Article Number (EAN/UPC) EAN11
PRCTR Profit Center PRCTR
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_POSNR
TXJCD Tax Jurisdiction TXJCD
CUOBJ Configuration CUOBJ
CUOBJ_CH Internal object number of the batch classification CUOBJ
UECHA Higher-Level Item of Batch Split Item POSNR
FPLTR Item for billing plan/invoice plan/payment cards FPLTR
CMPRE_FLT Item Credit Price FLTP
ABGES Guaranteed (factor between 0 and 1) FLTP
WGRU1 Material group hierarchy 1 KLASSE
WGRU2 Material group hierarchy 2 KLASSE
MWSKZ Tax on sales/purchases code MWSKZ
VERTN Contract Number RANL
SGTXT Item Text TEXT50
DELCO Agreed Delivery Time DELCO
VGBEL_EX Document number of the reference document VBELN
VGPOS_EX Item number of the reference item POSNR
LOGSYS Logical system LOGSYS
VGTYP_EX Category of an external transaction or element VORG_TYP
MSR_ID Process Identification Number MSR_PROCESS_ID
NRAB_KNUMH Number of the Condition Record KNUMH
DISPUTE_CASE Dispute Case SDBIL_RAW16
FUND_USAGE_ITEM Fund Usage Item SDBIL_RAW16
SGT_RCAT Requirement Segment SGT_SRCA
SGT_SCAT Stock Segment SGT_SRCA
AKKUR Exchange rate for letter-of-credit procg in foreign trade KURRF
ACTIVEDOCUMENT Sales and Distribution Document Number VBELN
MWSK1 Tax on sales/purchases code MWSKZ
PBD_ID Preliminary Billing Document VBELN
PBD_ITEM_ID Preliminary Billing Document Item POSNR
CATS_OVERTIME_CATEGORY Overtime Category CATS_OVERTIME_CATEGORY
PRODH_UNIV_SALES_PARNT_NODID Node ID UHOID
TRANSIT_PLANT Transit Plant WERKS
VCM_CHAIN_CATEGORY Value Chain Category VCM_CHAIN_CATEGORY
VCM_CHAIN_UUID GUID in 'CHAR' Format in Uppercase SYSUUID_C
REASON_CODE Reason for Return or Expected Delivery Quantity Change SD_ITEM_REASON_CODE
SPE_HERKL Country/Region of Origin of Material (Non-Preferential Ori.) LAND1
SPE_HERKR Region of Origin of Material (Non-Preferential Origin) REGIO
ITM_COMCO Commodity Code /SAPSLL/CCNGN
VTKEY Identification of a Provider Contract VTKEY_KK
VTPOS Contract: Item Number VTPOS_KK
T2CCODE_CRCY_CONV_FACTOR Factor for calculating Amount in company code currency FINS_T2ANY_CRCY_CONV_FACTOR
T2CNTRY_CRCY_CONV_FACTOR Factor for calculating Tax Amount in reporting currency FINS_T2ANY_CRCY_CONV_FACTOR
DUMMY_BILLGDOCITEM_INCL_EEW_PS Dummy function in length 1 DUMMY
SERVICE_DOC_ID Service Document ID CRM_OBJECT_ID
SERVICE_DOC_ITEM_ID Service Document Item ID FCO_SRVDOC_ITEM_ID
SOLUTION_ORDER_ID Solution Order CRM_OBJECT_ID
SOLUTION_ORDER_ITEM_ID Solution Order Item CRMS4_NUMBER_INT
FKART_ANA Billing Type FKART
VKORG_ANA Sales Organization VKORG
VTWEG_ANA Distribution Channel VTWEG
KONDA_ANA Customer Price Group KONDA
KDGRP_ANA Customer Group KDGRP
LAND1_ANA Destination Country/Region LAND1
REGIO_ANA Region (State, Province, County) REGIO
CITYC_ANA City Code CITYC
BZIRK_ANA Sales District BZIRK
KUNAG_ANA Sold-to Party KUNNR
KUNRG_ANA Payer KUNNR
BUKRS_ANA Company Code BUKRS
COUNC_ANA County Code COUNC
KNUMA_ANA Agreement (various conditions grouped together) KNUMA
KNUMV_ANA Number of the Document Condition KNUMV
SFAKN_ANA Number of canceled billing document VBELN
KUNWE_ANA Ship-to Party KUNNR
KUNRE_ANA Bill-to Party KUNNR
PERVE_ANA Sales Employee PERNR
PERZM_ANA Employee Responsible PERNR
GLO_LOG_REF1_IT Commodity Code for Poland GLO_LOG_REF1_IT
TXS_BUSINESS_TRANSACTION Tax Service Business Transaction TXS_BUSINESS_TRANSACTION
TXS_MATERIAL_USAGE Tax Service Material Usage
TXS_USAGE_PURPOSE Tax Service Usage Purpose TXS_USAGE_PURPOSE
APCGK_EXTENDI Extended key for annexing package NUMC10
AUFPL Routing number of operations in the order AUFPL
APLZL Internal counter CIM_COUNT
DPCNR Down Payment Chain Number /SAPPCE/DPCNR
DCPNR Transaction Number NUM03
DPNRB Sequence Number of Accounting Document in Transaction NUM03
DP_BELNR Document Number of an Accounting Document BELNR
DP_BUKRS Company Code BUKRS
DP_GJAHR Fiscal Year GJAHR
DP_BUZEI Number of Line Item Within Accounting Document BUZEI
FMFGUS_KEY United States Federal Government Fields SYSUUID_22
FSH_SEASON_YEAR Season Year FSH_CJAHR
FSH_SEASON Season RFM_SAISO
FSH_COLLECTION Fashion Collection FSH_COLLECTION
FSH_THEME Fashion Theme FSH_THEME
FONDS Fund BP_GEBER
FISTL Funds Center FISTL
FKBER Functional Area FKBER
GRANT_NBR Grant GM_GRANT_NBR
BUDGET_PD Budget Period FM_BUDGET_PERIOD
J_3GETYPA Sending Recipient Type J_3GETYP
J_3GETYPE Receiving Recipient Type J_3GETYP
J_3GORGUEB Indicator: Across All Organizational Structures CHAR1
PRS_WORK_PERIOD Work Period (Internal Representation) PRS_WORK_PERIOD
PPRCTR Partner Profit Center PRCTR
PARGB Trading partner's business area GSBER
AUFPL_OAA Routing number of operations in the order AUFPL
APLZL_OAA Internal counter CIM_COUNT
CAMPAIGN Generic project planning: GUID from external R/3 system SYSUUID
COMPREAS Abbreviation for Complaints Reason CMP_COMPREAS_COPY
WRF_CHARSTC1 Characteristic Value 1 WRF_CHARSTC
WRF_CHARSTC2 Characteristic Value 2 WRF_CHARSTC
WRF_CHARSTC3 Characteristic Value 3 WRF_CHARSTC
Master Data Relations Join Conditions
Form of payment guarantee
  • Form of payment guarantee
  • Client
  • VBRP.ABFOR == T691K.ABSFO
  • VBRP.MANDT == T691K.MANDT
Usage Indicator
  • Usage Indicator
  • Client
  • VBRP.ABRVW == TVLV.ABRVW
  • VBRP.MANDT == TVLV.MANDT
Promotion
  • Promotion
  • Client
  • VBRP.AKTNR == WAKH.AKTNR
  • VBRP.MANDT == WAKH.MANDT
Departure Country/Region (from which the goods are sent)
  • Departure Country/Region (from which the goods are sent)
  • Client
  • VBRP.ALAND == T005.LAND1
  • VBRP.MANDT == T005.MANDT
Order Number
  • Order Number
  • Client
  • VBRP.AUFNR == AUFK.AUFNR
  • VBRP.MANDT == AUFK.MANDT
Order Reason (Reason for the Business Transaction)
  • VBRP.MANDT == TVAU.MANDT
  • VBRP.AUGRU_AUFT == TVAU.AUGRU
Accounting Indicator
  • VBRP.MANDT == TBMOT.MANDT
  • VBRP.BEMOT == TBMOT.BEMOT
Volume rebate group
  • Volume rebate group
  • Client
  • VBRP.BONUS == TVBO.BONUS
  • VBRP.MANDT == TVBO.MANDT
Valuation Type
  • VBRP.MANDT == T149D.MANDT
  • VBRP.BWTAR == T149D.BWTAR
Sales district of sales order
  • VBRP.MANDT == T171.MANDT
  • VBRP.BZIRK_AUFT == T171.BZIRK
Batch Number
  • Material Number
  • Batch Number
  • Plant
  • VBRP.MANDT == MCHA.MANDT
  • VBRP.MATNR == MCHA.MATNR
  • VBRP.CHARG == MCHA.CHARG
  • VBRP.WERKS == MCHA.WERKS
Weight Unit
  • VBRP.MANDT == T006.MANDT
  • VBRP.GEWEI == T006.MSEHI
Business Area
  • VBRP.MANDT == TGSB.MANDT
  • VBRP.GSBER == TGSB.GSBER
Foreign key for VBR
  • ?
  • Distribution Type for Employment Tax
J_1AGICD
  • Activity Code for Gross Income Tax
  • Departure Country/Region (from which the goods are sent)
Inflation Index
Foreign key for J_1AREGIO
  • Departure Country/Region (from which the goods are sent)
  • Region (State, Province, County)
  • VBRP.MANDT == T005S.MANDT
  • VBRP.ALAND == T005S.LAND1
  • VBRP.J_1AREGIO == T005S.BLAND
Foreign key for J_1ARFZ
Foreign key for J_1ATXREL
Foreign key for J_1BCFOP
  • CFOP Code and Extension
  • Client
Foreign key for J_1BTAXLW1
Foreign key for J_1BTAXLW2
Foreign Key for Brazilian Tax ISS
  • ISS Tax Law
  • Client
Foreign Key for Brazilian Tax COFINS
Foreign Key for Brazilian Tax PIS
Foreign key for J_1BTXSDC
PM Order Number (Owner)
  • PM Order Number (Owner)
  • Client
  • VBRP.J_3GPMAUFE == AUFK.AUFNR
  • VBRP.MANDT == AUFK.MANDT
PM Order Number (Administrator)
  • PM Order Number (Administrator)
  • Client
  • VBRP.J_3GPMAUFV == AUFK.AUFNR
  • VBRP.MANDT == AUFK.MANDT
Customer group of sales order
  • Customer group of sales order
  • Client
  • VBRP.KDGRP_AUFT == T151.KDGRP
  • VBRP.MANDT == T151.MANDT
Customer condition group 1
  • Customer condition group 1
  • Client
  • VBRP.KDKG1 == TVKGG.KDKGR
  • VBRP.MANDT == TVKGG.MANDT
Customer condition group 2
  • Customer condition group 2
  • Client
  • VBRP.KDKG2 == TVKGG.KDKGR
  • VBRP.MANDT == TVKGG.MANDT
Customer condition group 3
  • Customer condition group 3
  • Client
  • VBRP.KDKG3 == TVKGG.KDKGR
  • VBRP.MANDT == TVKGG.MANDT
Customer condition group 4
  • Customer condition group 4
  • Client
  • VBRP.KDKG4 == TVKGG.KDKGR
  • VBRP.MANDT == TVKGG.MANDT
Customer condition group 5
  • Customer condition group 5
  • Client
  • VBRP.KDKG5 == TVKGG.KDKGR
  • VBRP.MANDT == TVKGG.MANDT
Sales Deal
  • Sales Deal
  • Client
  • VBRP.KNUMA_AG == KONA.KNUMA
  • VBRP.MANDT == KONA.MANDT
Sales Promotion
  • Sales Promotion
  • Client
  • VBRP.KNUMA_PI == KONA.KNUMA
  • VBRP.MANDT == KONA.MANDT
Controlling Area
  • VBRP.MANDT == TKA01.MANDT
  • VBRP.KOKRS == TKA01.KOKRS
Price group of sales order
  • Price group of sales order
  • Client
  • VBRP.KONDA_AUFT == T188.KONDA
  • VBRP.MANDT == T188.MANDT
Material Price Group
  • VBRP.MANDT == T178.MANDT
  • VBRP.KONDM == T178.KONDM
Account Assignment Group for Material
  • VBRP.MANDT == TVKM.MANDT
  • VBRP.KTGRM == TVKM.KTGRM
Customer Group 1
  • VBRP.MANDT == TVV1.MANDT
  • VBRP.KVGR1 == TVV1.KVGR1
Customer Group 2
  • VBRP.MANDT == TVV2.MANDT
  • VBRP.KVGR2 == TVV2.KVGR2
Customer Group 3
  • Customer Group 3
  • Client
  • VBRP.KVGR3 == TVV3.KVGR3
  • VBRP.MANDT == TVV3.MANDT
Customer Group 4
  • VBRP.MANDT == TVV4.MANDT
  • VBRP.KVGR4 == TVV4.KVGR4
Customer Group 5
  • Customer Group 5
  • Client
  • VBRP.KVGR5 == TVV5.KVGR5
  • VBRP.MANDT == TVV5.MANDT
Storage location
  • Storage location
  • Client
  • Plant
  • VBRP.LGORT == T001L.LGORT
  • VBRP.MANDT == T001L.MANDT
  • VBRP.WERKS == T001L.WERKS
Destination Country/Region of Sales Order
  • Destination Country/Region of Sales Order
  • Client
  • VBRP.LLAND_AUFT == T005.LAND1
  • VBRP.MANDT == T005.MANDT
Client VBRP.MANDT == T000.MANDT
Material Group
  • VBRP.MANDT == T023.MANDT
  • VBRP.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • VBRP.MATNR == MARA.MATNR
  • VBRP.MANDT == MARA.MANDT
Material Entered
  • Material Entered
  • Client
  • VBRP.MATWA == MARA.MATNR
  • VBRP.MANDT == MARA.MANDT
Base Unit of Measure
  • VBRP.MANDT == T006.MANDT
  • VBRP.MEINS == T006.MSEHI
Returns Refund Code
Return Reason
Material Group 1
  • Material Group 1
  • Client
  • VBRP.MVGR1 == TVM1.MVGR1
  • VBRP.MANDT == TVM1.MANDT
Material Group 2
  • Material Group 2
  • Client
  • VBRP.MVGR2 == TVM2.MVGR2
  • VBRP.MANDT == TVM2.MANDT
Material Group 3
  • VBRP.MANDT == TVM3.MANDT
  • VBRP.MVGR3 == TVM3.MVGR3
Material Group 4
  • VBRP.MANDT == TVM4.MANDT
  • VBRP.MVGR4 == TVM4.MVGR4
Material Group 5
  • VBRP.MANDT == TVM5.MANDT
  • VBRP.MVGR5 == TVM5.MVGR5
Package number
  • VBRP.MANDT == ESLH.MANDT
  • VBRP.PACKNO == ESLH.PACKNO
Price list type of sales order
  • VBRP.MANDT == T189.MANDT
  • VBRP.PLTYP_AUFT == T189.PLTYP
Pricing Reference Material
  • Pricing Reference Material
  • Client
  • VBRP.PMATN == MARA.MATNR
  • VBRP.MANDT == MARA.MANDT
Product hierarchy
  • Product hierarchy
  • Client
  • VBRP.PRODH == T179.PRODH
  • VBRP.MANDT == T179.MANDT
Commission Group
  • Commission Group
  • Client
  • VBRP.PROVG == TVPR.PROVG
  • VBRP.MANDT == TVPR.MANDT
Region of Sales Order
  • Destination Country/Region of Sales Order
  • Region of Sales Order
  • VBRP.MANDT == T005S.MANDT
  • VBRP.LLAND_AUFT == T005S.LAND1
  • VBRP.REGIO_AUFT == T005S.BLAND
BOM explosion number
  • BOM explosion number
  • Client
  • VBRP.SERNR == SNUM.SERNR
  • VBRP.MANDT == SNUM.MANDT
Service Document Type
Division for order header
  • VBRP.MANDT == TSPA.MANDT
  • VBRP.SPARA == TSPA.SPART
Division
  • VBRP.MANDT == TSPA.MANDT
  • VBRP.SPART == TSPA.SPART
Material pricing group of main item
  • VBRP.MANDT == T178.MANDT
  • VBRP.UKONM == T178.KONDM
Pricing reference material of main item
  • Pricing reference material of main item
  • Client
  • VBRP.UPMAT == MARA.MATNR
  • VBRP.MANDT == MARA.MANDT
Usage Indicator
  • Usage Indicator
  • Client
  • VBRP.VKAUS == TVLV.ABRVW
  • VBRP.MANDT == TVLV.MANDT
Sales office
  • Sales office
  • Client
  • VBRP.VKBUR == TVBUR.VKBUR
  • VBRP.MANDT == TVBUR.MANDT
Sales group
  • VBRP.MANDT == TVKGR.MANDT
  • VBRP.VKGRP == TVKGR.VKGRP
Sales organization of sales order
  • VBRP.MANDT == TVKO.MANDT
  • VBRP.VKORG_AUFT == TVKO.VKORG
Volume unit
  • VBRP.MANDT == T006.MANDT
  • VBRP.VOLEH == T006.MSEHI
Sales unit
  • VBRP.MANDT == T006.MANDT
  • VBRP.VRKME == T006.MSEHI
Shipping Point / Receiving Point
  • VBRP.MANDT == TVST.MANDT
  • VBRP.VSTEL == TVST.VSTEL
Distribution channel of sales order
  • Distribution channel of sales order
  • Client
  • VBRP.VTWEG_AUFT == TVTW.VTWEG
  • VBRP.MANDT == TVTW.MANDT
Plant
  • VBRP.MANDT == T001W.MANDT
  • VBRP.WERKS == T001W.WERKS
Region in which plant is located
  • Departure Country/Region (from which the goods are sent)
  • Region in which plant is located
  • VBRP.MANDT == T005S.MANDT
  • VBRP.ALAND == T005S.LAND1
  • VBRP.WKREG == T005S.BLAND
Product catalog number
  • Product catalog number
  • Client
  • VBRP.WMINR == WWMI.WMINR
  • VBRP.MANDT == WWMI.MANDT
Annexing package key
  • Annexing package key
  • Extended key for annexing package