R_CFinRpldPurchasingDocItemTP

DDL: R_CFINRPLDPURCHASINGDOCITEMTP Type: view_entity TRANSACTIONAL Package: FINS_CFIN_ACC_VIEW_EX
50 Fields 1 Data Sources 5 Associations

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. Part of development package FINS_CFIN_ACC_VIEW_EX.

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 Sender Logical System
KEY CFinRpldPurchasingDocument CFinRpldPurchasingDocument Purchasing Doc.
KEY CFinRpldPurchasingDocumentItem CFinRpldPurchasingDocumentItem Item
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode Del. Indicator
LastChangedDate LastChangedDate Created On
PurchasingDocumentItemText PurchasingDocumentItemText Short Text
Material Material Vehicle Model
CompanyCode CompanyCode Receiver Company Code
Plant Plant Valuation Area
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
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
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
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
IsStatisticalItem IsStatisticalItem Statisticl.Indicator
EvaldRcptSettlmtIsAllowed EvaldRcptSettlmtIsAllowed ERS
IsReturnsItem IsReturnsItem Returns Item
InvoiceIsMMServiceEntryBased InvoiceIsMMServiceEntryBased Srv.-Based Inv. Ver.
FunctionalArea FunctionalArea Sendr Fctl Area
ProductTypeCode ProductType Product Type Group
RequisitionerName RequisitionerName Requisitioner
DocumentCurrency DocumentCurrency Document Currency
LastChangeDateTime
_CFinRpldPurchasingDocumentTP _CFinRpldPurchasingDocumentTP
_CFinRpldPurgDocAcctAssgmtTP _CFinRpldPurgDocAcctAssgmtTP
_CFinRpldPurgDocSchedLineTP _CFinRpldPurgDocSchedLineTP
_CFinRpldPurgReltdMatlDocTP _CFinRpldPurgReltdMatlDocTP
_CFinRpldPurgDocReltdInvcTP _CFinRpldPurgDocReltdInvcTP

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 R_CFinRpldPurchasingDocItemTP.
-- 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 R_CFinRpldPurchasingDocItemTP AS
SELECT
  SenderLogicalSystem AS SourceSystemLogicalSystem,
  CFinRpldPurchasingDocument,
  CFinRpldPurchasingDocumentItem,
  PurchasingDocumentDeletionCode,
  LastChangedDate,
  PurchasingDocumentItemText,
  Material,
  CompanyCode,
  Plant,
  TargetQuantity,
  OrderQuantity,
  OrderQuantityUnit,
  OrderPriceUnit,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  NetPriceAmount,
  NetPriceQuantity,
  NetAmount,
  TaxCode,
  ValuationType,
  IsCompletelyDelivered,
  IsFinallyInvoiced,
  PurchasingDocumentItemCategory,
  AccountAssignmentCategory,
  ConsumptionPosting,
  MultipleAcctAssgmtDistribution,
  PartialInvoiceDistribution,
  GoodsReceiptIsExpected,
  GoodsReceiptIsNonValuated,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  BaseUnit,
  NonDeductibleInputTaxAmount,
  TaxJurisdiction,
  IsStatisticalItem,
  EvaldRcptSettlmtIsAllowed,
  IsReturnsItem,
  InvoiceIsMMServiceEntryBased,
  FunctionalArea,
  ProductType AS ProductTypeCode,
  RequisitionerName,
  DocumentCurrency,
  cast( '00000000000000' as fins_cfin_av_lastchangedon ) AS LastChangeDateTime
FROM I_CFinRpldPurchasingDocItem
LEFT OUTER JOIN E_CFinRpldPurchasingDocItem AS _Extension ON CFinRpldPurchasingDocument = _Extension.CFinRpldPurchasingDocument AND SourceSystemLogicalSystem = _Extension.SourceSystemLogicalSystem AND CFinRpldPurchasingDocumentItem = _Extension.CFinRpldPurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN R_CFinRpldPurgDocAcctAssgmtTP AS _CFinRpldPurgDocAcctAssgmtTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CFinRpldPurgDocSchedLineTP AS _CFinRpldPurgDocSchedLineTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CFinRpldPurgReltdMatlDocTP AS _CFinRpldPurgReltdMatlDocTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CFinRpldPurgDocReltdInvcTP AS _CFinRpldPurgDocReltdInvcTP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More