S261

SD - Delivery note | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
VRSIO Version number in the information structure
SPMON Period to analyze - month
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
VBELN Delivery
POSNR Delivery Item
ETENR FK Schedule Line Number
Column Name Description
Column Name Description
LFIMG Actual quantity delivered (in sales units)
NTGEW Net weight
BRGEW Gross weight
VOLUM Volume
LGMNG Actual quantity delivered in stockkeeping units
📏 Sales unit (VRKME):
VSMNG_L Delivered quantity per schedule line and delivery item
Column Name Description
SPTAG Period to analyze - current date
WADAT_IST Actual Goods Movement Date
LFDAT Delivery Date
ERDAT Date on which the record was created
AEDAT Last Changed On
STADAT Statistics date
APERDAT Creation Date of Order Item
ERZET Entry time
LDDAT Loading Date
TDDAT Transportation Planning Date
EDATU Schedule line 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
VGTYP SD Document Category Show values
KOMKZ Indicator for picking control Show values
POSAR Item Type Show values
WBSTA Goods Movement Status (Item) Show values
KOSTA Picking Status/Putaway Status (Item) Show values
KOQUA Confirmation Status of Picking/Putaway Show values
KZVBR Consumption posting Show values
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
LIFNR Account Number of Supplier LIFNR
ROUTE Route ROUTE
PSPDNR Forwarding Agent LIFNR
PKUNRE Bill-to Party KUNNR
PKUNRG Payer KUNNR
PVRTNR Sales employee PERNR
KDGRP Customer Group KDGRP
BZIRK Sales District BZIRK
VKORG Sales Organization VKORG
SPARA Division for order header SPART
LFART Delivery Type LFART
FAKSK Billing Block in SD Document FAKSP
LIFSK Delivery Block (Document Header) LIFSP
ABLAD Unloading Point TEXT25
INCO1 Incoterms (Part 1) INCO1
INCO2 Incoterms (Part 2) INCO2
KUNNR Ship-to Party KUNNR
KUNAG Sold-to Party KUNNR
LSTEL Loading Point LSTEL
BUKRS Company Code BUKRS
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMBSZ
UMVKN Denominator (divisor) for conversion of sales Qty into SKU UMBSN
PSTYV Sales document item category PSTYV
MATNR Material Number MATNR
MATKL Material Group MATKL
WERKS Plant WERKS
LGORT Storage location LGORT
CHARG Batch Number CHARG
PRODH Product hierarchy PRODH
FAKSP Billing Block FAKSP
VGBEL Document number of the reference document VBELN
VGPOS Item number of the reference item POSNR
LGNUM Warehouse Number / Warehouse Complex LGNUM
LGTYP Storage Type LGTYP
LGPLA Storage Bin LGPLA
GSBER Business Area GSBER
VKBUR Sales office VKBUR
VKGRP Sales group VKGRP
VTWEG Distribution Channel VTWEG
SPART Division SPART
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
ERNAM Name of Person Responsible for Creating the Object USNAM
PS_POSID Work Breakdown Structure Element (WBS Element) PS_POSID
ANZLI No. of deliveries MCZAEHLER
ANZLIPOS Number of delivery items MCZAEHLER
ETTYP Schedule line category ETTYP
LIFSP Schedule Line Blocked for Delivery LIFSP
Master Data Relations Join Conditions
Client S261.MANDT == T000.MANDT
Sales unit
  • S261.MANDT == T006.MANDT
  • S261.VRKME == T006.MSEHI
Shipping Point / Receiving Point
  • S261.MANDT == TVST.MANDT
  • S261.VSTEL == TVST.VSTEL