S260

SD - Sales order | #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 Sales Document
POSNR Sales Document Item
ETENR FK Schedule Line Number
Column Name Description
💲 SD Document Currency (WAERK):
NETPR Net Price
NETWR Net Value of the Order Item 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
ZWERT Target Value for Outline Agreement in Document Currency
Column Name Description
📏 Target Quantity UoM (ZIEME):
ZMENG Target Quantity in Sales Units
📏 Sales unit (VRKME):
KWMENG Cumulative order quantity in sales units
LSMENG Cumulative Required Delivery Qty (All Dlv-Relev.Sched.Lines)
KBMENG Cumulative Confirmed Quantity in Sales Unit
WMENG Order Quantity in Sales Units
BMENG Confirmed Quantity
CMENG Corrected quantity in sales unit
📏 Base Unit of Measure (MEINS):
KLMENG Cumulative Confirmed Quantity in Base Unit
LFMNG Minimum Delivery Quantity in Delivery Note Processing
LMENG Required quantity for mat.management in stockkeeping units
📏 Weight Unit (GEWEI):
BRGEW Gross Weight of the Item
NTGEW Net Weight of the Item
📏 Volume unit (VOLEH):
VOLUM Volume of the item
Column Name Description
SPTAG Period to analyze - current date
ERDAT Date on which the record was created
AEDAT Last Changed On
PRSDT Date for Pricing and Exchange Rate
FKDAT Billing Date
FBUDA Date on which services are rendered
STADAT Statistics date
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_AK Sales Document Category of Reference Doc. in Order Header Show values
ABSTA Rejection Status (Item) Show values
UVALL Incompletion Status (Item) Show values
UVVLK Delivery Incompletion Status (Item) Show values
UVFAK Billing Incompletion Status (Item) Show values
UVPRS Pricing Incompletion Status (Item) Show values
VGTYP SD Document Category Show values
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
BUKRS Company Code BUKRS
AUART Sales Document Type AUART
VKORG Sales Organization VKORG
VTWEG Distribution Channel VTWEG
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
SPARA Division for order header SPART
AUGRU Order Reason (Reason for the Business Transaction) AUGRU
FAKSK Billing Block in SD Document FAKSP
LIFSK Delivery Block (Document Header) LIFSP
PSTYV Sales document item category PSTYV
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
PABLA Unloading point of the ship-to party TEXT25
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
ABGRU Reason for Rejection of Sales Documents ABGRU_VA
KDGRP Customer Group KDGRP
BZIRK Sales District BZIRK
INCO1 Incoterms (Part 1) INCO1
INCO2 Incoterms (Part 2) INCO2
KTGRD Account Assignment Group for this Customer KTGRD
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMBSZ
UMVKN Denominator (divisor) for conversion of sales Qty into SKU UMBSN
UMZIZ Factor for Converting Sales Units to Base Units (Target Qty) UMBSZ
UMZIN Factor for Converting Sales Units to Base Units (Target Qty) UMBSN
CMKUA Credit data exchange rate for requested delivery date KURRF
KURSK Exchange Rate for Price Determination KURRF
STCUR Exchange rate for statistics KURRF
ERNAM Name of Person Responsible for Creating the Object USNAM
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
  • S260.MANDT == KNA1.MANDT
  • S260.KUNNR == KNA1.KUNNR
Client S260.MANDT == T000.MANDT
Sales unit
  • S260.MANDT == T006.MANDT
  • S260.VRKME == T006.MSEHI
SD Document Currency
  • S260.MANDT == TCURC.MANDT
  • S260.WAERK == TCURC.WAERS