R_CFinRpldPurchasingDocItem

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_CFinRpldPurchasingDocItem.
-- 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_CFinRpldPurchasingDocItem AS
SELECT
  db_key AS CFinRpldPurchasingDocItemUUID,
  parent_key AS CFinRpldPurchasingDocUUID,
  fins_logsys AS SourceSystemLogicalSystem,
  cast( ebeln as fins_cfin_av_purchasing_doc preserving type ) AS CFinRpldPurchasingDocument,
  cast( ebelp as fins_cfin_av_purg_document_itm preserving type ) AS CFinRpldPurchasingDocumentItem,
  loekz AS PurchasingDocumentDeletionCode,
  txz01 AS PurchasingDocumentItemText,
  matnr AS Material,
  bukrs AS CompanyCode,
  werks AS Plant,
  matkl AS MaterialGroup,
  ktmng AS TargetQuantity,
  menge AS OrderQuantity,
  meins AS OrderQuantityUnit,
  bprme AS OrderPriceUnit,
  bpumz AS OrderPriceUnitToOrderUnitNmrtr,
  bpumn AS OrdPriceUnitToOrderUnitDnmntr,
  umrez AS OrderItemQtyToBaseQtyNmrtr,
  umren AS OrderItemQtyToBaseQtyDnmntr,
  netpr AS NetPriceAmount,
  cast (peinh as vdm_price_unit preserving type) AS NetPriceQuantity,
  netwr AS NetAmount,
  mwskz AS TaxCode,
  bwtar AS ValuationType,
  elikz AS IsCompletelyDelivered,
  erekz AS IsFinallyInvoiced,
  pstyp AS PurchasingDocumentItemCategory,
  knttp AS AccountAssignmentCategory,
  kzvbr AS ConsumptionPosting,
  vrtkz AS MultipleAcctAssgmtDistribution,
  twrkz AS PartialInvoiceDistribution,
  wepos AS GoodsReceiptIsExpected,
  weunb AS GoodsReceiptIsNonValuated,
  repos AS InvoiceIsExpected,
  webre AS InvoiceIsGoodsReceiptBased,
  lmein AS BaseUnit,
  navnw AS NonDeductibleInputTaxAmount,
  bstyp AS PurchasingDocumentCategory,
  xoblr AS PurReqnItemIsCmtmtRelevant,
  txjcd AS TaxJurisdiction,
  sobkz AS InventorySpecialStockType,
  geber AS Fund,
  fistl AS FundsCenter,
  cast(fipos as bbp_bapi_fipos preserving type) AS CommitmentItemShortID,
  ko_prctr AS ProfitCenter,
  ko_gsber AS PartnerReportedBusinessArea,
  packno AS ServicePackage,
  stapo AS IsStatisticalItem,
  xersy AS EvaldRcptSettlmtIsAllowed,
  mtart AS MaterialType,
  retpo AS IsReturnsItem,
  grant_nbr AS GrantID,
  fkber AS FunctionalArea,
  budget_pd AS BudgetPeriod,
  producttype AS ProductTypeCode,
  afnam AS RequisitionerName,
  _CFinRpldPurchasingDocument.DocumentCurrency AS DocumentCurrency,
  aedat AS LastChangedDate,
  lebre AS InvoiceIsMMServiceEntryBased,
  kzbws AS InventorySpecialStockValnType,
  ccomp AS PurchasingDocCompletionStatus,
  srv_bas_com AS PurgDocItemIsServiceBsdCmtmt,
  txdat_from AS TimeDependentTaxValidFromDate,
  tax_country AS UnplndDeliveryCostTaxCountry,
  bukrs_sender AS SenderCompanyCode
FROM cfin_av_po_item
LEFT OUTER JOIN R_CFinRpldPurchasingDocument AS _CFinRpldPurchasingDocument ON CFinRpldPurchasingDocUUID = _CFinRpldPurchasingDocument.CFinRpldPurchasingDocUUID  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderQuantityUnit ON OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderPriceUnit ON OrderPriceUnit = _OrderPriceUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON DocumentCurrency = _DocumentCurrency.Currency  -- association [0..1]
;