C_CFinRpldPurchaseOrderItem

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 C_CFinRpldPurchaseOrderItem.
-- 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 C_CFinRpldPurchaseOrderItem AS
SELECT
  SenderLogicalSystem,
  cast( CFinRpldPurchasingDocument as fins_cfin_av_rpld_purord preserving type ) AS CFinReplicatedPurchaseOrder,
  cast( CFinRpldPurchasingDocumentItem as fins_cfin_av_rpld_purord_item preserving type ) AS CFinRpldPurchaseOrderItem,
  PurchasingDocumentItemText,
  Material,
  _MaterialText[1: Language = $session.system_language].MaterialName AS MaterialName,
  CompanyCode,
  Plant,
  MaterialGroup,
  TargetQuantity,
  OrderQuantity,
  OrderQuantityUnit,
  OrderPriceUnit,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  NetPriceAmount,
  NetPriceQuantity,
  NetAmount,
  TaxCode,
  ValuationType,
  IsCompletelyDelivered,
  IsFinallyInvoiced,
  PurchasingDocumentItemCategory,
  AccountAssignmentCategory,
  ConsumptionPosting,
  MultipleAcctAssgmtDistribution,
  PartialInvoiceDistribution,
  GoodsReceiptIsExpected,
  InvoiceIsExpected,
  GoodsReceiptIsNonValuated,
  InvoiceIsGoodsReceiptBased,
  BaseUnit,
  NonDeductibleInputTaxAmount,
  PurchasingDocumentCategory,
  TaxJurisdiction,
  InventorySpecialStockType,
  Fund,
  FundsCenter,
  CommitmentItemShortID,
  ProfitCenter,
  ServicePackage,
  IsStatisticalItem,
  LastChangedDate,
  EvaldRcptSettlmtIsAllowed,
  MaterialType,
  IsReturnsItem,
  GrantID,
  FunctionalArea,
  BudgetPeriod,
  ProductType,
  RequisitionerName,
  DocumentCurrency,
  TaxCalculationProcedure
FROM I_CFinRpldPurchasingDocItem
LEFT OUTER JOIN C_CFinRpldPurchaseOrder AS _CFinRpldPurchaseOrder ON CFinReplicatedPurchaseOrder = _CFinRpldPurchaseOrder.CFinReplicatedPurchaseOrder AND SenderLogicalSystem = _CFinRpldPurchaseOrder.SenderLogicalSystem  -- association [1..1]
LEFT OUTER JOIN C_CFinRpldPurOrdScheduleLine AS _CFinRpldPurOrdScheduleLine ON SenderLogicalSystem = _CFinRpldPurOrdScheduleLine.SenderLogicalSystem AND CFinReplicatedPurchaseOrder = _CFinRpldPurOrdScheduleLine.CFinReplicatedPurchaseOrder AND CFinRpldPurchaseOrderItem = _CFinRpldPurOrdScheduleLine.CFinRpldPurchaseOrderItem  -- association [0..*]
LEFT OUTER JOIN C_CFinRpldPurchaseOrderHistory AS _CFinRpldPurchaseOrderHistory ON SenderLogicalSystem = _CFinRpldPurchaseOrderHistory.SenderLogicalSystem AND CFinReplicatedPurchaseOrder = _CFinRpldPurchaseOrderHistory.CFinReplicatedPurchaseOrder AND CFinRpldPurchaseOrderItem = _CFinRpldPurchaseOrderHistory.CFinRpldPurchaseOrderItem  -- association [0..*]
LEFT OUTER JOIN C_CFinRpldPurOrdAcctAssgmt AS _CFinRpldPurOrdAcctAssgmt ON SenderLogicalSystem = _CFinRpldPurOrdAcctAssgmt.SenderLogicalSystem AND CFinReplicatedPurchaseOrder = _CFinRpldPurOrdAcctAssgmt.CFinReplicatedPurchaseOrder AND CFinRpldPurchaseOrderItem = _CFinRpldPurOrdAcctAssgmt.CFinRpldPurchaseOrderItem  -- association [0..*]
LEFT OUTER JOIN C_CFinRpldPurchaseOrderDetails AS _CFinRpldPurchaseOrderDetails ON SenderLogicalSystem = _CFinRpldPurchaseOrderDetails.SenderLogicalSystem AND CFinReplicatedPurchaseOrder = _CFinRpldPurchaseOrderDetails.CFinReplicatedPurchaseOrder AND CFinRpldPurchaseOrderItem = _CFinRpldPurchaseOrderDetails.CFinRpldPurchaseOrderItem  -- association [1..*]
LEFT OUTER JOIN I_AcctAssignmentCategoryText AS _AccountAssignmentCategoryText ON AccountAssignmentCategory = _AccountAssignmentCategoryText.AccountAssignmentCategory  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_PurgDocumentItemCategoryText AS _PurgDocumentItemCategoryText ON PurchasingDocumentItemCategory = _PurgDocumentItemCategoryText.PurchasingDocumentItemCategory  -- association [0..*]
LEFT OUTER JOIN I_PartialInvoiceIndicator AS _PartialInvoiceIndicator ON PartialInvoiceDistribution = _PartialInvoiceIndicator.PartialInvoiceDistribution AND _PartialInvoiceIndicator.SAPDataDictionaryDomain = 'TWRKZ'  -- association [0..1]
LEFT OUTER JOIN I_MultipleAcctAssgmtDistrText AS _MultipleAcctAssgmtDistrText ON MultipleAcctAssgmtDistribution = _MultipleAcctAssgmtDistrText.MultipleAcctAssgmtDistribution AND _MultipleAcctAssgmtDistrText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_TaxCodeText AS _TaxCodeText ON TaxCode = _TaxCodeText.TaxCode AND TaxCalculationProcedure = _TaxCodeText.TaxCalculationProcedure AND _TaxCodeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_TaxJurisdictionText AS _TaxJurisdictionText ON TaxJurisdiction = _TaxJurisdictionText.TaxJurisdiction AND _TaxJurisdictionText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN E_CFinRpldPurchasingDocItem AS _Extension ON CFinReplicatedPurchaseOrder = _Extension.CFinRpldPurchasingDocument AND SenderLogicalSystem = _Extension.SourceSystemLogicalSystem AND CFinRpldPurchaseOrderItem = _Extension.CFinRpldPurchasingDocumentItem  -- association [1..1]
;