S263BIW1

SD - Sales order/delivery note | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
SPTAG Period to analyze - current date
VBELN Sales Document
POSNR Sales Document Item
ETENR FK Schedule Line Number
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
💲 SD Document Currency (S263.WAERK):
NETPR Net Price
OAUWE Net Value of Open Orders
Column Name Description
📏 Sales unit (S263.VRKME):
OAUME Open orders quantity in base unit of measure
OLFMNG Open quantity to be delivered (in sales unit)
Column Name Description
SPTAG Period to analyze - current date
ERDAT Date on which the record was created
STADAT Statistics date
EDATU Schedule line date
LDDAT Loading Date
TDDAT Transportation Planning Date
WADAT Goods Issue Date
MBDAT Material Staging/Availability Date
WLDATBE Desired del. date in confirmed schedule lines
Column Name Description
VBTYP SD Document Category Show values
ABSTA Rejection Status (Item) Show values
SHKZG Returns Item Show values
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
VKORG Sales Organization VKORG
VTWEG Distribution Channel VTWEG
SPARA Division for order header SPART
VKBUR Sales office VKBUR
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
VKGRP Sales group VKGRP
FAKSK Billing Block in SD Document FAKSP
LIFSK Delivery Block (Document Header) LIFSP
BUKRS Company Code BUKRS
MATNR Material Number MATNR
PRODH Product hierarchy PRODH
MATKL Material Group MATKL
CHARG Batch Number CHARG
FAKSP Billing Block for Item FAKSP
WERKS Plant WERKS
LGORT Storage location LGORT
VSTEL Shipping Point / Receiving Point VSTEL
ROUTE Route ROUTE
SPART Division SPART
PKUNWE Ship-to Party KUNNR
PKUNRE Bill-to Party KUNNR
PKUNRG Payer KUNNR
PSPDNR Forwarding Agent LIFNR
PVRTNR Sales employee PERNR
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
KDGRP Customer Group KDGRP
BZIRK Sales District BZIRK
INCO1 Incoterms (Part 1) INCO1
INCO2 Incoterms (Part 2) INCO2
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
STCUR Exchange rate for statistics KURRF
PS_POSID Work Breakdown Structure Element (WBS Element) PS_POSID
ANZAU Number of Orders MCZAEHLER
ANZAUPOS Number of Order Items MCZAEHLER
ETTYP Schedule line category ETTYP
LIFSP Schedule Line Blocked for Delivery LIFSP
Master Data Relations Join Conditions
Sold-to Party
  • S263BIW1.MANDT == KNA1.MANDT
  • S263BIW1.KUNNR == KNA1.KUNNR
Client S263BIW1.MANDT == T000.MANDT
Sales unit
  • S263BIW1.MANDT == T006.MANDT
  • S263BIW1.VRKME == T006.MSEHI