S008

Communications Table SD -> CO/Projects | #other | Component: Data Collection
Column Name Description
MANDT 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 and Distribution Document Number
POSNR Item number of the SD document
ETENR FK Schedule Line Number
FPLNR Billing plan number / invoicing plan number
FPLTR Item for billing plan/invoice plan/payment cards
KSCHL Condition Type
STUNR Step Number
ZAEHK Condition Counter
ALTNEU Statistics update indicator (post in/post out) Show values
Column Name Description
💲 Currency Key (WAERK):
SKFBT Amount Eligible for Cash Discount in Document Currency
KWERT Condition Value
💲 Local Currency (HWAER):
KWERH Condition value in local currency
Column Name Description
📏 Base Unit of Measure (MEINS):
ERLMENGE_L Completed quantity (delivery)
ERLMENGE_F Invoiced quantity in basic unit of measure
FKLMG Billing quantity in stock keeping unit
LMENG Required quantity for mat.management in stockkeeping units
ERLMENGE Quantity for completion (sales) in basic unit of measure
📏 Sales unit (VRKME):
KWMENG Cumulative order quantity in sales units
ZMENG Target Quantity in Sales Units
FKIMG Actual billed quantity
LFIMG Actual quantity delivered (in sales units)
WMENG Order Quantity in Sales Units
BMENG Confirmed Quantity
Column Name Description
SPTAG Period to analyze - current date
ANGDT Quotation/Inquiry is Valid From
BNDDT Date Until Which Bid/Quotation is Binding (Valid-To Date)
ZFBDT Baseline Date for Due Date Calculation
STDAT Key date of the bill of material
PRSDT Date for Pricing and Exchange Rate
FKDAT Billing Date
FBUDA Date on which services are rendered
BUDAT Posting Date in the Document
WADAT Goods Issue Date
BLDAT Document Date in Document
BDDAT Requirement date (deadline for procurement)
Column Name Description
ALTNEU Statistics update indicator (post in/post out) Show values
FKTYP Billing Category Show values
VBTYP SD Document Category Show values
FKREL Relevant for Billing Show values
AWAHR Order Probability of the Item Show values
SHKZG Debit/Credit Indicator Show values
KNTYP Condition Category (Examples: Tax, Freight, Price, Cost) Show values
KZVBR Consumption posting Show values
FAREG Rule in billing plan/invoice plan Show values
Column Name Description Domain name
FKART Billing Type FKART
PERIV Fiscal Year Variant PERIV
BUKRS Company Code BUKRS
GSBER Business Area GSBER
VKORG Sales Organization VKORG
VTWEG Distribution Channel VTWEG
KUNAG Sold-to Party KUNNR
ZTERM Terms of payment key ZTERM
ABSTA Release status (current release, old release) ABSTA
MATNR Material Number MATNR
KBVER Allowed deviation in quantity (in percent) PACK2
KEVER Days by which the quantity can be shifted PACK2
STLNR Bill of Material STNUM
STPOS Bill of material item number STPOS
SPART Division SPART
WERKS Plant WERKS
KDGRP Customer Group KDGRP
BZIRK Sales District BZIRK
LAND1 Destination Country/Region LAND1
REGIO Region (State, Province, County) REGIO
COUNC County Code COUNC
CITYC City Code CITYC
BONUS Volume rebate group BONUS
PROVG Commission Group PROVG
VKGRP Sales group VKGRP
VKBUR Sales office VKBUR
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
KOSTL Cost Center KOSTL
PRCTR Profit Center PRCTR
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
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM
KURSK Exchange Rate for Price Determination KURRF
SAKN1 G/L Account Number SAKNR
OBJNR Object Number at Item Level J_OBJNR
AUART Sales Document Type AUART
GRPOS Item for Which this Item is an Alternative GRPOS
VBELV Originating Document VBELN
POSNV Originating Item POSNR
FPROZ Percentage of value to be invoiced PRZ32
Master Data Relations Join Conditions
Order Number
  • Order Number
  • Client
  • S008.AUFNR == AUFK.AUFNR
  • S008.MANDT == AUFK.MANDT
Application S008.KAPPL == T681A.KAPPL
Material Entered
  • Material Entered
  • Client
  • S008.MATWA == MARA.MATNR
  • S008.MANDT == MARA.MANDT
Pricing Reference Material
  • Pricing Reference Material
  • Client
  • S008.PMATN == MARA.MATNR
  • S008.MANDT == MARA.MANDT