CFIN_AV_SO_ITEM

Sales Document: Item Data | #masterdata | Component: Accounting View of Logistics Information
Column Name Description
MANDT Client
AV_DBKEY Accounting View DB KEY
Column Name Description
💲 SD Document Currency (WAERK):
NETWR Net Value of the Order Item in Document Currency
Column Name Description
📏 Sales unit (VRKME):
KWMENG Cumulative order quantity in sales units
KBMENG Cumulative Confirmed Quantity in Sales Unit
📏 Target Quantity UoM (ZIEME):
ZMENG Target Quantity in Sales 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
ERDAT Date on which the record was created
AEDAT Last Changed On
Column Name Description
VGTYP Document Category of Preceding SD Document Show values
SHKZG Returns Item Show values
KZVBR Consumption posting Show values
FKREL Relevant for Billing Show values
FIXMG Delivery Date and Quantity Fixed Show values
KOWRR Statistical Values Show values
VGREF Preceding document has resulted from reference Show values
Column Name Description Domain name
AV_PARENTKEY Accounting View Parent Key SYSUUID_X16
AV_ROOTKEY Accounting View Root Key SYSUUID_X16
VBELN Sales Document VBELN
POSNR Sales Document Item POSNR
VGBEL Document number of the reference document VBELN
VGPOS Item number of the reference item POSNR
WERKS Plant (Own or External) WERKS
PRCTR Profit Center PRCTR
VBELV Originating Document VBELN
POSNV Originating Item POSNR
REVACC_REFID Revenue Accounting: Reference ID
REVACC_REFTYPE Revenue Accounting: Reference Type
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
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR
STCUR Exchange rate for statistics (Exch.rate at time of creation) KURRF
DUMMY_AVSOITM_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes
Master Data Relations Join Conditions
Results Analysis Key
  • CFIN_AV_SO_ITEM.MANDT == TKKAA.MANDT
  • CFIN_AV_SO_ITEM.ABGRS == TKKAA.ABGSL
Reason for Rejection of Sales Documents
  • CFIN_AV_SO_ITEM.MANDT == TVAG.MANDT
  • CFIN_AV_SO_ITEM.ABGRU == TVAG.ABGRU
Order Number
  • Order Number
  • Client
  • CFIN_AV_SO_ITEM.AUFNR == AUFK.AUFNR
  • CFIN_AV_SO_ITEM.MANDT == AUFK.MANDT
Operating concern
  • CFIN_AV_SO_ITEM.MANDT == TKEB.MANDT
  • CFIN_AV_SO_ITEM.ERKRS == TKEB.ERKRS
Logical system CFIN_AV_SO_ITEM.FINS_LOGSYS == TBDLS.LOGSYS
Weight Unit
  • CFIN_AV_SO_ITEM.MANDT == T006.MANDT
  • CFIN_AV_SO_ITEM.GEWEI == T006.MSEHI
Business Area
  • CFIN_AV_SO_ITEM.MANDT == TGSB.MANDT
  • CFIN_AV_SO_ITEM.GSBER == TGSB.GSBER
Storage location
  • Storage location
  • Client
  • Plant (Own or External)
  • CFIN_AV_SO_ITEM.LGORT == T001L.LGORT
  • CFIN_AV_SO_ITEM.MANDT == T001L.MANDT
  • CFIN_AV_SO_ITEM.WERKS == T001L.WERKS
Material Group
  • CFIN_AV_SO_ITEM.MANDT == T023.MANDT
  • CFIN_AV_SO_ITEM.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • CFIN_AV_SO_ITEM.MATNR == MARA.MATNR
  • CFIN_AV_SO_ITEM.MANDT == MARA.MANDT
Base Unit of Measure
  • CFIN_AV_SO_ITEM.MANDT == T006.MANDT
  • CFIN_AV_SO_ITEM.MEINS == T006.MSEHI
Sales document item category
  • Sales document item category
  • Client
  • CFIN_AV_SO_ITEM.PSTYV == TVPT.PSTYV
  • CFIN_AV_SO_ITEM.MANDT == TVPT.MANDT
Division
  • CFIN_AV_SO_ITEM.MANDT == TSPA.MANDT
  • CFIN_AV_SO_ITEM.SPART == TSPA.SPART
Volume unit
  • CFIN_AV_SO_ITEM.MANDT == T006.MANDT
  • CFIN_AV_SO_ITEM.VOLEH == T006.MSEHI
Sales unit
  • CFIN_AV_SO_ITEM.MANDT == T006.MANDT
  • CFIN_AV_SO_ITEM.VRKME == T006.MSEHI
SD Document Currency
  • CFIN_AV_SO_ITEM.MANDT == TCURC.MANDT
  • CFIN_AV_SO_ITEM.WAERK == TCURC.WAERS
Target Quantity UoM
  • CFIN_AV_SO_ITEM.MANDT == T006.MANDT
  • CFIN_AV_SO_ITEM.ZIEME == T006.MSEHI