C_PPS_PurReqnItemHierarchyTP_2

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_PPS_PurReqnItemHierarchyTP_2.
-- 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_PPS_PurReqnItemHierarchyTP_2 AS
SELECT
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurchasingDocument,
  cast( PurReqnReleaseStatus as pps_e_releasestatus preserving type ) AS PurReqnReleaseStatus,
  ExternalApprovalStatus,
  PurchaseRequisitionType,
  PurchasingDocumentSubtype,
  PurchasingDocumentItemCategory AS PurchasingDocHierItemCategory,
  PurchasingDocumentItemCategory,
  cast( PurgDocExternalItemCategory as pps_e_extitemcategory preserving type ) AS PurgDocExternalItemCategory,
  _PurgDocumentItemCategoryText.PurgDocItemCategoryName AS PurgDocItemCategoryName,
  PurchaseRequisitionItemText,
  AccountAssignmentCategory,
  _AcctAssgmtCategoryVH.AcctAssignmentCategoryName : localized AS AcctAssignmentCategoryNamelocalized,
  Material,
  _MaterialText.MaterialName AS MaterialName,
  MaterialType,
  MaterialGroup,
  PPSPurReqnItemProcessingStatus,
  _ItmProcgStatusText.PPSPurReqnItemProcgStatusText : localized AS PPSPurReqnItemProcgStatusTextlocalized,
  _MaterialGroupText.MaterialGroupName AS MaterialGroupName,
  PurchasingDocumentCategory,
  RequestedQuantity,
  BaseUnit,
  BaseUnit AS ItemUoM,
  cast( PurchaseRequisitionPrice as pps_e_price preserving type ) AS PurchaseRequisitionPrice,
  PurReqnPriceQuantity,
  cast(MaterialGoodsReceiptDuration as pps_e_webaz preserving type ) AS MaterialGoodsReceiptDuration,
  ReleaseCode,
  PurchaseRequisitionReleaseDate,
  PurchasingOrganization,
  _PurchasingOrgVH.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  _PurchasingGroupVH.PurchasingGroupName AS PurchasingGroupName,
  Plant,
  SourceOfSupplyIsAssigned,
  OrderedQuantity,
  PurReqnLimitConsumptionAmt,
  DeliveryDate,
  cast( CreationDate as pps_e_creationdate preserving type ) AS CreationDate,
  ProcessingStatus,
  PurchasingInfoRecord,
  Supplier,
  _DesiredSupplier.SupplierName AS SupplierName,
  IsDeleted,
  cast ( FixedSupplier as pps_e_fixedsupplier preserving type ) AS FixedSupplier,
  cast ( _Supplier.SupplierName as pps_e_fixedsupplier_name preserving type ) AS FixedSupplierName,
  SourceDocument,
  PurchasingSourceType,
  _PurchaseReqnSourceType.PurchasingSourceTypeDesc AS PurchasingSourceTypeDesc,
  LastChangedDate,
  RequisitionerName,
  CreatedByUser,
  PurReqCreationDate,
  PurReqnItemCurrency,
  PurReqnLmtConsumptionCurrency,
  MaterialPlannedDeliveryDurn,
  MultipleAcctAssgmtDistribution,
  _MultipleAcctAssgmtDistrText.MultipleAcctAssgmtDistrName AS MultipleAcctAssgmtDistrName,
  PartialInvoiceDistribution,
  _PartialInvoiceIndicator.PartialInvoiceDistributionName : localized AS PartialInvoiceDistributionNamelocalized,
  StorageLocation,
  _StorLocVH.StorageLocationName AS StorageLocationName,
  PurchaseContract,
  _PurchasingDocument.PurchasingDocumentName AS PurchasingDocumentName,
  PurReqnSourceOfSupplyType,
  PurchaseContractItem,
  PurReqnOrigin,
  _ModeOfCreationText.PurReqnOriginDesc AS PurReqnOriginDesc,
  Language,
  IsClosed,
  ReleaseIsNotCompleted,
  ServicePerformer,
  _ServicePerformer.BusinessPartnerName AS ServicePerformerName,
  ProductTypeCode,
  _ProductTypeCodeText.Name as ProductTypeName : localized AS NameasProductTypeNamelocalized,
  PurchaseRequisitionStatus,
  ReleaseStrategy,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  SupplierMaterialNumber,
  Currency,
  ItemNetAmount,
  GoodsReceiptIsExpected,
  InvoiceIsExpected,
  GoodsReceiptIsNonValuated,
  RequirementTracking,
  TaxCode,
  _PurReqnTaxCodeVH.TaxCodeName : localized AS TaxCodeNamelocalized,
  TaxCalculationProcedure,
  PurchaseRequisitionIsFixed,
  cast( PurReqnCatalog as pps_e_purreqncatalog preserving type ) AS PurReqnCatalog,
  PurReqnCatalogItem,
  PurReqnCrossCatalogItem,
  PurchaseReqnItemUniqueID,
  IsPurReqnOvrlRel,
  ExpectedOverallLimitAmount,
  OverallLimitAmount,
  GLAccount,
  EarmarkedFundsDocument,
  FundsCenter,
  _FundsCenterText.FundsCenterDescription : localized AS FundsCenterDescriptionlocalized,
  Fund,
  _FundText.FundDescription : localized AS FundDescriptionlocalized,
  CommitmentItem,
  _CommitmentItemText.CommitmentItemDescription : localized AS CommitmentItemDescriptionlocalized,
  EarmarkedFundsDocumentItem,
  GrantID,
  _GrantText.GrantName AS GrantName,
  FunctionalArea,
  _FndsMgmtFuncnlAreaText.FunctionalAreaName : localized AS FunctionalAreaNamelocalized
FROM R_PPS_PurchaseReqnItemTP
LEFT OUTER JOIN C_PPS_PurReqnItemVersion AS _PurchaseReqnItemVersion ON PurchaseRequisition = _PurchaseReqnItemVersion.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseReqnItemVersion.PurchaseRequisitionItem  -- association [0..*]
LEFT OUTER JOIN C_PPS_PurReqnItemChangeLog AS _PurchaseReqnItemChangeLog ON PurchaseRequisition = _PurchaseReqnItemChangeLog.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseReqnItemChangeLog.PurchaseRequisitionItem  -- association [0..*]
LEFT OUTER JOIN C_PPS_EarmarkedFundsDocumentVH AS _EarmarkedFundsVH ON PurchaseContract = _EarmarkedFundsVH.PurchaseContract AND PurchaseContractItem = _EarmarkedFundsVH.PurchaseContractItem  -- association [0..*]
;