S262BIW2

SD - Billing document | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
SPTAG Period to analyze - current date
VBELN Billing Document
POSNR Billing Item
VRSIO Version number in the information structure
SPMON Period to analyze - month
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
SSOUR Statistic(s) origin
Column Name Description
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
MWSBP Tax Amount in Document Currency
Column Name Description
FKIMG Actual billed quantity
SMENG Scale Quantity in base unit of measure
FKLMG Billing quantity in stock keeping unit
LMENG Required quantity for mat.management in stockkeeping units
NTGEW Net weight
BRGEW Gross weight
VOLUM Volume
Column Name Description
SPTAG Period to analyze - current date
FKDAT Billing Date
ERDAT Date on which the record was created
AEDAT Last Changed On
STADAT Statistics date
PRSDT Date for Pricing and Exchange Rate
FBUDA Date on which services are rendered
ERZET Entry time
Column Name Description
FKTYP Billing Category Show values
VBTYP SD Document Category Show values
POSAR Item Type Show values
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
KURRF Exchange Rate for Postings to Financial Accounting KURRF
FKART Billing Type FKART
VKORG Sales Organization VKORG
VTWEG Distribution Channel VTWEG
BUKRS Company Code BUKRS
KUNRG Payer KUNNR
KDGRP Customer Group KDGRP
BZIRK Sales District BZIRK
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
PSTYV Sales document item category PSTYV
PRODH Product hierarchy PRODH
VSTEL Shipping Point / Receiving Point VSTEL
SPART Division SPART
WERKS Plant WERKS
KOSTL Cost Center KOSTL
BONUS Volume rebate group BONUS
PROVG Commission Group PROVG
VKGRP Sales group VKGRP
VKBUR Sales office VKBUR
SPARA Division for order header SPART
MATNR Material Number MATNR
MATKL Material Group MATKL
CHARG Batch Number CHARG
LGORT Storage location LGORT
KVGR1 Customer Group 1 KVGR1
KVGR2 Customer Group 2 KVGR2
KVGR3 Customer Group 3 KVGR3
KVGR4 Customer Group 4 KVGR4
KVGR5 Customer Group 5 KVGR5
MVGR1 Material Group 1 MVGR1
MVGR2 Material Group 2 MVGR2
MVGR3 Material Group 3 MVGR3
MVGR4 Material Group 4 MVGR4
MVGR5 Material Group 5 MVGR5
KOKRS Controlling Area CACCD
PKUNWE Ship-to Party KUNNR
PKUNRE Bill-to Party KUNNR
PSPDNR Forwarding Agent LIFNR
PVRTNR Sales employee PERNR
AUBEL Sales Document VBELN
AUPOS Sales Document Item POSNR
VGBEL Document number of the reference document VBELN
VGPOS Item number of the reference item POSNR
STCUR Exchange rate for statistics (Exch.rate at time of creation) KURRF
ERNAM Name of Person Responsible for Creating the Object USNAM
PS_POSID Work Breakdown Structure Element (WBS Element) PS_POSID
ANZFK No.of billing docs MCZAEHLER
ANZFKPOS Number of billing items MCZAEHLER
Master Data Relations Join Conditions
Sold-to Party
  • S262BIW2.MANDT == KNA1.MANDT
  • S262BIW2.KUNAG == KNA1.KUNNR
Client S262BIW2.MANDT == T000.MANDT
SD Document Currency
  • S262BIW2.MANDT == TCURC.MANDT
  • S262BIW2.WAERK == TCURC.WAERS