I_CFinPurchasingDocumentItem

DDL: I_CFINPURCHASINGDOCUMENTITEM Type: view COMPOSITE Package: FINS_CFIN_ACC_VIEW_API

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 1 data source (I_PurchasingDocumentItem) and exposes 65 fields with key fields SenderLogicalSystem, CFinPurchasingDocument, CFinPurchasingDocumentItem. It has 2 associations to related views. Part of development package FINS_CFIN_ACC_VIEW_API.

1 data source(s) 65 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchasingDocumentItem PurchasingDocumentItem from

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 (12)

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
ObjectModel.representativeKey CFinPurchasingDocumentItem view

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY SenderLogicalSystem
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
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
   },
   representativeKey:'CFinPurchasingDocumentItem'
}
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] } */
define view I_CFinPurchasingDocumentItem
  as 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.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


}

Learn More