C_PurchaseOrderItemTP

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_PurchaseOrderItemTP.
-- 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_PurchaseOrderItemTP AS
SELECT
  PurchaseOrderItemUniqueID,
  cast ( '' as mmpur_cust_multi_address ) AS BPCustMultiAddrIsActive,
  cast ( '' as mmpur_cust_multi_address ) AS BPCustMultiAddrIsNotActive,
  cast ( '' as abap.char(2)) AS PurchaseOrderItemStatus,
  cast ( '' as abap.sstring(260)) AS PurchaseOrderItemStatusName,
  cast (PurchaseOrderItemTP.PurchaseOrderQuantityUnit as bstme_ll preserving type) AS PurchaseOrderQuantityUnit,
  cast(PurchaseOrderItemTP.GoodsReceiptIsNonValuated as weunb_ll preserving type) AS GoodsReceiptIsNonValuated,
  cast (PurchaseOrderItemTP.InvoiceIsExpected as repos_ll preserving type) AS InvoiceIsExpected,
  cast(PurchaseOrderItemTP.InvoiceIsGoodsReceiptBased as webre_ll preserving type) AS InvoiceIsGoodsReceiptBased,
  cast (PurchaseOrderItemTP.UnderdelivTolrtdLmtRatioInPct as untto_ll preserving type) AS UnderdelivTolrtdLmtRatioInPct,
  cast (PurchaseOrderItemTP.UnlimitedOverdeliveryIsAllowed as uebtk preserving type) AS UnlimitedOverdeliveryIsAllowed,
  cast (PurchaseOrderItemTP.IntrastatServiceCode as mm_isvco_ll preserving type) AS IntrastatServiceCode,
  ShippingInstruction,
  cast (PurchaseOrderItemTP.PurchaseContract as konnr_ll preserving type) AS PurchaseContract,
  cast (PurchaseOrderItemTP.PurchaseContractItem as ktpnr_ll preserving type) AS PurchaseContractItem,
  cast ( EarmarkedFundsDocument as fmis_earmarkedfundsdoc preserving type ) AS EarmarkedFundsDocument,
  cast ( EarmarkedFundsDocumentItem as fmis_earmarkedfundsdocitem preserving type ) AS EarmarkedFundsDocumentItem,
  cast ('' as fm_measure) AS FundedProgram,
  TaxJurisdiction,
  TaxCountry,
  TaxDeterminationDate,
  cast (PurchaseOrderItemTP.BR_MaterialOrigin as logbr_matorg preserving type) AS BR_MaterialOrigin,
  cast (PurchaseOrderItemTP.BR_MaterialUsage as logbr_matuse preserving type) AS BR_MaterialUsage,
  cast (PurchaseOrderItemTP.BR_CFOPCategory as logbr_cfopcategory preserving type) AS BR_CFOPCategory,
  cast (PurchaseOrderItemTP.BR_IsProducedInHouse as logbr_ownpro preserving type) AS BR_IsProducedInHouse,
  _SupplierConfControlKey._Text.SupplierConfControlKeyName AS SupplierConfControlKeyName,
  PurgDocOrderAcknNumber,
  cast(IsOrderAcknRqd as kzabs_ll preserving type ) AS IsOrderAcknRqd,
  ItemIsRejectedBySupplier,
  _Plant._Address._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  PurgProductMarketabilityStatus,
  PurgSafetyDataSheetStatus,
  PurgProdCmplncDngrsGoodsStatus,
  cast ('' as boolean) AS ProductComplianceIsActive,
  cast ('' as ehfnd_bf_pcs_is_active) AS BusFtreProdCmplncSuplrIsActive,
  cast ('' as ehfnd_bf_pma_is_active) AS BusFtreProdMarketabilityIsActv,
  cast ('' as ehfnd_bf_dg_is_active) AS BusFtreDngrsGoodsIsActive,
  cast ('' as ehfnd_bf_sds_is_active) AS BusFtreSftyDataShtMgmtIsActive,
  cast ('' as boolean) AS ScheduleLineIsAddable,
  cast ('' as boolean) AS PurOrdAcctAssgmtFacetIsVisible,
  PurchaseOrderItemTP.PurchaseOrder AS PurchaseOrder,
  PurchaseOrderItemTP.PurchaseOrderItem AS PurchaseOrderItem,
  PurchaseOrderItemTP.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  PurchaseOrderItemTP.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  PurchaseOrderItemTP.PurgDocAggrgdSubitemCategory AS PurgDocAggrgdSubitemCategory,
  PurchaseOrderItemTP.PurchasingParentItem AS PurchasingParentItem,
  PurchaseOrderItemTP.PurgDocSubitemCategory AS PurgDocSubitemCategory,
  PurchaseOrderItemTP.IsStatisticalItem AS IsStatisticalItem,
  PurchaseOrderItemTP.PurgExternalSortNumber AS PurgExternalSortNumber,
  PurchaseOrderItemTP.PurchasingIsItemSet AS PurchasingIsItemSet,
  PurchaseOrderItemTP.PurOrdExternalItemCategory AS PurOrdExtHierItemCategory,
  PurchaseOrderItemTP.PurOrdExternalItemCategory AS PurOrdExternalItemCategory,
  PurchaseOrderItemTP.PurOrdItemCategoryName AS PurOrdItemCategoryName,
  PurchaseOrderItemTP.Material AS Material,
  PurchaseOrderItemTP.ManufacturerMaterial AS ManufacturerMaterial,
  PurchaseOrderItemTP.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  PurchaseOrderItemTP.OverallLimitAmount AS OverallLimitAmount,
  PurchaseOrderItemTP.PurchaseOrderItemText AS PurchaseOrderItemText,
  PurchaseOrderItemTP.MaterialGroup AS MaterialGroup,
  PurchaseOrderItemTP.Plant AS Plant,
  PurchaseOrderItemTP.OrderQuantity AS OrderQuantity,
  PurchaseOrderItemTP.NetPriceAmount AS NetPriceAmount,
  PurchaseOrderItemTP.NetPriceQuantity AS NetPriceQuantity,
  PurchaseOrderItemTP.NetAmount AS NetAmount,
  PurchaseOrderItemTP.ServicePerformer AS ServicePerformer,
  PurchaseOrderItemTP.ProductType AS ProductType,
  PurchaseOrderItemTP.ProductTypeName AS ProductTypeName,
  PurchaseOrderItemTP.Customer AS Customer,
  PurchaseOrderItemTP.ReferenceDeliveryAddressID AS ReferenceDeliveryAddressID,
  PurchaseOrderItemTP.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  PurchaseOrderItemTP.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  PurchaseOrderItemTP.PurchaseOrderItemStatus AS PurchaseOrderItemStatus_H,
  PurchaseOrderItemTP.DocumentCurrency AS DocumentCurrency,
  PurchaseOrderItemTP.OrderPriceUnit AS OrderPriceUnit,
  PurchaseOrderItemTP.PurchasingHierarchyNode AS PurchasingHierarchyNode,
  PurchaseOrderItemTP.HierarchyParentNode AS HierarchyParentNode,
  PurchaseOrderItemTP.HierarchyLevel AS HierarchyLevel,
  PurchaseOrderItemTP.HierarchyNodeSubTreeSize AS HierarchyNodeSubTreeSize,
  PurchaseOrderItemTP.HierarchyDrillState AS HierarchyDrillState,
  PurchaseOrderItemTP.HierarchyNodeOrdinalNumber AS HierarchyNodeOrdinalNumber,
  PurchaseOrderItemTP.EvaldRcptSettlmtIsAllowed AS EvaldRcptSettlmtIsAllowed,
  PurchaseOrderItemTP.IsCompletelyDelivered AS IsCompletelyDelivered,
  PurchaseOrderItemTP.IsFinallyInvoiced AS IsFinallyInvoiced,
  PurchaseOrderItemTP.PriceChangeInSESIsAllowed AS PriceChangeInSESIsAllowed,
  PurchaseOrderItemTP.IsToBeAcceptedAtOrigin AS IsToBeAcceptedAtOrigin,
  PurchaseOrderItemTP.StorageLocation AS StorageLocation,
  PurchaseOrderItemTP.CommodityCode AS CommodityCode,
  PurchaseOrderItemTP.IncotermsClassification AS IncotermsClassification,
  PurchaseOrderItemTP.IncotermsLocation1Identifier AS IncotermsLocation1Identifier,
  PurchaseOrderItemTP.IncotermsSupChnLoc1AddlUUID AS IncotermsSupChnLoc1AddlUUID,
  PurchaseOrderItemTP.IncotermsLocation1 AS IncotermsLocation1,
  PurchaseOrderItemTP.IncotermsDvtgLocIdentifier AS IncotermsDvtgLocIdentifier,
  PurchaseOrderItemTP.IncotermsSupChnDvtgLocAddlUUID AS IncotermsSupChnDvtgLocAddlUUID,
  PurchaseOrderItemTP.IncotermsDvtgLocDescription AS IncotermsDvtgLocDescription,
  PurchaseOrderItemTP.IncotermsLocation2Identifier AS IncotermsLocation2Identifier,
  PurchaseOrderItemTP.IncotermsSupChnLoc2AddlUUID AS IncotermsSupChnLoc2AddlUUID,
  PurchaseOrderItemTP.IncotermsLocation2 AS IncotermsLocation2,
  PurchaseOrderItemTP.PurContractForOverallLimit AS PurContractForOverallLimit,
  PurchaseOrderItemTP.PurContractItemForOverallLimit AS PurContractItemForOverallLimit,
  PurchaseOrderItemTP.InfoRecordIsToBeUpdated AS InfoRecordIsToBeUpdated,
  PurchaseOrderItemTP.GLAccount AS GLAccount,
  PurchaseOrderItemTP.WBSElementExternalID AS WBSElementExternalID,
  PurchaseOrderItemTP.WBSDescription AS WBSDescription,
  PurchaseOrderItemTP.Fund AS Fund,
  PurchaseOrderItemTP.BudgetPeriod AS BudgetPeriod,
  PurchaseOrderItemTP.FundsCenter AS FundsCenter,
  PurchaseOrderItemTP.CommitmentItem AS CommitmentItem,
  PurchaseOrderItemTP.EarmarkedFunds AS EarmarkedFunds,
  PurchaseOrderItemTP.EarmarkedFundsItem AS EarmarkedFundsItem,
  PurchaseOrderItemTP.FunctionalArea AS FunctionalArea,
  PurchaseOrderItemTP.GrantID AS GrantID,
  PurchaseOrderItemTP.BR_NCM AS BR_NCM,
  PurchaseOrderItemTP.IN_GSTControlCode AS IN_GSTControlCode,
  PurchaseOrderItemTP.Batch AS Batch,
  PurchaseOrderItemTP.BatchBySupplier AS BatchBySupplier,
  PurchaseOrderItemTP.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  PurchaseOrderItemTP.CompanyCode AS CompanyCode,
  PurchaseOrderItemTP.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  PurchaseOrderItemTP.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  PurchaseOrderItemTP.ItemVolumeUnit AS ItemVolumeUnit,
  PurchaseOrderItemTP.ItemWeightUnit AS ItemWeightUnit,
  PurchaseOrderItemTP.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  PurchaseOrderItemTP.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  PurchaseOrderItemTP.PricingDateControl AS PricingDateControl,
  PurchaseOrderItemTP.IsReturnsItem AS IsReturnsItem,
  PurchaseOrderItemTP.InternationalArticleNumber AS InternationalArticleNumber,
  PurchaseOrderItemTP.PriceIsToBePrinted AS PriceIsToBePrinted,
  PurchaseOrderItemTP.EffectiveAmount AS EffectiveAmount,
  PurchaseOrderItemTP.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  PurchaseOrderItemTP.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  PurchaseOrderItemTP.BaseUnit AS BaseUnit,
  PurchaseOrderItemTP.RequisitionerName AS RequisitionerName,
  PurchaseOrderItemTP.PlannedDeliveryDurationInDays AS PlannedDeliveryDurationInDays,
  PurchaseOrderItemTP.ConsumptionPosting AS ConsumptionPosting,
  PurchaseOrderItemTP.IsInfoRecordUpdated AS IsInfoRecordUpdated,
  PurchaseOrderItemTP.PurchaseRequisition AS PurchaseRequisition,
  PurchaseOrderItemTP.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  PurchaseOrderItemTP.POItmAcctAssgmtFieldsAreEnbld AS POItmAcctAssgmtFieldsAreEnbld,
  PurchaseOrderItemTP.HighestMessageSeverityLevel AS HighestMessageSeverityLevel,
  PurchaseOrderItemTP._IncotermsVersion AS _IncotermsVersion,
  PurchaseOrderItemTP._PurchasingInfoRecord AS _PurchasingInfoRecord,
  PurchaseOrderItemTP._PurchaseContractItem AS _PurchaseContractItem,
  PurchaseOrderItemTP._IncotermsClassification AS _IncotermsClassification,
  PurchaseOrderItemTP._OrderPriceUnit AS _OrderPriceUnit,
  PurchaseOrderItemTP._OrderQuantityUnit AS _OrderQuantityUnit,
  PurchaseOrderItemTP._ProductType AS _ProductType,
  PurchaseOrderItemTP._BR_MaterialOrigin AS _BR_MaterialOrigin,
  PurchaseOrderItemTP._BR_MaterialUsage AS _BR_MaterialUsage,
  PurchaseOrderItemTP._BR_CFOPCategory AS _BR_CFOPCategory,
  PurchaseOrderItemTP._BR_NCM AS _BR_NCM,
  _POItemProdCmplncCriticality.UICT_PurgProdCmplncSupplierSts AS UICT_PurgProdCmplncSupplierSts,
  _POItemProdCmplncCriticality.UICT_PurgProdMarketabilitySts AS UICT_PurgProdMarketabilitySts,
  _POItemProdCmplncCriticality.UICT_PurgSafetyDataSheetStatus AS UICT_PurgSafetyDataSheetStatus,
  _POItemProdCmplncCriticality.UICT_PurgCmplncDngrsGoodsSts AS UICT_PurgCmplncDngrsGoodsSts,
  _PurchaseOrderTP.Supplier AS Supplier,
  _PurgProdCmplncDngrsGoodsStsT.PurgProdCmplncDngrsGdsStsName AS PurgProdCmplncDngrsGdsStsName,
  _PurgProdCmplncSupplierStsT.PurgProdCmplncSupplierStsName AS PurgProdCmplncSupplierStsName,
  _PurgProductMarketabilityStsT.PurgProdMarketabilityStsName AS PurgProdMarketabilityStsName,
  _PurgSafetyDataSheetStatusT.PurgSafetyDataSheetStatusName AS PurgSafetyDataSheetStatusName,
  _PurOrdDeliveryAddressTP.Country AS Country,
  _PurOrdDeliveryAddressTP.CountryName AS CountryName,
  _PurOrdDeliveryAddressTP.RegionName AS RegionName,
  _PurOrdDeliveryAddressTP.PostalCode AS PostalCode,
  _PurOrdDeliveryAddressTP.CityName AS CityName
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_PurchaseOrderItemNoteTP AS _PurchaseOrderItemNoteTP ON _PurchaseOrderItemNoteTP.PurchaseOrder = PurchaseOrder AND _PurchaseOrderItemNoteTP.PurchaseOrderItem = PurchaseOrderItem  -- association [0..*]
LEFT OUTER JOIN C_PurOrdSupplierConfirmation AS _PurOrdSupplierConfirmation ON _PurOrdSupplierConfirmation.PurchaseOrder = PurchaseOrder AND _PurOrdSupplierConfirmation.PurchaseOrderItem = PurchaseOrderItem  -- association [0..*]
LEFT OUTER JOIN I_TaxCalculationProcedure AS _TaxCalculationProcedure ON _TaxCalculationProcedure.TaxCalculationProcedure = TaxCalculationProcedure  -- association [0..1]
LEFT OUTER JOIN I_CnsmpnTaxControlCodeCoCode AS _CnsmptnTaxCntrlCode ON _CnsmptnTaxCntrlCode.CountryCode = 'IN' AND _CnsmptnTaxCntrlCode.ConsumptionTaxCtrlCode = IN_GSTControlCode  -- association [0..1]
LEFT OUTER JOIN I_SupplierConfControlKey AS _SupplierConfControlKey ON _SupplierConfControlKey.SupplierConfirmationControlKey = SupplierConfirmationControlKey  -- association [0..1]
LEFT OUTER JOIN C_AlternateSupplierPOSituation AS _POItemAlternateSuplrSit ON _POItemAlternateSuplrSit.Plant = Plant AND _POItemAlternateSuplrSit.Material = Material AND _POItemAlternateSuplrSit.Supplier != supplier AND _POItemAlternateSuplrSit.PurchasingOrganization = purchasingorganization AND _POItemAlternateSuplrSit.PurchaseOrderItemCategory = PurchaseOrderItemCategory  -- association [0..*]
LEFT OUTER JOIN C_PurOrdTaxJurisdictionValHelp AS _PurOrdTaxJurisdictionValHelp ON _PurOrdTaxJurisdictionValHelp.TaxJurisdiction = TaxJurisdiction AND _PurOrdTaxJurisdictionValHelp.CompanyCode = CompanyCode AND _PurOrdTaxJurisdictionValHelp.Country = Country AND _PurOrdTaxJurisdictionValHelp.Region = Region AND _PurOrdTaxJurisdictionValHelp.CityName = CityName AND _PurOrdTaxJurisdictionValHelp.PostalCode = PostalCode  -- association [0..*]
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 C_MM_ServicePerformerValueHelp AS _MM_ServicePerformerValueHelp ON _MM_ServicePerformerValueHelp.ServicePerformer = ServicePerformer AND _MM_ServicePerformerValueHelp.Supplier = supplier  -- association [0..1]
LEFT OUTER JOIN C_MM_MaterialValueHelp AS _MaterialValueHelp ON _MaterialValueHelp.Material = ManufacturerMaterial AND _MaterialValueHelp.MaterialGroup = MaterialGroup AND _MaterialValueHelp.Plant = Plant  -- 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_PurOrdActACatValHelp AS _PurOrdActACatValHelp ON _PurOrdActACatValHelp.AccountAssignmentCategory = AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN I_PurgProdCmplncSupplierStsT AS _PurgProdCmplncSupplierStsT ON PurgProdCmplncSupplierStatus = _PurgProdCmplncSupplierStsT.PurgProdCmplncSupplierStatus AND _PurgProdCmplncSupplierStsT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurgProductMarketabilityStsT AS _PurgProductMarketabilityStsT ON PurgProductMarketabilityStatus = _PurgProductMarketabilityStsT.PurgProductMarketabilityStatus AND _PurgProductMarketabilityStsT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurgSafetyDataSheetStatusT AS _PurgSafetyDataSheetStatusT ON PurgSafetyDataSheetStatus = _PurgSafetyDataSheetStatusT.PurgSafetyDataSheetStatus AND _PurgSafetyDataSheetStatusT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurgProdCmplncDngrsGoodsStsT AS _PurgProdCmplncDngrsGoodsStsT ON PurgProdCmplncDngrsGoodsStatus = _PurgProdCmplncDngrsGoodsStsT.PurgProdCmplncDngrsGoodsStatus AND _PurgProdCmplncDngrsGoodsStsT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_POItemProdCmplncCriticality AS _POItemProdCmplncCriticality ON PurchaseOrder = _POItemProdCmplncCriticality.PurchaseOrder AND PurchaseOrderItem = _POItemProdCmplncCriticality.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_BatchVH AS _BatchVH ON Material = _BatchVH.Material AND Plant = _BatchVH.Plant  -- association [0..*]
LEFT OUTER JOIN C_PurchaseOrderItemSet AS _PurchaseOrderItemSet ON _PurchaseOrderItemSet.PurchaseOrder = PurchaseOrder AND _PurchaseOrderItemSet.PurchaseOrderItem = PurchaseOrderItem  -- association [1..1]
;