I_CFinPurchasingDocumentItem

Q: Which tables does I_CFinPurchasingDocumentItem use?

I_CFinPurchasingDocumentItem reads from 2 data source(s): I_CFinRpldPurchasingDocItem, I_PurchasingDocumentItem.

Q: How many fields does I_CFinPurchasingDocumentItem have?

I_CFinPurchasingDocumentItem has 130 fields. Key fields: SenderLogicalSystem, CFinPurchasingDocument, CFinPurchasingDocumentItem, CFinPurchasingDocument, CFinPurchasingDocumentItem.

DDL: I_CFINPURCHASINGDOCUMENTITEM Type: view COMPOSITE

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)

Source	Alias	Join Type
I_CFinRpldPurchasingDocItem	I_CFinRpldPurchasingDocItem	from
I_PurchasingDocumentItem	PurchasingDocumentItem	union_all

Associations (2)

Cardinality	Target	Alias	Condition
[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)

Name	Value	Level
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)

Key	Field	Source Table	Source Field
KEY	SenderLogicalSystem		SenderLogicalSystem
KEY	CFinPurchasingDocument
KEY	CFinPurchasingDocumentItem
	PurchasingDocumentDeletionCode		PurchasingDocumentDeletionCode
	PurchasingDocumentItemText		PurchasingDocumentItemText
	Material		Material
	CompanyCode		CompanyCode
	Plant		Plant
	MaterialGroup		MaterialGroup
	TargetQuantity		TargetQuantity
	OrderQuantity		OrderQuantity
	OrderQuantityUnit		OrderQuantityUnit
	OrderPriceUnit		OrderPriceUnit
	OrderPriceUnitToOrderUnitNmrtr		OrderPriceUnitToOrderUnitNmrtr
	OrdPriceUnitToOrderUnitDnmntr		OrdPriceUnitToOrderUnitDnmntr
	OrderItemQtyToBaseQtyNmrtr		OrderItemQtyToBaseQtyNmrtr
	OrderItemQtyToBaseQtyDnmntr		OrderItemQtyToBaseQtyDnmntr
	NetPriceAmount		NetPriceAmount
	NetPriceQuantity		NetPriceQuantity
	NetAmount		NetAmount
	TaxCode		TaxCode
	ValuationType		ValuationType
	IsCompletelyDelivered		IsCompletelyDelivered
	IsFinallyInvoiced		IsFinallyInvoiced
	PurchasingDocumentItemCategory		PurchasingDocumentItemCategory
	ConsumptionPosting		ConsumptionPosting
	MultipleAcctAssgmtDistribution		MultipleAcctAssgmtDistribution
	PartialInvoiceDistribution		PartialInvoiceDistribution
	GoodsReceiptIsExpected		GoodsReceiptIsExpected
	GoodsReceiptIsNonValuated		GoodsReceiptIsNonValuated
	InvoiceIsExpected		InvoiceIsExpected
	InvoiceIsGoodsReceiptBased		InvoiceIsGoodsReceiptBased
	BaseUnit		BaseUnit
	NonDeductibleInputTaxAmount		NonDeductibleInputTaxAmount
	PurchasingDocumentCategory		PurchasingDocumentCategory
	TaxJurisdiction		TaxJurisdiction
	InventorySpecialStockType		InventorySpecialStockType
	Fund		Fund
	FundsCenter		FundsCenter
	CommitmentItemShortID		CommitmentItemShortID
	ProfitCenter		ProfitCenter
	ServicePackage		ServicePackage
	IsStatisticalItem		IsStatisticalItem
	EvaldRcptSettlmtIsAllowed		EvaldRcptSettlmtIsAllowed
	MaterialType		MaterialType
	IsReturnsItem		IsReturnsItem
	GrantID		GrantID
	FunctionalArea		FunctionalArea
	BudgetPeriod		BudgetPeriod
	ProductType		ProductType
	RequisitionerName		RequisitionerName
	DocumentCurrency	I_CFinRpldPurchasingDocItem	DocumentCurrency
	_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
