C_ContractMaintainItem

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_ContractMaintainItem.
-- 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: CCTRMAINTAINITEM

CREATE VIEW C_ContractMaintainItem AS
SELECT
  I_PurchaseContractItemWD.PurchaseContractItem AS PurchaseContractItem,
  I_PurchaseContractItemWD.PurchaseContract AS PurchaseContract,
  _PurchaseContractWD.ActivePurchasingDocument AS ActivePurchasingDocument,
  I_PurchaseContractItemWD.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  I_PurchaseContractItemWD.PurchaseContractItemForEdit AS PurchaseContractItemForEdit,
  I_PurchaseContractItemWD.CompanyCode AS CompanyCode,
  PurchaseContractType,
  I_PurchaseContractItemWD.Material AS Material,
  I_PurchaseContractItemWD.PurchaseContractItemText AS PurchaseContractItemText,
  I_PurchaseContractItemWD.ContractNetPriceAmount AS ContractNetPriceAmount,
  I_PurchaseContractItemWD.OrderPriceUnit AS OrderPriceUnit,
  I_PurchaseContractItemWD.VolumeUnit AS VolumeUnit,
  I_PurchaseContractItemWD.OrderQuantityUnit AS OrderQuantityUnit,
  I_PurchaseContractItemWD.ReleaseOrderQuantityUnit AS ReleaseOrderQuantityUnit,
  I_PurchaseContractItemWD.MaterialGroup AS MaterialGroup,
  I_PurchaseContractItemWD.Customer AS Customer,
  I_PurchaseContractItemWD.Subcontractor AS Subcontractor,
  I_PurchaseContractItemWD.ReferenceDeliveryAddressID AS ReferenceDeliveryAddressID,
  I_PurchaseContractItemWD.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  I_PurchaseContractItemWD.Plant AS Plant,
  I_PurchaseContractItemWD.StorageLocation AS StorageLocation,
  I_PurchaseContractItemWD.AccountAssignmentCategory AS AccountAssignmentCategory,
  I_PurchaseContractItemWD.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  I_PurchaseContractItemWD.NetPriceQuantity AS NetPriceQuantity,
  I_PurchaseContractItemWD.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  I_PurchaseContractItemWD.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  I_PurchaseContractItemWD.TargetQuantity AS TargetQuantity,
  I_PurchaseContractItemWD.TargetAmount AS TargetAmount,
  I_PurchaseContractItemWD.DocumentCurrency AS DocumentCurrency,
  I_PurchaseContractItemWD.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  I_PurchaseContractItemWD.OrdPrcUnitToOrderUnitDnmntrUoM AS OrdPrcUnitToOrderUnitDnmntrUoM,
  I_PurchaseContractItemWD.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  I_PurchaseContractItemWD.OrdPrcUnitToOrderUnitNmrtrUoM AS OrdPrcUnitToOrderUnitNmrtrUoM,
  _PurchaseContractWD.PurchaseContractType AS PurchasingDocumentType,
  _PurchaseContractWD._Purchasecontracttype_Vh.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  I_PurchaseContractItemWD.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  I_PurchaseContractItemWD.PurgDocItemCategoryName AS PurgDocItemCategoryName,
  I_PurchaseContractItemWD.PurgDocExternalItemCategory AS PurgDocExternalItemCategory,
  I_PurchaseContractItemWD.SupplierMaterialNumber AS SupplierMaterialNumber,
  I_PurchaseContractItemWD.EvaldRcptSettlmtIsAllowed AS EvaldRcptSettlmtIsAllowed,
  I_PurchaseContractItemWD.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  I_PurchaseContractItemWD.PriceIsToBePrinted AS PriceIsToBePrinted,
  I_PurchaseContractItemWD.SupplierConfirmationControlKey AS SupplierConfirmationControlKey,
  I_PurchaseContractItemWD.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  I_PurchaseContractItemWD.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  IncotermsClassification,
  _PurchaseContractWD.IncotermsVersion AS IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation1Identifier,
  IncotermsSupChnLoc1AddlUUID,
  IncotermsLocation2,
  IncotermsLocation2Identifier,
  IncotermsSupChnLoc2AddlUUID,
  IncotermsDvtgLocDescription,
  IncotermsDvtgLocIdentifier,
  IncotermsSupChnDvtgLocAddlUUID,
  SupplierSubrange,
  I_PurchaseContractItemWD.InvoiceIsExpected AS InvoiceIsExpected,
  I_PurchaseContractItemWD.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  I_PurchaseContractItemWD.PurgDocPriceDate AS PurgDocPriceDate,
  I_PurchaseContractItemWD.IsInfoRecordUpdated AS IsInfoRecordUpdated,
  I_PurchaseContractItemWD.PurgDocReleaseOrderQuantity AS PurgDocReleaseOrderQuantity,
  I_PurchaseContractItemWD.PurgDocOrderAcknNumber AS PurgDocOrderAcknNumber,
  I_PurchaseContractItemWD.PurgDocEstimatedPrice AS PurgDocEstimatedPrice,
  I_PurchaseContractItemWD.IsInfoAtRegistration AS IsInfoAtRegistration,
  I_PurchaseContractItemWD.NoDaysReminder1 AS NoDaysReminder1,
  I_PurchaseContractItemWD.NoDaysReminder2 AS NoDaysReminder2,
  I_PurchaseContractItemWD.NoDaysReminder3 AS NoDaysReminder3,
  I_PurchaseContractItemWD.PlannedDeliveryDurationInDays AS PlannedDeliveryDurationInDays,
  I_PurchaseContractItemWD.StockType AS StockType,
  I_PurchaseContractItemWD.TaxCode AS TaxCode,
  I_PurchaseContractItemWD.TaxCountry AS TaxCountry,
  I_PurchaseContractItemWD.TaxDeterminationDate AS TaxDeterminationDate,
  I_PurchaseContractItemWD.RequirementTracking AS RequirementTracking,
  I_PurchaseContractItemWD.IsOrderAcknRqd AS IsOrderAcknRqd,
  I_PurchaseContractItemWD.ShippingInstruction AS ShippingInstruction,
  I_PurchaseContractItemWD.PurContractItmReplnmtElmntType AS PurContractItmReplnmtElmntType,
  I_PurchaseContractItemWD.IsToBeAcceptedAtOrigin AS IsToBeAcceptedAtOrigin,
  I_PurchaseContractItemWD.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  I_PurchaseContractItemWD.ServicePerformer AS ServicePerformer,
  I_PurchaseContractItemWD.MaterialType AS MaterialType,
  I_PurchaseContractItemWD.ProductType AS ProductType,
  _ContractPrdTypeVH.ProductTypeName AS ProductTypeName,
  I_PurchaseContractItemWD.FormattedPurchaseContractItem AS FormattedPurchaseContractItem,
  I_PurchaseContractItemWD.PurchasingContractDeletionCode AS PurchasingContractDeletionCode,
  OutlineAgrmtItmBlockedText,
  TextIsDeleted,
  I_PurchaseContractItemWD.PurchasingInfoRecord AS PurchasingInfoRecord,
  I_PurchaseContractItemWD.PurchasingParentItem AS PurchasingParentItem,
  I_PurchaseContractItemWD.PurchasingParentItemForEdit AS PurchasingParentItemForEdit,
  I_PurchaseContractItemWD.IsStatisticalItem AS IsStatisticalItem,
  I_PurchaseContractItemWD.PurgExternalSortNumber AS PurgExternalSortNumber,
  _PredictedDate.ContractExpiryPredictedDate AS ContractExpiryPredictedDate,
  _PurchaseContractWD.ValidityEndDate AS ValidityEndDate,
  _PurchaseContractWD.PurchasingOrganization AS PurchasingOrganization,
  PurchasingIsCatalogRelevant,
  I_PurchaseContractItemWD._Material AS _Material,
  I_PurchaseContractItemWD._OrderPriceUnit AS _OrderPriceUnit,
  I_PurchaseContractItemWD._OrderQuantityUnit AS _OrderQuantityUnit,
  I_PurchaseContractItemWD._Plant AS _Plant,
  I_PurchaseContractItemWD._VolumeUnit AS _VolumeUnit,
  I_PurchaseContractItemWD.HierarchyNode AS HierarchyNode,
  I_PurchaseContractItemWD.HierarchyParentNode AS HierarchyParentNode,
  I_PurchaseContractItemWD.HierarchyLevel AS HierarchyLevel,
  I_PurchaseContractItemWD.HierarchyNodeSubTreeSize AS HierarchyNodeSubTreeSize,
  I_PurchaseContractItemWD.HierarchyDrillState AS HierarchyDrillState,
  I_PurchaseContractItemWD.HierarchyNodeOrdinalNumber AS HierarchyNodeOrdinalNumber,
  I_PurchaseContractItemWD.IsOutline AS IsOutline,
  _PurContrAcctAssgmtCatVH.AcctAssignmentCategoryName AS AcctAssignmentCategoryName,
  _PurContractItmReplnmtElmntVH.KanbanStatusName AS KanbanStatusName,
  _InfoRecordUpdateCodeVH.PurchasingInfoRecordDesc AS PurchasingInfoRecordDesc,
  cast ('' as boolean) AS SrvcProcmtItmHierIsEnbld,
  _PurgProdCmplncSupplierStsT.PurgProdCmplncSupplierStsName AS PurgProdCmplncSupplierStsName,
  cast ('' as abap.char( 1 ) ) AS UICT_PurgProdCmplncSupplierSts,
  cast ('' as boolean) AS ProductComplianceIsActive,
  cast ('' as ehfnd_bf_pcs_is_active) AS BusFtreProdCmplncSuplrIsActive,
  _PurchaseContractWD.PurgDocIsChgVers AS PurgDocIsChgVers,
  _PurContrItmCnsmpnPercentage.ContractConsumptionInPct AS ContractConsumptionInPct,
  _Plant.PlantName AS PlantName,
  _PurchaseContractWD.Supplier AS Supplier
