R_CFinRpldPurchasingDocItemTP

DDL: R_CFINRPLDPURCHASINGDOCITEMTP Type: view_entity TRANSACTIONAL

CFin Replicated Purchasing Document Item

R_CFinRpldPurchasingDocItemTP is a Transactional CDS View that provides data about "CFin Replicated Purchasing Document Item" in SAP S/4HANA. It reads from 1 data source (I_CFinRpldPurchasingDocItem) and exposes 50 fields with key fields SourceSystemLogicalSystem, CFinRpldPurchasingDocument, CFinRpldPurchasingDocumentItem. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CFinRpldPurchasingDocItem I_CFinRpldPurchasingDocItem from

Associations (5)

CardinalityTargetAliasCondition
[1..1] E_CFinRpldPurchasingDocItem _Extension $projection.CFinRpldPurchasingDocument = _Extension.CFinRpldPurchasingDocument and $projection.SourceSystemLogicalSystem = _Extension.SourceSystemLogicalSystem and $projection.CFinRpldPurchasingDocumentItem = _Extension.CFinRpldPurchasingDocumentItem
[0..*] R_CFinRpldPurgDocAcctAssgmtTP _CFinRpldPurgDocAcctAssgmtTP
[0..*] R_CFinRpldPurgDocSchedLineTP _CFinRpldPurgDocSchedLineTP
[0..*] R_CFinRpldPurgReltdMatlDocTP _CFinRpldPurgReltdMatlDocTP
[0..*] R_CFinRpldPurgDocReltdInvcTP _CFinRpldPurgDocReltdInvcTP

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label CFin Replicated Purchasing Document Item view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY SourceSystemLogicalSystem SenderLogicalSystem
KEY CFinRpldPurchasingDocument CFinRpldPurchasingDocument
KEY CFinRpldPurchasingDocumentItem CFinRpldPurchasingDocumentItem
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode
LastChangedDate LastChangedDate
PurchasingDocumentItemText PurchasingDocumentItemText
Material Material
CompanyCode CompanyCode
Plant Plant
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
AccountAssignmentCategory AccountAssignmentCategory
ConsumptionPosting ConsumptionPosting
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution
PartialInvoiceDistribution PartialInvoiceDistribution
GoodsReceiptIsExpected GoodsReceiptIsExpected
GoodsReceiptIsNonValuated GoodsReceiptIsNonValuated
InvoiceIsExpected InvoiceIsExpected
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased
BaseUnit BaseUnit
NonDeductibleInputTaxAmount NonDeductibleInputTaxAmount
TaxJurisdiction TaxJurisdiction
IsStatisticalItem IsStatisticalItem
EvaldRcptSettlmtIsAllowed EvaldRcptSettlmtIsAllowed
IsReturnsItem IsReturnsItem
InvoiceIsMMServiceEntryBased InvoiceIsMMServiceEntryBased
FunctionalArea FunctionalArea
ProductTypeCode ProductType
RequisitionerName RequisitionerName
DocumentCurrency DocumentCurrency
LastChangeDateTime
_CFinRpldPurchasingDocumentTP _CFinRpldPurchasingDocumentTP
_CFinRpldPurgDocAcctAssgmtTP _CFinRpldPurgDocAcctAssgmtTP
_CFinRpldPurgDocSchedLineTP _CFinRpldPurgDocSchedLineTP
_CFinRpldPurgReltdMatlDocTP _CFinRpldPurgReltdMatlDocTP
_CFinRpldPurgDocReltdInvcTP _CFinRpldPurgDocReltdInvcTP
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'CFin Replicated Purchasing Document Item'
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #MIXED
}
define view entity R_CFinRpldPurchasingDocItemTP
  as select from I_CFinRpldPurchasingDocItem

  association        to parent R_CFinRpldPurchasingDocumentTP as _CFinRpldPurchasingDocumentTP on  $projection.CFinRpldPurchasingDocument = _CFinRpldPurchasingDocumentTP.CFinRpldPurchasingDocument
                                                                                               and $projection.SourceSystemLogicalSystem  = _CFinRpldPurchasingDocumentTP.SourceSystemLogicalSystem

  composition [0..*] of R_CFinRpldPurgDocAcctAssgmtTP         as _CFinRpldPurgDocAcctAssgmtTP

  composition [0..*] of R_CFinRpldPurgDocSchedLineTP          as _CFinRpldPurgDocSchedLineTP

  composition [0..*] of R_CFinRpldPurgReltdMatlDocTP          as _CFinRpldPurgReltdMatlDocTP

  composition [0..*] of R_CFinRpldPurgDocReltdInvcTP          as _CFinRpldPurgDocReltdInvcTP
  association [1..1] to E_CFinRpldPurchasingDocItem           as _Extension                    on  $projection.CFinRpldPurchasingDocument     = _Extension.CFinRpldPurchasingDocument
                                                                                               and $projection.SourceSystemLogicalSystem      = _Extension.SourceSystemLogicalSystem
                                                                                               and $projection.CFinRpldPurchasingDocumentItem = _Extension.CFinRpldPurchasingDocumentItem

{
  key SenderLogicalSystem                                    as SourceSystemLogicalSystem,
  key CFinRpldPurchasingDocument,
  key CFinRpldPurchasingDocumentItem,
      PurchasingDocumentDeletionCode,
      LastChangedDate,
      PurchasingDocumentItemText,
      Material,
      CompanyCode,
      Plant,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      TargetQuantity,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      OrderQuantity,
      OrderQuantityUnit,
      OrderPriceUnit,
      OrderPriceUnitToOrderUnitNmrtr,
      OrdPriceUnitToOrderUnitDnmntr,
      OrderItemQtyToBaseQtyNmrtr,
      OrderItemQtyToBaseQtyDnmntr,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      NetPriceAmount,
      @Semantics.quantity.unitOfMeasure: 'OrderPriceUnit'
      NetPriceQuantity,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      NetAmount,
      TaxCode,
      ValuationType,
      IsCompletelyDelivered,
      IsFinallyInvoiced,
      PurchasingDocumentItemCategory,
      AccountAssignmentCategory,
      ConsumptionPosting,
      MultipleAcctAssgmtDistribution,
      PartialInvoiceDistribution,
      GoodsReceiptIsExpected,
      GoodsReceiptIsNonValuated,
      InvoiceIsExpected,
      InvoiceIsGoodsReceiptBased,
      BaseUnit,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      NonDeductibleInputTaxAmount,
      TaxJurisdiction,
      IsStatisticalItem,
      EvaldRcptSettlmtIsAllowed,
      IsReturnsItem,
      InvoiceIsMMServiceEntryBased,
      FunctionalArea,
      ProductType                                            as ProductTypeCode,
      RequisitionerName,
      DocumentCurrency,

      cast( '00000000000000' as fins_cfin_av_lastchangedon ) as LastChangeDateTime,

      /* Associations */
      _CFinRpldPurchasingDocumentTP,
      _CFinRpldPurgDocAcctAssgmtTP,
      _CFinRpldPurgDocSchedLineTP,
      _CFinRpldPurgReltdMatlDocTP,
      _CFinRpldPurgDocReltdInvcTP
}