I_CFinSalesDocumentItem

Central Finance Sales Document: Item | view: ICFINSOITEM | TRAN | Extraction: Not supported | Component: Accounting View of Logistics Information
Column Name Description
SenderLogicalSystem FK Logical system
CentralFinanceSalesDocument Central Finance Sales Document
CFinSalesDocumentItem Central Finance Sales Document Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Sales unit (OrderQuantityUnit):
OrderQuantity Cumulative order quantity in sales units
ConfdDelivQtyInOrderQtyUnit Cumulative Confirmed Quantity in Sales Unit
📏 Target Quantity UoM (TargetQuantityUnit):
TargetQuantity Target Quantity in Sales Units
📏 Weight Unit (ItemWeightUnit):
ItemGrossWeight Gross Weight of the Item
ItemNetWeight Net Weight of the Item
📏 Volume unit (ItemVolumeUnit):
ItemVolume Volume of the item
Column Name Description
CreationDate Date on which the record was created
LastChangeDate Last Changed On
PricingDate Date for Pricing and Exchange Rate
BillingDocumentDate Billing Date
Column Name Description
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
IsReturnsItem Returns Item Show values
ItemIsBillingRelevant Relevant for Billing Show values
DeliveryDateQuantityIsFixed Delivery Date and Quantity Fixed Show values
StatisticalValueControl Statistical Values Show values
Column Name Description Domain name
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
Plant Plant (Own or External) WERKS
ProfitCenter Profit Center PRCTR
OriginSDDocument Originating Document VBELN
OriginSDDocumentItem Originating Item POSNR
OrderToBaseQuantityDnmntr Denominator (divisor) for conversion of sales Qty into SKU UMBSN
OrderToBaseQuantityNmrtr Numerator (factor) for conversion of sales quantity into SKU UMBSZ
TargetToBaseQuantityDnmntr Factor for Converting Sales Units to Base Units (Target Qty) UMBSN
TargetToBaseQuantityNmrtr Factor for Converting Sales Units to Base Units (Target Qty) UMBSZ
ProfitabilitySegment Profitability Segment Number (CO-PA) RKEOBJNR
AdditionalValueDays Additional Value Days TAGE2
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_CFINSALESDOCUMENTITEM.BASEUNIT == T006.MSEHI
  • I_CFINSALESDOCUMENTITEM.MANDT == T006.MANDT
Business Area
  • Business Area
  • Client
  • I_CFINSALESDOCUMENTITEM.BUSINESSAREA == TGSB.GSBER
  • I_CFINSALESDOCUMENTITEM.MANDT == TGSB.MANDT
Customer Group
  • Customer Group
  • Client
  • I_CFINSALESDOCUMENTITEM.CUSTOMERGROUP == T151.KDGRP
  • I_CFINSALESDOCUMENTITEM.MANDT == T151.MANDT
Division
  • Client
  • Division
  • I_CFINSALESDOCUMENTITEM.MANDT == TSPA.MANDT
  • I_CFINSALESDOCUMENTITEM.DIVISION == TSPA.SPART
Volume unit
  • Client
  • Volume unit
  • I_CFINSALESDOCUMENTITEM.MANDT == T006.MANDT
  • I_CFINSALESDOCUMENTITEM.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Weight Unit
  • Client
  • I_CFINSALESDOCUMENTITEM.ITEMWEIGHTUNIT == T006.MSEHI
  • I_CFINSALESDOCUMENTITEM.MANDT == T006.MANDT
Material Number
  • Material Number
  • Client
  • I_CFINSALESDOCUMENTITEM.MATERIAL == MARA.MATNR
  • I_CFINSALESDOCUMENTITEM.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • I_CFINSALESDOCUMENTITEM.MANDT == T023.MANDT
  • I_CFINSALESDOCUMENTITEM.MATERIALGROUP == T023.MATKL
Order Number
  • Order Number
  • Client
  • I_CFINSALESDOCUMENTITEM.ORDERID == AUFK.AUFNR
  • I_CFINSALESDOCUMENTITEM.MANDT == AUFK.MANDT
Sales unit
  • Sales unit
  • Client
  • I_CFINSALESDOCUMENTITEM.ORDERQUANTITYUNIT == T006.MSEHI
  • I_CFINSALESDOCUMENTITEM.MANDT == T006.MANDT
Sales document item category
  • Sales document item category
  • Client
  • I_CFINSALESDOCUMENTITEM.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
  • I_CFINSALESDOCUMENTITEM.MANDT == TVPT.MANDT
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • I_CFINSALESDOCUMENTITEM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • I_CFINSALESDOCUMENTITEM.MANDT == TVAG.MANDT
Logical system I_CFINSALESDOCUMENTITEM.SENDERLOGICALSYSTEM == TBDLS.LOGSYS
Storage location
  • Plant (Own or External)
  • Storage location
  • Client
  • I_CFINSALESDOCUMENTITEM.PLANT == T001L.WERKS
  • I_CFINSALESDOCUMENTITEM.STORAGELOCATION == T001L.LGORT
  • I_CFINSALESDOCUMENTITEM.MANDT == T001L.MANDT
Target Quantity UoM
  • Target Quantity UoM
  • Client
  • I_CFINSALESDOCUMENTITEM.TARGETQUANTITYUNIT == T006.MSEHI
  • I_CFINSALESDOCUMENTITEM.MANDT == T006.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • I_CFINSALESDOCUMENTITEM.MANDT == TCURC.MANDT
  • I_CFINSALESDOCUMENTITEM.TRANSACTIONCURRENCY == TCURC.WAERS