FROM I_PurchaseContractItemWD
LEFT OUTER JOIN I_QuantityContractPrediction AS _PredictedDate ON PurchaseContract = _PredictedDate.PurchaseContract AND PurchaseContractItem = _PredictedDate.PurchaseContractItem  -- association [1..1]
LEFT OUTER JOIN C_ContractMaintain AS _PurchaseContractWD ON PurchaseContract = _PurchaseContractWD.PurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_Purctraccassign AS _PurCtrAccountWD ON PurchaseContractItem = _PurCtrAccountWD.PurchaseContractItem AND PurchaseContract = _PurCtrAccountWD.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN C_PurCtrItemAddress AS _PurCtrAddressWD ON PurchaseContract = _PurCtrAddressWD.PurchaseContract AND PurchaseContractItem = _PurCtrAddressWD.PurchaseContractItem  -- association [1..1]
LEFT OUTER JOIN C_Contracthistory AS _ContractHistory ON PurchaseContractItem = _ContractHistory.PurchaseContractItem AND PurchaseContract = _ContractHistory.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN C_PurCtrItemnotes AS _PurctritnotesWD ON PurchaseContractItem = _PurctritnotesWD.PurchaseContractItem AND PurchaseContract = _PurctritnotesWD.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN I_Purcontracttaxcodevh AS _Purcontracttaxcodevh ON TaxCode = _Purcontracttaxcodevh.TaxCode  -- association [1..*]
LEFT OUTER JOIN C_ContractPrdTypeVH AS _ContractPrdTypeVH ON ProductType = _ContractPrdTypeVH.ProductType  -- association [0..1]
LEFT OUTER JOIN C_MM_ServicePerformerValueHelp AS _ServicePerformerVH ON ServicePerformer = _ServicePerformerVH.ServicePerformer  -- association [0..*]
LEFT OUTER JOIN C_Mm_Shipinstructionvaluehelp AS _ShipInstrVH ON ShippingInstruction = _ShipInstrVH.ShippingInstruction  -- association [0..1]
LEFT OUTER JOIN C_MM_PlantValueHelp AS _PlantValueHelp ON _PlantValueHelp.Plant = Plant AND _PlantValueHelp.PurchasingOrganization = purchasingorganization  -- association [0..1]
LEFT OUTER JOIN I_Contrconfirmationcontrol AS _Purcontractcnfrmctrlvh ON SupplierConfirmationControlKey = _Purcontractcnfrmctrlvh.SupplierConfirmationControlKey  -- association [1..1]
LEFT OUTER JOIN I_PurCtrStockType AS _PurCtrStockType ON StockType = _PurCtrStockType.StockType  -- association [1..1]
LEFT OUTER JOIN C_MultiAcctgDistrIndValueAdjVH AS _MltplAcctAssgmtDistrVH ON MultipleAcctAssgmtDistribution = _MltplAcctAssgmtDistrVH.MultipleAcctAssgmtDistribution  -- association [0..1]
LEFT OUTER JOIN C_PartialInvoiceIndVH AS _PartialInvoiceIndVH ON PartialInvoiceDistribution = _PartialInvoiceIndVH.PartialInvoiceDistribution  -- association [0..1]
LEFT OUTER JOIN C_PartialGoodsReceiptIndVH AS _PartialGoodsReceiptIndVH ON PartialInvoiceDistribution = _PartialGoodsReceiptIndVH.PartialInvoiceDistribution  -- association [0..1]
LEFT OUTER JOIN C_MM_MaterialGroupValueHelp AS _MaterialGroupValueHelp ON MaterialGroup = _MaterialGroupValueHelp.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN C_PurContractItmReplnmtElmntVH AS _PurContractItmReplnmtElmntVH ON PurContractItmReplnmtElmntType = _PurContractItmReplnmtElmntVH.PurContractItmReplnmtElmntType  -- association [0..1]
LEFT OUTER JOIN C_PurgInfoRecordUpdateCodeVH AS _InfoRecordUpdateCodeVH ON IsInfoRecordUpdated = _InfoRecordUpdateCodeVH.PurchasingInfoRecordUpdateCode AND _InfoRecordUpdateCodeVH.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_SourceOfSupply AS _SourceOfSupply ON PurchaseContract = _SourceOfSupply.PurchaseContract AND PurchaseContractItem = _SourceOfSupply.PurchaseContractItem AND Material = _SourceOfSupply.Material AND Plant = _SourceOfSupply.Plant AND Material <> ''  -- association [0..*]
LEFT OUTER JOIN C_PurContrItemCategoryVH AS _PurContrItemCategoryVH ON PurchasingDocumentItemCategory = _PurContrItemCategoryVH.PurchasingDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN C_PurContrAcctAssgmtCatVH AS _PurContrAcctAssgmtCatVH ON AccountAssignmentCategory = _PurContrAcctAssgmtCatVH.AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN C_PurContrItmCndnValdtyTP AS _PurContrItmCndnValdtyTP ON PurchaseContract = _PurContrItmCndnValdtyTP.PurchaseContract AND PurchaseContractItem = _PurContrItmCndnValdtyTP.PurchaseContractItem  -- association [0..*]
LEFT OUTER JOIN I_PurgProdCmplncSupplierStsT AS _PurgProdCmplncSupplierStsT ON PurgProdCmplncSupplierStatus = _PurgProdCmplncSupplierStsT.PurgProdCmplncSupplierStatus AND _PurgProdCmplncSupplierStsT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurContrItmCnsmpnPercentage AS _PurContrItmCnsmpnPercentage ON PurchaseContract = _PurContrItmCnsmpnPercentage.PurchaseContract AND PurchaseContractItem = _PurContrItmCnsmpnPercentage.PurchaseContractItem  -- association [1..1]
LEFT OUTER JOIN I_SupplierSubrange AS _SupplierSubrange ON SupplierSubrange = _SupplierSubrange.SupplierSubrange  -- association [0..*]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
;