R_CFinRpldPurchasingDocItemTP
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)
| Source | Alias | Join Type |
|---|---|---|
| I_CFinRpldPurchasingDocItem | I_CFinRpldPurchasingDocItem | from |
Associations (5)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA