I_PurchaseContractItemWD

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 I_PurchaseContractItemWD.
-- 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: IPURCHASECT000WD

CREATE VIEW I_PurchaseContractItemWD AS
SELECT
  Document.PurchaseContractItem AS PurchaseContractItem,
  Document.PurchaseContract AS PurchaseContract,
  Document.PurchaseContractItem AS PurchaseContractItemForEdit,
  Document.CompanyCode AS CompanyCode,
  Document.PurchaseContractType AS PurchaseContractType,
  Document.Material AS Material,
  Document.PurchaseContractItemText AS PurchaseContractItemText,
  Document.ContractNetPriceAmount AS ContractNetPriceAmount,
  Document.OrderPriceUnit AS OrderPriceUnit,
  Document.VolumeUnit AS VolumeUnit,
  Document.OrderQuantityUnit AS OrderQuantityUnit,
  Document.MaterialGroup AS MaterialGroup,
  Document.Customer AS Customer,
  Document.Subcontractor AS Subcontractor,
  Document.ReferenceDeliveryAddressID AS ReferenceDeliveryAddressID,
  Document.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  Document.Plant AS Plant,
  Document.StorageLocation AS StorageLocation,
  Document.AccountAssignmentCategory AS AccountAssignmentCategory,
  Document.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  Document.IsToBeAcceptedAtOrigin AS IsToBeAcceptedAtOrigin,
  Document.NetPriceQuantity AS NetPriceQuantity,
  Document.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  Document.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  Document.TargetQuantity AS TargetQuantity,
  Document.TargetAmount AS TargetAmount,
  Document.DocumentCurrency AS DocumentCurrency,
  Document.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  Document.OrderQuantityUnit AS OrdPrcUnitToOrderUnitDnmntrUoM,
  Document.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  Document.OrderPriceUnit AS OrdPrcUnitToOrderUnitNmrtrUoM,
  Document.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  Document.SupplierMaterialNumber AS SupplierMaterialNumber,
  Document.EvaldRcptSettlmtIsAllowed AS EvaldRcptSettlmtIsAllowed,
  Document.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  Document.PriceIsToBePrinted AS PriceIsToBePrinted,
  Document.ConfirmationControl AS ConfirmationControl,
  Document.ConfirmationControl AS SupplierConfirmationControlKey,
  Document.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  Document.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  Document.IncotermsClassification AS IncotermsClassification,
  Document.IncotermsLocation1 AS IncotermsLocation1,
  Document.IncotermsLocation2 AS IncotermsLocation2,
  cast( ' ' as tminco_loc_1_id ) AS IncotermsLocation1Identifier,
  cast( ' ' as tminco_loc_2_id ) AS IncotermsLocation2Identifier,
  cast( ' ' as tminco_loc_d_id ) AS IncotermsDvtgLocIdentifier,
  cast( ' ' as tminco_loc_d_descr ) AS IncotermsDvtgLocDescription,
  Document.IncotermsSupChnLoc1AddlUUID AS IncotermsSupChnLoc1AddlUUID,
  Document.IncotermsSupChnLoc2AddlUUID AS IncotermsSupChnLoc2AddlUUID,
  Document.IncotermsSupChnDvtgLocAddlUUID AS IncotermsSupChnDvtgLocAddlUUID,
  Document.InvoiceIsExpected AS InvoiceIsExpected,
  Document.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  Document.PurgDocPriceDate AS PurgDocPriceDate,
  Document.IsInfoRecordUpdated AS IsInfoRecordUpdated,
  Document.SupplierSubrange AS SupplierSubrange,
  Document.PurchasingInfoRecord AS PurchasingInfoRecord,
  Document.OrderQuantityUnit AS ReleaseOrderQuantityUnit,
  Document.PurgDocReleaseOrderQuantity AS PurgDocReleaseOrderQuantity,
  Document.PurgDocOrderAcknNumber AS PurgDocOrderAcknNumber,
  Document.PurgDocEstimatedPrice AS PurgDocEstimatedPrice,
  Document.IsInfoAtRegistration AS IsInfoAtRegistration,
  Document.NoDaysReminder1 AS NoDaysReminder1,
  Document.NoDaysReminder2 AS NoDaysReminder2,
  Document.NoDaysReminder3 AS NoDaysReminder3,
  Document.PlannedDeliveryDurationInDays AS PlannedDeliveryDurationInDays,
  Document.StockType AS StockType,
  Document.TaxCode AS TaxCode,
  Document.TaxCountry AS TaxCountry,
  Document.TaxDeterminationDate AS TaxDeterminationDate,
  Document.RequirementTracking AS RequirementTracking,
  Document.IsOrderAcknRqd AS IsOrderAcknRqd,
  Document.ShippingInstruction AS ShippingInstruction,
  Document.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  Document.ServicePerformer AS ServicePerformer,
  Document.ProductType AS ProductType,
  Document.MaterialType AS MaterialType,
  Document.FormattedPurchaseContractItem AS FormattedPurchaseContractItem,
  Document.PurchaseContractItemFormatted AS PurchaseContractItemFormatted,
  Document.PurchaseRequisition AS PurchaseRequisition,
  Document.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  Document.PurchasingContractDeletionCode AS PurchasingContractDeletionCode,
  Document.PurContractItmReplnmtElmntType AS PurContractItmReplnmtElmntType,
  Document.PurchasingParentItem AS PurchasingParentItem,
  Document.IsStatisticalItem AS IsStatisticalItem,
  Document.PurchasingParentItem AS PurchasingParentItemForEdit,
  cast( '' as rsnodeext ) AS HierarchyNode,
  cast( '' as rsnodeext ) AS HierarchyParentNode,
  cast( 0 as abap.int4 ) AS HierarchyLevel,
  cast(0 as abap.int4 ) AS HierarchyNodeSubTreeSize,
  cast( '' as abap.sstr(20) ) AS HierarchyDrillState,
  cast( 0 as abap.int8 ) AS HierarchyNodeOrdinalNumber,
  Document.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  Document.PurgDocAggrgdSubitemCategory AS PurgDocAggrgdSubitemCategory,
  Document.PurgExternalSortNumber AS PurgExternalSortNumber,
  Document.PurgProdCmplncSupplierStatus AS PurgProdCmplncSupplierStatus,
  Document.PurchasingIsCatalogRelevant AS PurchasingIsCatalogRelevant,
  _PurgDocumentItemCategoryText.PurgDocExternalItemCategory AS PurgDocExternalItemCategory,
  _PurgDocumentItemCategoryText.PurgDocItemCategoryName AS PurgDocItemCategoryName
