C_PurchaseOrderLimitItem

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_PurchaseOrderLimitItem.
-- 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_PurchaseOrderLimitItem AS
SELECT
  PurchaseOrderItemTP.PurchaseOrder AS PurchaseOrder,
  cast (PurchaseOrderItemTP.PurchaseOrderItem as ebelp preserving type) AS PurchaseOrderItem,
  PurchaseOrderItemTP.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  _PurchaseOrderItemCategoryText.PurgDocItemCategoryName AS PurOrdItemCategoryName,
  PurchaseOrderItemTP.PurchaseOrderItemText AS PurchaseOrderItemText,
  PurchaseOrderItemTP.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  PurchaseOrderItemTP.OverallLimitAmount AS OverallLimitAmount,
  PurchaseOrderItemTP.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  PurchaseOrderItemTP.DocumentCurrency AS DocumentCurrency,
  PurchaseOrderItemTP.MaterialGroup AS MaterialGroup,
  PurchaseOrderItemTP.Plant AS Plant,
  PurchaseOrderItemTP.AccountAssignmentCategory AS AccountAssignmentCategory,
  _PurchaseOrderItemStatus._PurchasingDocumentStatus._Text[1: Language = $session.system_language].PurchasingDocumentStatusName AS PurchaseOrderItemStatus,
  PurchaseOrderItemTP.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  PurchaseOrderItemTP.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  PurchaseOrderItemTP.InvoiceIsExpected AS InvoiceIsExpected,
  PurchaseOrderItemTP.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  PurchaseOrderItemTP.IsCompletelyDelivered AS IsCompletelyDelivered,
  PurchaseOrderItemTP.IsFinallyInvoiced AS IsFinallyInvoiced,
  RequisitionerName,
  TaxCode,
  TaxJurisdiction,
  _Plant._OrganizationAddress[1: AddressRepresentationCode = '']._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  cast (PurchaseOrderItemTP.UnderdelivTolrtdLmtRatioInPct as untto_ll preserving type) AS UnderdelivTolrtdLmtRatioInPct,
  cast (PurchaseOrderItemTP.UnlimitedOverdeliveryIsAllowed as uebtk preserving type) AS UnlimitedOverdeliveryIsAllowed,
  PurchaseOrderItemTP.IsToBeAcceptedAtOrigin AS IsToBeAcceptedAtOrigin,
  PurchaseOrderItemTP.StorageLocation AS StorageLocation,
  cast (PurchaseOrderItemTP.IntrastatServiceCode as mm_isvco_ll preserving type) AS IntrastatServiceCode,
  PurchaseOrderItemTP.CommodityCode AS CommodityCode,
  ShippingInstruction,
  PurchaseOrderItemTP.IncotermsClassification AS IncotermsClassification,
  PurchaseOrderItemTP.IncotermsLocation1 AS IncotermsLocation1,
  PurchaseOrderItemTP.IncotermsLocation2 AS IncotermsLocation2,
  cast (PurchaseOrderItemTP.PurchasingInfoRecord as infnr_ll preserving type) AS PurchasingInfoRecord,
  cast (PurchaseOrderItemTP._PurchaseContract.PurchaseContract as konnr_ll preserving type) AS PurchaseContract,
  PurchaseOrderItemTP.PurContractForOverallLimit AS PurContractForOverallLimit,
  PurchaseOrderItemTP.PurContractItemForOverallLimit AS PurContractItemForOverallLimit,
  cast (PurchaseOrderItemTP._PurchaseContractItem.PurchaseContractItem as ktpnr_ll preserving type) AS PurchaseContractItem,
  PurchaseOrderItemTP.InfoRecordIsToBeUpdated AS InfoRecordIsToBeUpdated
FROM I_PurchaseorderItemEnhanced AS PurchaseOrderItemTP
LEFT OUTER JOIN I_TaxCode AS _TaxCode ON _TaxCode.TaxCode = TaxCode AND _TaxCode.TaxCalculationProcedure = TaxCalculationProcedure  -- association [0..1]
LEFT OUTER JOIN I_TaxJurisdiction AS _TaxJurisdiction ON _TaxJurisdiction.TaxJurisdiction = TaxJurisdiction AND _TaxJurisdiction.TaxJurisdictionCalcProcedure = ''  -- association [0..1]
LEFT OUTER JOIN I_TaxCalculationProcedure AS _TaxCalculationProcedure ON _TaxCalculationProcedure.TaxCalculationProcedure = TaxCalculationProcedure  -- association [0..1]
LEFT OUTER JOIN I_PurgDocumentItemCategoryText AS _PurchaseOrderItemCategoryText ON _PurchaseOrderItemCategoryText.Language = $session.system_language AND _PurchaseOrderItemCategoryText.PurchasingDocumentItemCategory = PurchaseOrderItemCategory  -- association [1..1]
LEFT OUTER JOIN C_PurOrdActACatValHelp AS _PurOrdActACatValHelp ON _PurOrdActACatValHelp.AccountAssignmentCategory = AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN C_MM_PlantValueHelp AS _PlantValHelp ON _PlantValHelp.Plant = Plant  -- association [0..*]
LEFT OUTER JOIN I_PurchaseOrderItemStatus AS _PurchaseOrderItemStatus ON _PurchaseOrderItemStatus.PurchaseOrder = PurchaseOrder AND _PurchaseOrderItemStatus.PurchaseOrderItem = PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN C_POAccountAssignmentFactSheet AS _POAccountAssignmentFactSheet ON _POAccountAssignmentFactSheet.PurchaseOrder = PurchaseOrder AND _POAccountAssignmentFactSheet.PurchaseOrderItem = PurchaseOrderItem  -- association [1..*]
LEFT OUTER JOIN C_PODeliveryAddressFactSheet AS _PODeliveryAddressFactSheet ON PurchaseOrder = _PODeliveryAddressFactSheet.PurchaseOrder AND PurchaseOrderItem = _PODeliveryAddressFactSheet.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN C_POScheduleLineFactSheet AS _POScheduleLineFactSheet ON _POScheduleLineFactSheet.PurchaseOrder = PurchaseOrder AND _POScheduleLineFactSheet.PurchaseOrderItem = PurchaseOrderItem  -- association [1..*]
;