KEY	CFinPurchasingDocumentItem
	PurchasingDocumentDeletionCode	I_PurchasingDocumentItem	PurchasingDocumentDeletionCode
	PurchasingDocumentItemText	I_PurchasingDocumentItem	PurchasingDocumentItemText
	Material	I_PurchasingDocumentItem	Material
	CompanyCode	I_PurchasingDocumentItem	CompanyCode
	Plant	I_PurchasingDocumentItem	Plant
	MaterialGroup	I_PurchasingDocumentItem	MaterialGroup
	TargetQuantity	I_PurchasingDocumentItem	TargetQuantity
	OrderQuantity	I_PurchasingDocumentItem	OrderQuantity
	OrderQuantityUnit	I_PurchasingDocumentItem	OrderQuantityUnit
	OrderPriceUnit	I_PurchasingDocumentItem	OrderPriceUnit
	OrderPriceUnitToOrderUnitNmrtr	I_PurchasingDocumentItem	OrderPriceUnitToOrderUnitNmrtr
	OrdPriceUnitToOrderUnitDnmntr	I_PurchasingDocumentItem	OrdPriceUnitToOrderUnitDnmntr
	OrderItemQtyToBaseQtyNmrtr	I_PurchasingDocumentItem	OrderItemQtyToBaseQtyNmrtr
	OrderItemQtyToBaseQtyDnmntr	I_PurchasingDocumentItem	OrderItemQtyToBaseQtyDnmntr
	NetPriceAmount	I_PurchasingDocumentItem	NetPriceAmount
	NetPriceQuantity	I_PurchasingDocumentItem	NetPriceQuantity
	NetAmount	I_PurchasingDocumentItem	NetAmount
	TaxCode	I_PurchasingDocumentItem	TaxCode
	ValuationType	I_PurchasingDocumentItem	ValuationType
	IsCompletelyDelivered	I_PurchasingDocumentItem	IsCompletelyDelivered
	IsFinallyInvoiced	I_PurchasingDocumentItem	IsFinallyInvoiced
	PurchasingDocumentItemCategory	I_PurchasingDocumentItem	PurchasingDocumentItemCategory
	ConsumptionPosting	I_PurchasingDocumentItem	ConsumptionPosting
	MultipleAcctAssgmtDistribution	I_PurchasingDocumentItem	MultipleAcctAssgmtDistribution
	PartialInvoiceDistribution	I_PurchasingDocumentItem	PartialInvoiceDistribution
	GoodsReceiptIsExpected	I_PurchasingDocumentItem	GoodsReceiptIsExpected
	GoodsReceiptIsNonValuated	I_PurchasingDocumentItem	GoodsReceiptIsNonValuated
	InvoiceIsExpected	I_PurchasingDocumentItem	InvoiceIsExpected
	InvoiceIsGoodsReceiptBased	I_PurchasingDocumentItem	InvoiceIsGoodsReceiptBased
	BaseUnit	I_PurchasingDocumentItem	BaseUnit
	NonDeductibleInputTaxAmount	I_PurchasingDocumentItem	NonDeductibleInputTaxAmount
	PurchasingDocumentCategory	I_PurchasingDocumentItem	PurchasingDocumentCategory
	TaxJurisdiction	I_PurchasingDocumentItem	TaxJurisdiction
	InventorySpecialStockType	I_PurchasingDocumentItem	InventorySpecialStockType
	Fund	I_PurchasingDocumentItem	Fund
	FundsCenter	I_PurchasingDocumentItem	FundsCenter
	CommitmentItemShortID	I_PurchasingDocumentItem	CommitmentItem
	ProfitCenter	I_PurchasingDocumentItem	ProfitCenter
	ServicePackage	I_PurchasingDocumentItem	ServicePackage
	IsStatisticalItem	I_PurchasingDocumentItem	IsStatisticalItem
	EvaldRcptSettlmtIsAllowed	I_PurchasingDocumentItem	EvaldRcptSettlmtIsAllowed
	MaterialType	I_PurchasingDocumentItem	MaterialType
	IsReturnsItem	I_PurchasingDocumentItem	IsReturnsItem
	GrantID	I_PurchasingDocumentItem	GrantID
	FunctionalArea	I_PurchasingDocumentItem	FunctionalArea
	BudgetPeriod	I_PurchasingDocumentItem	BudgetPeriod
	ProductType	I_PurchasingDocumentItem	ProductType
	RequisitionerName	I_PurchasingDocumentItem	RequisitionerName
	DocumentCurrency	I_PurchasingDocumentItem	DocumentCurrency
	_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

