C_PPS_PurContractItemHierTP_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_PurContractItemHierTP_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_PurContractItemHierTP_2 AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  PurchaseContractItemUniqueID,
  PurgConfigurableItemNumber,
  CompanyCode,
  Material,
  ManufacturerMaterial,
  _MaterialText[1:Language = $session.system_language].MaterialName AS MaterialName,
  PPSPricingArrangementType,
  PurchaseContractItemText,
  ContractNetPriceAmount,
  NetPriceQuantity,
  OrderPriceUnit,
  VolumeUnit,
  OrderQuantityUnit,
  MaterialGroup,
  _MaterialGroupText[1: Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  Customer,
  Subcontractor,
  ReferenceDeliveryAddressID,
  DeliveryAddressID,
  Plant,
  _Plant.PlantName AS PlantName,
  StorageLocation,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  AccountAssignmentCategory,
  _AcctAssgmtCategoryText.AcctAssignmentCategoryName : localized AS AcctAssignmentCategoryNamelocalized,
  GoodsReceiptIsExpected,
  ActivePurchasingDocument,
  cast( PPS_PurchaseContractItem.TargetSAPObjectNodeType as pps_e_sap_obj_nde_type preserving type ) AS TargetSAPObjectNodeType,
  MultipleAcctAssgmtDistribution,
  _MultipleAcctAssgmtDistrText[1:Language = $session.system_language].MultipleAcctAssgmtDistrName AS MultipleAcctAssgmtDistrName,
  virtual AcctAssgmtUndistributedQty : menge_d AS virtualAcctAssgmtUndistributedQtymenge_d,
  virtual AcctAssgmtUndistributedAmt : bwert AS virtualAcctAssgmtUndistributedAmtbwert,
  virtual AcctAssgmtUndistributedPct : vproz AS virtualAcctAssgmtUndistributedPctvproz,
  virtual UICT_AcctAssgmtUndistriQty : boolean AS virtualUICT_AcctAssgmtUndistriQtyboolean,
  virtual UICT_AcctAssgmtUndistriAmt : boolean AS virtualUICT_AcctAssgmtUndistriAmtboolean,
  virtual UICT_AcctAssgmtUndistriPct : boolean AS virtualUICT_AcctAssgmtUndistriPctboolean,
  virtual UICT_PricingIsHidden : boolean AS virtualUICT_PricingIsHiddenboolean,
  virtual UICT_PACeilingAmount : boolean AS virtualUICT_PACeilingAmountboolean,
  virtual UICT_PAMaximumFees : boolean AS virtualUICT_PAMaximumFeesboolean,
  virtual UICT_PAMinimumFees : boolean AS virtualUICT_PAMinimumFeesboolean,
  virtual UICT_PAGovtShareAbove : boolean AS virtualUICT_PAGovtShareAboveboolean,
  virtual UICT_PAGovtShareBelow : boolean AS virtualUICT_PAGovtShareBelowboolean,
  virtual UICT_PAVALUESISNOTENABLED : boolean AS virtualUICT_PAVALUESISNOTENABLEDboolean,
  virtual UICT_PASHARESISNOTENABLED : boolean AS virtualUICT_PASHARESISNOTENABLEDboolean,
  virtual UICT_HideMaterial : boolean AS virtualUICT_HideMaterialboolean,
  virtual UICT_DOCheckbox : boolean AS virtualUICT_DOCheckboxboolean,
  TargetQuantity,
  TargetAmount,
  DocumentCurrency,
  OrdPriceUnitToOrderUnitDnmntr,
  OrderPriceUnitToOrderUnitNmrtr,
  PurchasingDocumentItemCategory,
  PurgDocExternalItemCategory,
  _PurgDocumentItemCategoryText.PurgDocItemCategoryName AS PurgDocItemCategoryName,
  SupplierMaterialNumber,
  EvaldRcptSettlmtIsAllowed,
  UnderdelivTolrtdLmtRatioInPct,
  PriceIsToBePrinted,
  SupplierConfirmationControlKey,
  OverdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  PurgDocPriceDate,
  PurchasingInfoRecordUpdateCode,
  PurgDocReleaseOrderQuantity,
  PurgDocOrderAcknNumber,
  PurchasingPriceIsEstimated,
  IsInfoAtRegistration,
  NoDaysReminder1,
  NoDaysReminder2,
  NoDaysReminder3,
  TaxCode,
  _TaxCodeText[ 1: Language = $session.system_language ].TaxCodeName AS TaxCodeName,
  TaxCalculationProcedure,
  TaxCountry,
  TaxDeterminationDate,
  RequirementTracking,
  IsOrderAcknRqd,
  ShippingInstruction,
  GoodsReceiptIsNonValuated,
  ServicePerformer,
  _ServicePerformer.BusinessPartnerName AS ServicePerformerName,
  ProductTypeCode,
  _ProductTypeCodeText.Name AS ProductTypeName,
  MaterialType,
  PurchaseContractItemFormatted,
  PurchasingContractDeletionCode,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PartialInvoiceDistribution,
  _PartialInvoiceIndicator.PartialInvoiceDistributionName AS PartialInvoiceDistributionName,
  ManufacturerPartNmbr,
  Manufacturer,
  PurchasingCategory,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurgCatName AS PurgCatName,
  PurchaseContractType,
  PurchasingOrganization,
  PurchasingGroup,
  PurgProdCmplncSupplierStatus,
  PurchasingIsCatalogRelevant,
  LastChangeDateTime,
  PlannedDeliveryDurationInDays,
  PPSPerdOfPerfStartDate,
  PPSPerdOfPerfEndDate,
  PPSSmartNumberItem,
  PPSSmartNumberItemIsManual,
  PPSDeliveryToleranceKey,
  IsDeleted,
  PPSPurContractItemIsBlocked,
  IncotermsClassification,
  _IncotermsClassificationText.IncotermsClassificationName : localized AS IncotermsClassificationNamelocalized,
  IncotermsLocation1,
  IsToBeAcceptedAtOrigin,
  virtual UICT_HideAcceptAtOrigin : boolean AS virtualUICT_HideAcceptAtOriginboolean,
  PurchasingParentItem,
  IsOutline,
  PurgExternalSortNumber,
  PurchasingDocumentCategory,
  PurchasingHierarchyNode,
  HierarchyParentNode,
  HierarchyLevel,
  HierarchyNodeSubTreeSize,
  HierarchyDrillState,
  HierarchyNodeOrdinalNumber,
  PurContrConsumptionUnit
FROM R_PPS_PurchaseContractItemTP
LEFT OUTER JOIN C_PPS_PurgDocTolKeyQuickView AS _ToleranceKey ON PPSDeliveryToleranceKey = _ToleranceKey.PPSDeliveryToleranceKey  -- association [0..1]
LEFT OUTER JOIN C_PPS_PurContrDocHistoryC AS _DocHistory ON ActivePurchasingDocument = _DocHistory.PurchaseContract AND PurchaseContractItem = _DocHistory.PurchaseContractItem  -- association [0..*]
;