C_PurchaseOrderLimitItemTP

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_PurchaseOrderLimitItemTP.
-- 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_PurchaseOrderLimitItemTP AS
SELECT
  PurchaseOrderItemTP.PurchaseOrder AS PurchaseOrder,
  cast (PurchaseOrderItemTP.PurchaseOrderItem as ebelp preserving type) AS PurchaseOrderItem,
  PurchaseOrderItemTP.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  PurchaseOrderItemTP.PurOrdItemCategoryName AS PurOrdItemCategoryName,
  PurchaseOrderItemTP.PurchaseOrderItemText AS PurchaseOrderItemText,
  PurchaseOrderItemTP.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  PurchaseOrderItemTP.OverallLimitAmount AS OverallLimitAmount,
  PurchaseOrderItemTP.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  PurchaseOrderItemTP.PurchaseOrderItemStatus AS PurchaseOrderItemStatus_H,
  cast ( '' as abap.char(2)) AS PurchaseOrderItemStatus,
  cast ( '' as abap.sstring(260)) AS PurchaseOrderItemStatusName,
  PurchaseOrderItemTP.DocumentCurrency AS DocumentCurrency,
  PurchaseOrderItemTP.MaterialGroup AS MaterialGroup,
  PurchaseOrderItemTP.Plant AS Plant,
  PurchaseOrderItemTP.ProductType AS ProductType,
  PurchaseOrderItemTP.ProductTypeName AS ProductTypeName,
  PurchaseOrderItemTP.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  PurchaseOrderItemTP.InvoiceIsExpected AS InvoiceIsExpected,
  PurchaseOrderItemTP.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  PurchaseOrderItemTP.IsCompletelyDelivered AS IsCompletelyDelivered,
  PurchaseOrderItemTP.IsFinallyInvoiced AS IsFinallyInvoiced,
  cast ('' as boolean) AS PurgSchdLnIsAddableInLimitItem,
  PurchaseOrderItemTP.HighestMessageSeverityLevel AS HighestMessageSeverityLevel,
  TaxJurisdiction,
  _PurchaseOrderTP.Supplier AS Supplier,
  _Plant._OrganizationAddress[1: AddressRepresentationCode = '']._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  PurchaseOrderItemTP.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  PurchaseOrderItemTP.ManufacturerMaterial AS ManufacturerMaterial,
  PurchaseOrderItemTP.CompanyCode AS CompanyCode,
  PurchaseOrderItemTP.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  PurchaseOrderItemTP.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  PurchaseOrderItemTP.EvaldRcptSettlmtIsAllowed AS EvaldRcptSettlmtIsAllowed,
  PurchaseOrderItemTP.ItemVolumeUnit AS ItemVolumeUnit,
  PurchaseOrderItemTP.ItemWeightUnit AS ItemWeightUnit,
  PurchaseOrderItemTP.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  PurchaseOrderItemTP.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  PurchaseOrderItemTP.PricingDateControl AS PricingDateControl,
  PurchaseOrderItemTP.IsStatisticalItem AS IsStatisticalItem,
  PurchaseOrderItemTP.IsReturnsItem AS IsReturnsItem,
  PurchaseOrderItemTP.InternationalArticleNumber AS InternationalArticleNumber,
  PurchaseOrderItemTP.SupplierConfirmationControlKey AS SupplierConfirmationControlKey,
  PurchaseOrderItemTP.PriceIsToBePrinted AS PriceIsToBePrinted,
  PurchaseOrderItemTP.EffectiveAmount AS EffectiveAmount,
  PurchaseOrderItemTP.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  PurchaseOrderItemTP.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  PurchaseOrderItemTP.BaseUnit AS BaseUnit,
  PurchaseOrderItemTP.RequisitionerName AS RequisitionerName
FROM I_PurchaseOrderItemTP AS PurchaseOrderItemTP
LEFT OUTER JOIN C_PurchaseOrderTP AS _PurchaseOrderTP ON _PurchaseOrderTP.PurchaseOrder = PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN C_PurOrdScheduleLineTP AS _PurOrdScheduleLineTP ON _PurOrdScheduleLineTP.PurchaseOrder = PurchaseOrder AND _PurOrdScheduleLineTP.PurchaseOrderItem = PurchaseOrderItem  -- association [1..*]
LEFT OUTER JOIN C_PurOrdAcctAssignmentTP AS _PurOrdAcctAssignmentTP ON _PurOrdAcctAssignmentTP.PurchaseOrder = PurchaseOrder AND _PurOrdAcctAssignmentTP.PurchaseOrderItem = PurchaseOrderItem  -- association [1..*]
LEFT OUTER JOIN C_PurOrdPricingElementTP AS _PurOrdPricingElementTP ON _PurOrdPricingElementTP.PurchaseOrder = PurchaseOrder AND _PurOrdPricingElementTP.PurchaseOrderItem = PurchaseOrderItem  -- association [1..*]
LEFT OUTER JOIN C_PurOrdDeliveryAddressTP AS _PurOrdDeliveryAddressTP ON _PurOrdDeliveryAddressTP.PurchaseOrder = PurchaseOrder AND _PurOrdDeliveryAddressTP.PurchaseOrderItem = PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN C_MM_TaxCodeValueHelp AS _TaxCode ON _TaxCode.TaxCode = TaxCode AND _TaxCode.TaxCalculationProcedure = TaxCalculationProcedure  -- association [0..1]
LEFT OUTER JOIN C_MM_TaxJurisdictionVH AS _TaxJurisdiction ON _TaxJurisdiction.TaxJurisdiction = TaxJurisdiction  -- association [0..1]
LEFT OUTER JOIN I_TaxCalculationProcedure AS _TaxCalculationProcedure ON _TaxCalculationProcedure.TaxCalculationProcedure = TaxCalculationProcedure  -- association [0..1]
LEFT OUTER JOIN C_MM_ProductTypeValueHelp AS _ProductTypeValueHelp ON _ProductTypeValueHelp.ProductType = ProductType  -- association [0..1]
LEFT OUTER JOIN C_PurOrdActACatValHelp AS _PurOrdActACatValHelp ON _PurOrdActACatValHelp.AccountAssignmentCategory = AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN C_MM_MaterialGroupValueHelp AS _MaterialGroupValueHelp ON _MaterialGroupValueHelp.MaterialGroup = MaterialGroup  -- 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 C_PurOrdTaxJurisdictionValHelp AS _PurOrdTaxJurisdictionValHelp ON _PurOrdTaxJurisdictionValHelp.TaxJurisdiction = TaxJurisdiction AND _PurOrdTaxJurisdictionValHelp.CompanyCode = CompanyCode  -- association [0..*]
LEFT OUTER JOIN C_PurchaseContractValHelp AS _PurContractValHelp ON _PurContractValHelp.PurchaseContract = PurContractForOverallLimit  -- association [1..1]
;