I_CFinPurchasingDocumentItem

DDL: I_CFINPURCHASINGDOCUMENTITEM Type: view COMPOSITE
130 Fields 2 Data Sources 2 Associations

CFin Purchasing Document: Item

I_CFinPurchasingDocumentItem is a Composite CDS View that provides data about "CFin Purchasing Document: Item" in SAP S/4HANA. It reads from 2 data sources (I_CFinRpldPurchasingDocItem, I_PurchasingDocumentItem) and exposes 130 fields with key fields SenderLogicalSystem, CFinPurchasingDocument, CFinPurchasingDocumentItem, CFinPurchasingDocument, CFinPurchasingDocumentItem. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_CFinRpldPurchasingDocItem I_CFinRpldPurchasingDocItem from
I_PurchasingDocumentItem PurchasingDocumentItem union_all

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CFinPurchasingDocument _CFinPurchasingDocument $projection.CFinPurchasingDocument = _CFinPurchasingDocument.CFinPurchasingDocument and $projection.SenderLogicalSystem = _CFinPurchasingDocument.SenderLogicalSystem
[0..1] I_LogicalSystem _LogicalSystem $projection.SenderLogicalSystem = _LogicalSystem.LogicalSystem

Annotations (11)

NameValueLevelField
EndUserText.label CFin Purchasing Document: Item view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ICFINPOITEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (130)

KeyFieldSource TableSource FieldDescription
KEY SenderLogicalSystem SenderLogicalSystem Sender Logical System
KEY CFinPurchasingDocument Purchasing Document
KEY CFinPurchasingDocumentItem Purchasing Doc. Item
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode Del. Indicator
PurchasingDocumentItemText PurchasingDocumentItemText Short Text
Material Material Vehicle Model
CompanyCode CompanyCode Receiver Company Code
Plant Plant Valuation Area
MaterialGroup MaterialGroup Product Group
TargetQuantity TargetQuantity Target Quantity
OrderQuantity OrderQuantity Quantity
OrderQuantityUnit OrderQuantityUnit Sales Unit
OrderPriceUnit OrderPriceUnit Order Price Un.
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr Quantity Conversion Numerator
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr Quantity Conversion Denominator
OrderItemQtyToBaseQtyNmrtr OrderItemQtyToBaseQtyNmrtr Equal To
OrderItemQtyToBaseQtyDnmntr OrderItemQtyToBaseQtyDnmntr Denominator
NetPriceAmount NetPriceAmount Net Price
NetPriceQuantity NetPriceQuantity Price Unit
NetAmount NetAmount Stated Amount
TaxCode TaxCode Tax Code
ValuationType ValuationType Valuation Type
IsCompletelyDelivered IsCompletelyDelivered Is completely delivered
IsFinallyInvoiced IsFinallyInvoiced Final Invoice
PurchasingDocumentItemCategory PurchasingDocumentItemCategory Item Category
ConsumptionPosting ConsumptionPosting Consumption Posting
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution Distribution
PartialInvoiceDistribution PartialInvoiceDistribution Partial invoice
GoodsReceiptIsExpected GoodsReceiptIsExpected Goods Receipt
GoodsReceiptIsNonValuated GoodsReceiptIsNonValuated GR Non-Valuated
InvoiceIsExpected InvoiceIsExpected Invoice Receipt
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased GR-Based IV
BaseUnit BaseUnit Unit of Measure
NonDeductibleInputTaxAmount NonDeductibleInputTaxAmount Non-deductible
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
InventorySpecialStockType InventorySpecialStockType Special Stock Type
Fund Fund Sender Fund
FundsCenter FundsCenter Funds Center
CommitmentItemShortID CommitmentItemShortID Commitment item
ProfitCenter ProfitCenter Profit Center
ServicePackage ServicePackage Package number
IsStatisticalItem IsStatisticalItem Statisticl.Indicator
EvaldRcptSettlmtIsAllowed EvaldRcptSettlmtIsAllowed ERS
MaterialType MaterialType Material Type
IsReturnsItem IsReturnsItem Returns Item
GrantID GrantID Sender Grant
FunctionalArea FunctionalArea Sendr Fctl Area
BudgetPeriod BudgetPeriod Budget Period
ProductType ProductType Product Type Group
RequisitionerName RequisitionerName Requisitioner
DocumentCurrency I_CFinRpldPurchasingDocItem DocumentCurrency Document Currency
_DocumentCurrency _DocumentCurrency
_LogicalSystem _LogicalSystem
_CompanyCode _CompanyCode
_ConsumptionPosting _ConsumptionPosting
_Plant _Plant
_Material _Material
_MaterialGroup _MaterialGroup
_BaseUnit _BaseUnit
_OrderQuantityUnit _OrderQuantityUnit
_OrderPriceUnit _OrderPriceUnit
_PurgDocumentCategory _PurgDocumentCategory
_PurgDocumentItemCategory _PurgDocumentItemCategory
_CFinPurchasingDocument _CFinPurchasingDocument
KEY CFinPurchasingDocument Purchasing Document
KEY CFinPurchasingDocumentItem Purchasing Doc. Item
PurchasingDocumentDeletionCode I_PurchasingDocumentItem PurchasingDocumentDeletionCode Del. Indicator
PurchasingDocumentItemText I_PurchasingDocumentItem PurchasingDocumentItemText Short Text
Material I_PurchasingDocumentItem Material Vehicle Model
CompanyCode I_PurchasingDocumentItem CompanyCode Receiver Company Code
Plant I_PurchasingDocumentItem Plant Valuation Area
MaterialGroup I_PurchasingDocumentItem MaterialGroup Product Group
TargetQuantity I_PurchasingDocumentItem TargetQuantity Target Quantity
OrderQuantity I_PurchasingDocumentItem OrderQuantity Quantity
OrderQuantityUnit I_PurchasingDocumentItem OrderQuantityUnit Sales Unit
OrderPriceUnit I_PurchasingDocumentItem OrderPriceUnit Order Price Un.
OrderPriceUnitToOrderUnitNmrtr I_PurchasingDocumentItem OrderPriceUnitToOrderUnitNmrtr Quantity Conversion Numerator
OrdPriceUnitToOrderUnitDnmntr I_PurchasingDocumentItem OrdPriceUnitToOrderUnitDnmntr Quantity Conversion Denominator
OrderItemQtyToBaseQtyNmrtr I_PurchasingDocumentItem OrderItemQtyToBaseQtyNmrtr Equal To
OrderItemQtyToBaseQtyDnmntr I_PurchasingDocumentItem OrderItemQtyToBaseQtyDnmntr Denominator
NetPriceAmount I_PurchasingDocumentItem NetPriceAmount Net Price
NetPriceQuantity I_PurchasingDocumentItem NetPriceQuantity Price Unit
NetAmount I_PurchasingDocumentItem NetAmount Stated Amount
TaxCode I_PurchasingDocumentItem TaxCode Tax Code
ValuationType I_PurchasingDocumentItem ValuationType Valuation Type
IsCompletelyDelivered I_PurchasingDocumentItem IsCompletelyDelivered Is completely delivered
IsFinallyInvoiced I_PurchasingDocumentItem IsFinallyInvoiced Final Invoice
PurchasingDocumentItemCategory I_PurchasingDocumentItem PurchasingDocumentItemCategory Item Category
ConsumptionPosting I_PurchasingDocumentItem ConsumptionPosting Consumption Posting
MultipleAcctAssgmtDistribution I_PurchasingDocumentItem MultipleAcctAssgmtDistribution Distribution
PartialInvoiceDistribution I_PurchasingDocumentItem PartialInvoiceDistribution Partial invoice
GoodsReceiptIsExpected I_PurchasingDocumentItem GoodsReceiptIsExpected Goods Receipt
GoodsReceiptIsNonValuated I_PurchasingDocumentItem GoodsReceiptIsNonValuated GR Non-Valuated
InvoiceIsExpected I_PurchasingDocumentItem InvoiceIsExpected Invoice Receipt
InvoiceIsGoodsReceiptBased I_PurchasingDocumentItem InvoiceIsGoodsReceiptBased GR-Based IV
BaseUnit I_PurchasingDocumentItem BaseUnit Unit of Measure
NonDeductibleInputTaxAmount I_PurchasingDocumentItem NonDeductibleInputTaxAmount Non-deductible
PurchasingDocumentCategory I_PurchasingDocumentItem PurchasingDocumentCategory Doc. Category
TaxJurisdiction I_PurchasingDocumentItem TaxJurisdiction Tax Jurisdiction
InventorySpecialStockType I_PurchasingDocumentItem InventorySpecialStockType Special Stock Type
Fund I_PurchasingDocumentItem Fund Sender Fund
FundsCenter I_PurchasingDocumentItem FundsCenter Funds Center
CommitmentItemShortID I_PurchasingDocumentItem CommitmentItem Commitment item
ProfitCenter I_PurchasingDocumentItem ProfitCenter Profit Center
ServicePackage I_PurchasingDocumentItem ServicePackage Package number
IsStatisticalItem I_PurchasingDocumentItem IsStatisticalItem Statisticl.Indicator
EvaldRcptSettlmtIsAllowed I_PurchasingDocumentItem EvaldRcptSettlmtIsAllowed ERS
MaterialType I_PurchasingDocumentItem MaterialType Material Type
IsReturnsItem I_PurchasingDocumentItem IsReturnsItem Returns Item
GrantID I_PurchasingDocumentItem GrantID Sender Grant
FunctionalArea I_PurchasingDocumentItem FunctionalArea Sendr Fctl Area
BudgetPeriod I_PurchasingDocumentItem BudgetPeriod Budget Period
ProductType I_PurchasingDocumentItem ProductType Product Type Group
RequisitionerName I_PurchasingDocumentItem RequisitionerName Requisitioner
DocumentCurrency I_PurchasingDocumentItem DocumentCurrency Document Currency
_DocumentCurrency I_PurchasingDocumentItem _DocumentCurrency
_LogicalSystem _LogicalSystem
_CompanyCode I_PurchasingDocumentItem _CompanyCode
_ConsumptionPosting I_PurchasingDocumentItem _ConsumptionPosting
_Plant _Plant
_Material _Material
_MaterialGroup _MaterialGroup
_BaseUnit _BaseUnit
_OrderQuantityUnit _OrderQuantityUnit
_OrderPriceUnit _OrderPriceUnit
_PurgDocumentCategory _PurgDocumentCategory
_PurgDocumentItemCategory _PurgDocumentItemCategory
_CFinPurchasingDocument _CFinPurchasingDocument
_ProductType _ProductType

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CFinPurchasingDocumentItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_CFinPurchasingDocumentItem AS
SELECT
  SenderLogicalSystem,
  cast( CFinRpldPurchasingDocument as fins_cfin_av_purchasing_doc preserving type ) AS CFinPurchasingDocument,
  cast( CFinRpldPurchasingDocumentItem as fins_cfin_av_purg_document_itm preserving type ) AS CFinPurchasingDocumentItem,
  PurchasingDocumentDeletionCode,
  PurchasingDocumentItemText,
  Material,
  CompanyCode,
  Plant,
  MaterialGroup,
  TargetQuantity,
  OrderQuantity,
  OrderQuantityUnit,
  OrderPriceUnit,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  NetPriceAmount,
  NetPriceQuantity,
  NetAmount,
  TaxCode,
  ValuationType,
  IsCompletelyDelivered,
  IsFinallyInvoiced,
  PurchasingDocumentItemCategory,
  ConsumptionPosting,
  MultipleAcctAssgmtDistribution,
  PartialInvoiceDistribution,
  GoodsReceiptIsExpected,
  GoodsReceiptIsNonValuated,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  BaseUnit,
  NonDeductibleInputTaxAmount,
  PurchasingDocumentCategory,
  TaxJurisdiction,
  InventorySpecialStockType,
  Fund,
  FundsCenter,
  CommitmentItemShortID,
  ProfitCenter,
  ServicePackage,
  IsStatisticalItem,
  EvaldRcptSettlmtIsAllowed,
  MaterialType,
  IsReturnsItem,
  GrantID,
  FunctionalArea,
  BudgetPeriod,
  ProductType,
  RequisitionerName,
  I_CFinRpldPurchasingDocItem.DocumentCurrency AS DocumentCurrency,
  PurchasingDocumentItem._DocumentCurrency AS _DocumentCurrency,
  PurchasingDocumentItem._CompanyCode AS _CompanyCode,
  PurchasingDocumentItem._ConsumptionPosting AS _ConsumptionPosting
FROM I_CFinRpldPurchasingDocItem
LEFT OUTER JOIN I_CFinPurchasingDocument AS _CFinPurchasingDocument ON CFinPurchasingDocument = _CFinPurchasingDocument.CFinPurchasingDocument AND SenderLogicalSystem = _CFinPurchasingDocument.SenderLogicalSystem  -- association [1..1]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON SenderLogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
-- UNION ALL with additional select branch(es): I_PurchasingDocumentItem
;

Learn More