@EndUserText.label: 'CFin Purchasing Document: Item'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
  sqlViewName: 'ICFINPOITEM',
  compiler.compareFilter: true,
  preserveKey: true
}
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #L
   }
}
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] } */
define view I_CFinPurchasingDocumentItem
  as select from I_CFinRpldPurchasingDocItem
  association [1..1] to I_CFinPurchasingDocument as _CFinPurchasingDocument on  $projection.CFinPurchasingDocument = _CFinPurchasingDocument.CFinPurchasingDocument
                                                                            and $projection.SenderLogicalSystem    = _CFinPurchasingDocument.SenderLogicalSystem

{
      @ObjectModel.foreignKey.association: '_LogicalSystem'
  key SenderLogicalSystem,
      @ObjectModel.foreignKey.association: '_CFinPurchasingDocument'
  key cast( CFinRpldPurchasingDocument as fins_cfin_av_purchasing_doc preserving type )         as CFinPurchasingDocument,
  key cast( CFinRpldPurchasingDocumentItem as fins_cfin_av_purg_document_itm preserving type  ) as CFinPurchasingDocumentItem,
      PurchasingDocumentDeletionCode,
      @Semantics.text: true
      PurchasingDocumentItemText,
      @ObjectModel.foreignKey.association: '_Material'
      Material,
      @ObjectModel.foreignKey.association: '_CompanyCode'
      CompanyCode,
      @ObjectModel.foreignKey.association: '_Plant'
      Plant,
      @ObjectModel.foreignKey.association: '_MaterialGroup'
      MaterialGroup,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      @DefaultAggregation: #NONE
      TargetQuantity,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      @DefaultAggregation: #NONE
      OrderQuantity,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association:'_OrderQuantityUnit'
      OrderQuantityUnit,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association:'_OrderPriceUnit'
      OrderPriceUnit,
      OrderPriceUnitToOrderUnitNmrtr,
      OrdPriceUnitToOrderUnitDnmntr,
      OrderItemQtyToBaseQtyNmrtr,
      OrderItemQtyToBaseQtyDnmntr,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      @DefaultAggregation: #NONE
      NetPriceAmount,
      @Semantics.quantity.unitOfMeasure: 'OrderPriceUnit'
      @DefaultAggregation: #NONE
      NetPriceQuantity,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      @DefaultAggregation: #NONE
      NetAmount,
      TaxCode,
      ValuationType,
      IsCompletelyDelivered,
      IsFinallyInvoiced,
      @ObjectModel.foreignKey.association: '_PurgDocumentItemCategory'
      PurchasingDocumentItemCategory,
      @ObjectModel.foreignKey.association: '_ConsumptionPosting'
      ConsumptionPosting,
      MultipleAcctAssgmtDistribution,
      PartialInvoiceDistribution,
      GoodsReceiptIsExpected,
      GoodsReceiptIsNonValuated,
      InvoiceIsExpected,
      InvoiceIsGoodsReceiptBased,
      @Semantics.unitOfMeasure: true
      BaseUnit,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      @DefaultAggregation: #NONE
      NonDeductibleInputTaxAmount,
      @ObjectModel.foreignKey.association: '_PurgDocumentCategory'
      PurchasingDocumentCategory,
      TaxJurisdiction,
      InventorySpecialStockType,
      Fund,
      FundsCenter,
      CommitmentItemShortID,
      ProfitCenter,
      ServicePackage,
      IsStatisticalItem,
      EvaldRcptSettlmtIsAllowed,
      MaterialType,
      IsReturnsItem,
      GrantID,
      FunctionalArea,
      BudgetPeriod,
      @ObjectModel.foreignKey.association: '_ProductType'
      ProductType,
      RequisitionerName,
      @Semantics.currencyCode: true
      @ObjectModel.foreignKey.association: '_DocumentCurrency'
      I_CFinRpldPurchasingDocItem.DocumentCurrency,
      
      
      _DocumentCurrency,
      _LogicalSystem,
      _CompanyCode,
      _ConsumptionPosting,
      _Plant,
      _Material,
      _MaterialGroup,
      _BaseUnit,
      _OrderQuantityUnit,
      _OrderPriceUnit,
      _PurgDocumentCategory,
      _PurgDocumentItemCategory,
      _CFinPurchasingDocument,
      _ProductType

}