FROM I_PurchaseContractItem AS Document
LEFT OUTER JOIN I_PurchaseContractWD AS _PurchaseContractWD ON _PurchaseContractWD.PurchaseContract = PurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_PurCtrAccountWD AS _PurCtrAccountWD ON _PurCtrAccountWD.PurchaseContractItem = PurchaseContractItem AND _PurCtrAccountWD.PurchaseContract = PurchaseContract  -- association [1..*]
LEFT OUTER JOIN I_PurCtrAddressWD AS _PurCtrAddressWD ON PurchaseContractItem = _PurCtrAddressWD.PurchaseContractItem AND PurchaseContract = _PurCtrAddressWD.PurchaseContract  -- association [1..1]
LEFT OUTER JOIN E_PurchasingDocumentItem AS _PurchaseContractItemExtension ON PurchaseContract = _PurchaseContractItemExtension.PurchasingDocument AND PurchaseContractItem = _PurchaseContractItemExtension.PurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN E_PurchasingDocumentItem AS _PurchaseCtrItmDraftExtension ON PurchaseContract = _PurchaseCtrItmDraftExtension.PurchasingDocument AND PurchaseContractItem = _PurchaseCtrItmDraftExtension.PurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_PurgDocumentItemCategoryText AS _PurgDocumentItemCategoryText ON _PurgDocumentItemCategoryText.Language = $session.system_language AND _PurgDocumentItemCategoryText.PurchasingDocumentItemCategory = PurchasingDocumentItemCategory  -- association [1..1]
LEFT OUTER JOIN I_PurctritnotesWD AS _PurctritnotesWD ON PurchaseContractItem = _PurctritnotesWD.PurchaseContractItem AND PurchaseContract = _PurctritnotesWD.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN I_AccAssgnmtCategory AS _AccountAssignmentCategory ON AccountAssignmentCategory = _AccountAssignmentCategory.AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN I_PurContrItmCndnValdtyTP_2 AS _PurContrItmCndnValdtyTP ON PurchaseContractItem = _PurContrItmCndnValdtyTP.PurchaseContractItem AND PurchaseContract = _PurContrItmCndnValdtyTP.PurchaseContract  -- association [0..*]
;