I_CFinRpldPurchasingDocItemTP

DDL: I_CFINRPLDPURCHASINGDOCITEMTP Type: view_entity TRANSACTIONAL
65 Fields 1 Data Sources

CFin Rpld Purchasing Doc Item Intf - TP

I_CFinRpldPurchasingDocItemTP is a Transactional CDS View that provides data about "CFin Rpld Purchasing Doc Item Intf - TP" in SAP S/4HANA. It reads from 1 data source (R_CFinRpldPurgDocItemTP_2) and exposes 65 fields with key field CFinRpldPurchasingDocItemUUID.

Data Sources (1)

SourceAliasJoin Type
R_CFinRpldPurgDocItemTP_2 R_CFinRpldPurgDocItemTP_2 projection

Annotations (7)

NameValueLevelField
EndUserText.label CFin Rpld Purchasing Doc Item Intf - TP view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY CFinRpldPurchasingDocItemUUID CFinRpldPurchasingDocItemUUID
CFinRpldPurchasingDocUUID CFinRpldPurchasingDocUUID
SourceSystemLogicalSystem SourceSystemLogicalSystem Sender Log Sys.
CFinRpldPurchasingDocument CFinRpldPurchasingDocument Purchasing Doc.
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
MaterialGroup MaterialGroup Product Group
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
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurReqnItemIsCmtmtRelevant PurReqnItemIsCmtmtRelevant
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
InventorySpecialStockType InventorySpecialStockType Special Stock Type
Fund Fund Sender Fund
FundsCenter FundsCenter Funds Center
CommitmentItemShortID CommitmentItemShortID Commitment Item Short ID
ProfitCenter ProfitCenter Profit Center
ServicePackage ServicePackage Package number
IsStatisticalItem IsStatisticalItem Statisticl.Indicator
EvaldRcptSettlmtIsAllowed EvaldRcptSettlmtIsAllowed ERS
MaterialType MaterialType Material Type
IsReturnsItem IsReturnsItem Returns Item
GrantID GrantID Sender Grant
InvoiceIsMMServiceEntryBased InvoiceIsMMServiceEntryBased Srv.-Based Inv. Ver.
FunctionalArea FunctionalArea Sendr Fctl Area
BudgetPeriod BudgetPeriod Budget Period
ProductTypeCode ProductTypeCode Product Type Group
RequisitionerName RequisitionerName Requisitioner
DocumentCurrency DocumentCurrency Document Currency
InventorySpecialStockValnType InventorySpecialStockValnType Valuation
PurchasingDocCompletionStatus PurchasingDocCompletionStatus
PurgDocItemIsServiceBsdCmtmt PurgDocItemIsServiceBsdCmtmt
TimeDependentTaxValidFromDate TimeDependentTaxValidFromDate Tax Rate Valid-From
UnplndDeliveryCostTaxCountry UnplndDeliveryCostTaxCountry
PartnerReportedBusinessArea PartnerReportedBusinessArea
SenderCompanyCode SenderCompanyCode Sender Company Code

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 I_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 I_CFinRpldPurchasingDocItemTP AS
SELECT
  CFinRpldPurchasingDocItemUUID,
  CFinRpldPurchasingDocUUID,
  SourceSystemLogicalSystem,
  CFinRpldPurchasingDocument,
  CFinRpldPurchasingDocumentItem,
  PurchasingDocumentDeletionCode,
  LastChangedDate,
  PurchasingDocumentItemText,
  Material,
  CompanyCode,
  Plant,
  MaterialGroup,
  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,
  PurchasingDocumentCategory,
  PurReqnItemIsCmtmtRelevant,
  TaxJurisdiction,
  InventorySpecialStockType,
  Fund,
  FundsCenter,
  CommitmentItemShortID,
  ProfitCenter,
  ServicePackage,
  IsStatisticalItem,
  EvaldRcptSettlmtIsAllowed,
  MaterialType,
  IsReturnsItem,
  GrantID,
  InvoiceIsMMServiceEntryBased,
  FunctionalArea,
  BudgetPeriod,
  ProductTypeCode,
  RequisitionerName,
  DocumentCurrency,
  InventorySpecialStockValnType,
  PurchasingDocCompletionStatus,
  PurgDocItemIsServiceBsdCmtmt,
  TimeDependentTaxValidFromDate,
  UnplndDeliveryCostTaxCountry,
  PartnerReportedBusinessArea,
  SenderCompanyCode
FROM R_CFinRpldPurgDocItemTP_2
;

Learn More