union all select from I_PurchasingDocumentItem as PurchasingDocumentItem

association [1..1] to I_CFinPurchasingDocument as _CFinPurchasingDocument on  $projection.CFinPurchasingDocument = _CFinPurchasingDocument.CFinPurchasingDocument
                                                                          and $projection.SenderLogicalSystem    = _CFinPurchasingDocument.SenderLogicalSystem
association [0..1] to I_LogicalSystem          as _LogicalSystem          on  $projection.SenderLogicalSystem = _LogicalSystem.LogicalSystem

{
      @ObjectModel.foreignKey.association: '_LogicalSystem'
  key cast( '          ' as logsys preserving type  )                                   as SenderLogicalSystem,
      @ObjectModel.foreignKey.association: '_CFinPurchasingDocument'
  key cast( PurchasingDocument as fins_cfin_av_purchasing_doc preserving type )         as CFinPurchasingDocument,
  key cast( PurchasingDocumentItem as fins_cfin_av_purg_document_itm preserving type  ) as CFinPurchasingDocumentItem,
      PurchasingDocumentItem.PurchasingDocumentDeletionCode,
      @Semantics.text: true
      PurchasingDocumentItem.PurchasingDocumentItemText,
      @ObjectModel.foreignKey.association: '_Material'
      PurchasingDocumentItem.Material,
      @ObjectModel.foreignKey.association: '_CompanyCode'
      PurchasingDocumentItem.CompanyCode,
      @ObjectModel.foreignKey.association: '_Plant'
      PurchasingDocumentItem.Plant,
      @ObjectModel.foreignKey.association: '_MaterialGroup'
      PurchasingDocumentItem.MaterialGroup,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      @DefaultAggregation: #NONE
      PurchasingDocumentItem.TargetQuantity,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      @DefaultAggregation: #NONE
      PurchasingDocumentItem.OrderQuantity,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association:'_OrderQuantityUnit'
      PurchasingDocumentItem.OrderQuantityUnit,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association:'_OrderPriceUnit'
      PurchasingDocumentItem.OrderPriceUnit,
      PurchasingDocumentItem.OrderPriceUnitToOrderUnitNmrtr,
      PurchasingDocumentItem.OrdPriceUnitToOrderUnitDnmntr,
      PurchasingDocumentItem.OrderItemQtyToBaseQtyNmrtr,
      PurchasingDocumentItem.OrderItemQtyToBaseQtyDnmntr,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      @DefaultAggregation: #NONE
      PurchasingDocumentItem.NetPriceAmount,
      @Semantics.quantity.unitOfMeasure: 'OrderPriceUnit'
      @DefaultAggregation: #NONE
      PurchasingDocumentItem.NetPriceQuantity,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      @DefaultAggregation: #NONE
      PurchasingDocumentItem.NetAmount,
      PurchasingDocumentItem.TaxCode,
      PurchasingDocumentItem.ValuationType,
      PurchasingDocumentItem.IsCompletelyDelivered,
      PurchasingDocumentItem.IsFinallyInvoiced,
      @ObjectModel.foreignKey.association: '_PurgDocumentItemCategory'
      PurchasingDocumentItem.PurchasingDocumentItemCategory,
      @ObjectModel.foreignKey.association: '_ConsumptionPosting'
      PurchasingDocumentItem.ConsumptionPosting,
      PurchasingDocumentItem.MultipleAcctAssgmtDistribution,
      PurchasingDocumentItem.PartialInvoiceDistribution,
      PurchasingDocumentItem.GoodsReceiptIsExpected,
      PurchasingDocumentItem.GoodsReceiptIsNonValuated,
      PurchasingDocumentItem.InvoiceIsExpected,
      PurchasingDocumentItem.InvoiceIsGoodsReceiptBased,
      @Semantics.unitOfMeasure: true
      PurchasingDocumentItem.BaseUnit,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      @DefaultAggregation: #NONE
      PurchasingDocumentItem.NonDeductibleInputTaxAmount,
      @ObjectModel.foreignKey.association: '_PurgDocumentCategory'
      PurchasingDocumentItem.PurchasingDocumentCategory,
      PurchasingDocumentItem.TaxJurisdiction,
      PurchasingDocumentItem.InventorySpecialStockType,
      PurchasingDocumentItem.Fund,
      PurchasingDocumentItem.FundsCenter,
      PurchasingDocumentItem.CommitmentItem                                             as CommitmentItemShortID,
      PurchasingDocumentItem.ProfitCenter,
      PurchasingDocumentItem.ServicePackage,
      PurchasingDocumentItem.IsStatisticalItem,
      PurchasingDocumentItem.EvaldRcptSettlmtIsAllowed,
      PurchasingDocumentItem.MaterialType,
      PurchasingDocumentItem.IsReturnsItem,
      PurchasingDocumentItem.GrantID,
      PurchasingDocumentItem.FunctionalArea,
      PurchasingDocumentItem.BudgetPeriod,
      @ObjectModel.foreignKey.association: '_ProductType'
      PurchasingDocumentItem.ProductType,
      PurchasingDocumentItem.RequisitionerName,
      @Semantics.currencyCode: true
      @ObjectModel.foreignKey.association: '_DocumentCurrency'
      PurchasingDocumentItem.DocumentCurrency,

      PurchasingDocumentItem._DocumentCurrency,
      _LogicalSystem,
      PurchasingDocumentItem._CompanyCode,
      PurchasingDocumentItem._ConsumptionPosting,
      _Plant,
      _Material,
      _MaterialGroup,
      _BaseUnit,
      _OrderQuantityUnit,
      _OrderPriceUnit,
      _PurgDocumentCategory,
      _PurgDocumentItemCategory,
      _CFinPurchasingDocument,
      _ProductType


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CFINRPLDPURCHASINGDOCITEM",
"I_PURCHASINGDOCUMENTITEM"
],
"ASSOCIATED":
[
"I_CFINPURCHASINGDOCUMENT",
"I_COMPANYCODE",
"I_CONSUMPTIONPOSTING",
"I_CURRENCY",
"I_LOGICALSYSTEM",
"I_MATERIAL",
"I_MATERIALGROUP",
"I_PLANT",
"I_PRODUCTTYPECODE",
"I_PURCHASINGDOCUMENTCATEGORY",
"I_PURGDOCUMENTITEMCATEGORY",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_CFINRPLDPURCHASINGDOCITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_CFinPurchasingDocumentItem view

I_CFinRpldPurchasingDocItem view
I_PurchasingDocumentItem view

P_ACCRUALPURCHASEORDER view