C_PurOrdMaintainItem

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_PurOrdMaintainItem.
-- 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.
-- SQL view name: CPOMAINTITM

CREATE VIEW C_PurOrdMaintainItem AS
SELECT
  ID,
  PurchaseOrderItemDraftUUID,
  PurchaseOrderHeaderDraftUUID,
  PurchaseOrder,
  PurchaseOrderItem,
  ParentId,
  PurchasingDocumentItemText,
  Material,
  MaterialType,
  ProductType,
  MaterialGroup,
  Plant,
  PlantName,
  StorageLocation,
  StorageLocationName,
  PurchaseOrderQuantityUnit,
  PurchaseOrderQty,
  PurchaseOrderNetPriceAmount,
  PurchaseOrderNetAmount,
  Currency,
  NetPriceIsDerived,
  PurOrderEffectiveItemAmount,
  PurchaseOrderNetPriceQuantity,
  PurchaseOrderPriceUnit,
  Customer,
  _CustomerName.CustomerName AS CustomerName,
  ServicePerformer,
  ServicePerformerName,
  TaxCode,
  TaxJurisdiction,
  GoodsReceiptIsExpected,
  GoodsReceiptIsNonValuated,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  OverdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  UnderdelivTolrtdLmtRatioInPct,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  RefPurOrderInfoRecord,
  RefPurchaseOutlineAgreement,
  RefPurchOutlineAgrmtItem,
  PurchaseOrderItemCategory,
  PurgDocExternalItemCategory,
  AcctAssignmentCategory,
  IsDeleted,
  ControllingArea,
  CostCenter,
  ProfitCenter,
  WBSElementInternalID,
  _Purordmaintaincustproj.CustomerProjectName AS CustomerProjectName,
  _Purordmaintaincustproj.CustProjWorkPackageName AS CustProjWorkPackageName,
  FunctionalArea,
  SalesOrder,
  SalesOrderItem,
  GLAccount,
  FreeTextInput,
  DeliveryDate,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  ManualDeliveryAddressID,
  DeliveryAddressName,
  DeliveryAddressStreetName,
  DeliveryAddressHouseNumber,
  DeliveryAddressPostalCode,
  DeliveryAddressCityName,
  DeliveryAddressRegion,
  DeliveryAddressCountry,
  SupplierMaterialNumber,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  IsCompletelyDelivered,
  IsFinallyInvoiced,
  TaxCalculationProcedure,
  TaxJurisdictionCalcProcedure,
  PricingProcedure,
  PurchasingDocumentType,
  PurchasingOrganization,
  PurchasingGroup,
  Supplier,
  EditState,
  IsDraft,
  IsActiveEntity,
  HasTwin,
  CreatedByUser,
  LastChangeUser,
  LastChangeDateTime,
  TwinPurchaseOrderItemDraftUUID,
  ServicePackage,
  OverallLimitAmount,
  OverallLimitAmountIsUnlimited,
  ExpectedOverallLimitAmount
FROM P_PurOrdMaintainItemAll AS PurchaseOrderItems
LEFT OUTER JOIN E_PurchasingDocumentItem AS _PurDocItemExtension ON PurchaseOrder = _PurDocItemExtension.PurchasingDocument AND PurchaseOrderItem = _PurDocItemExtension.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocumentItemDraft AS _PurDocItemDraftExtension ON PurchaseOrderItemDraftUUID = _PurDocItemDraftExtension.PurchaseOrderItemDraftUUID  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncotermsClassificationText ON IncotermsClassification = _IncotermsClassificationText.IncotermsClassification  -- association [0..*]
LEFT OUTER JOIN I_IncotermsVersionText AS _IncotermsVersionText ON IncotermsVersion = _IncotermsVersionText.IncotermsVersion  -- association [0..*]
LEFT OUTER JOIN I_CountryText AS _CountryText ON DeliveryAddressCountry = _CountryText.Country  -- association [0..*]
LEFT OUTER JOIN I_AcctAssignmentCategoryText AS _AcctAssignmentCategoryText ON AcctAssignmentCategory = _AcctAssignmentCategoryText.AccountAssignmentCategory  -- association [0..*]
LEFT OUTER JOIN I_PurgDocumentItemCategoryText AS _ItemCategoryText ON PurchaseOrderItemCategory = _ItemCategoryText.PurchasingDocumentItemCategory  -- association [0..*]
LEFT OUTER JOIN I_RegionText AS _RegionText ON DeliveryAddressRegion = _RegionText.Region AND DeliveryAddressCountry = _RegionText.Country  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _QuantityUnit ON PurchaseOrderQuantityUnit = _QuantityUnit.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _OrderPriceUnit ON PurchaseOrderPriceUnit = _OrderPriceUnit.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_ProductTypeCodeText AS _ProductTypeText ON ProductType = _ProductTypeText.ProductTypeCode  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _CustomerName ON Customer = _CustomerName.Customer  -- association [0..1]
LEFT OUTER JOIN P_Purordmaintaincustproj AS _Purordmaintaincustproj ON WBSElementInternalID = _Purordmaintaincustproj.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_TaxCodeText AS _TaxCodeText ON TaxCalculationProcedure = _TaxCodeText.TaxCalculationProcedure AND TaxCode = _TaxCodeText.TaxCode  -- association [0..*]
LEFT OUTER JOIN I_TaxJurisdictionText AS _TaxJurisdictionText ON TaxJurisdictionCalcProcedure = _TaxJurisdictionText.TaxJurisdictionCalcProcedure AND TaxJurisdiction = _TaxJurisdictionText.TaxJurisdiction  -- association [0..*]
LEFT OUTER JOIN C_PurOrdMaintainItem AS _PurOrdMaintainItem ON PurchaseOrder = _PurOrdMaintainItem.PurchaseOrder AND PurchaseOrderItem = _PurOrdMaintainItem.PurchaseOrderItem AND PurchaseOrderHeaderDraftUUID = _PurOrdMaintainItem.PurchaseOrderHeaderDraftUUID AND PurchaseOrderItemDraftUUID = _PurOrdMaintainItem.PurchaseOrderItemDraftUUID  -- association [0..*]
;