C_SSPPurchaseReqnItemTP

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_SSPPurchaseReqnItemTP.
-- 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_SSPPurchaseReqnItemTP AS
SELECT
  _Purchaserequisitionitem_Wd.PurchaseRequisition AS PurchaseRequisition,
  _Purchaserequisitionitem_Wd.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _Purchaserequisitionitem_Wd.PurchaseReqnItemUniqueID AS PurchaseReqnItemUniqueID,
  _Purchaserequisitionitem_Wd.PurReqnReworkCommentText AS PurReqnReworkCommentText,
  _Purchaserequisitionitem_Wd.SourcePurchaseRequisition AS SourcePurchaseRequisition,
  _Purchaserequisitionitem_Wd.SourcePurchaseRequisitionItem AS SourcePurchaseRequisitionItem,
  _Purchaserequisitionitem_Wd.Material AS Material,
  _Purchaserequisitionitem_Wd.ExtMaterialForPurg AS ExtMaterialForPurg,
  _Purchaserequisitionitem_Wd._MaterialText AS _MaterialText,
  _Purchaserequisitionitem_Wd.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  _Purchaserequisitionitem_Wd.MaterialGroup AS MaterialGroup,
  _Purchaserequisitionitem_Wd._MaterialGroupText AS _MaterialGroupText,
  _Purchaserequisitionitem_Wd.SupplierMaterialNumber AS SupplierMaterialNumber,
  _Purchaserequisitionitem_Wd.ServicePerformer AS ServicePerformer,
  _Purchaserequisitionitem_Wd.ProductType AS ProductTypeCode,
  _ProductTypeValueHelp.ProductTypeName AS ProductTypeName,
  _Purchaserequisitionitem_Wd.Supplier AS Supplier,
  _Purchaserequisitionitem_Wd.ExtDesiredSupplierForPurg AS ExtDesiredSupplierForPurg,
  _SupplierValueHelp.SupplierName AS SupplierName,
  _Purchaserequisitionitem_Wd.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  _Purchaserequisitionitem_Wd.Currency AS Currency,
  _Purchaserequisitionitem_Wd._CurrencyText AS _CurrencyText,
  _Purchaserequisitionitem_Wd.NetPriceQuantity AS NetPriceQuantity,
  _Purchaserequisitionitem_Wd.RequestedQuantity AS RequestedQuantity,
  _Purchaserequisitionitem_Wd.BaseUnit AS BaseUnit,
  _Purchaserequisitionitem_Wd._UnitOfMeasureText AS _UnitOfMeasureText,
  _Purchaserequisitionitem_Wd.OverallLimitAmount AS OverallLimitAmount,
  _Purchaserequisitionitem_Wd.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  _Purchaserequisitionitem_Wd.DeliveryDate AS DeliveryDate,
  _Purchaserequisitionitem_Wd.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  _Purchaserequisitionitem_Wd.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  _Purchaserequisitionitem_Wd.PurchasingGroup AS PurchasingGroup,
  _Purchaserequisitionitem_Wd.PurchasingOrganization AS PurchasingOrganization,
  _Purchaserequisitionitem_Wd.ExtPurgOrgForPurg AS ExtPurgOrgForPurg,
  _BackendPurchasingOrganization.ProcmtHubPurgOrgName AS ProcmtHubPurgOrgName,
  _Purchaserequisitionitem_Wd.CompanyCode AS CompanyCode,
  _Purchaserequisitionitem_Wd.ExtCompanyCodeForPurg AS ExtCompanyCodeForPurg,
  _BackendCoCodeVH.ProcmtHubCompanyCodeName AS ProcmtHubCompanyCodeName,
  _Purchaserequisitionitem_Wd.Plant AS Plant,
  _Purchaserequisitionitem_Wd.ExtPlantForPurg AS ExtPlantForPurg,
  _Purchaserequisitionitem_Wd.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  _Purchaserequisitionitem_Wd.StorageLocation AS StorageLocation,
  _Purchaserequisitionitem_Wd.ProcmtHubStorageLocation AS ProcmtHubStorageLocation,
  _BackendPlantVH.ProcmtHubPlantName AS ProcmtHubPlantName,
  _Purchaserequisitionitem_Wd.AccountAssignmentCategory AS AccountAssignmentCategory,
  _Purchaserequisitionitem_Wd.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  _Purchaserequisitionitem_Wd.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  _Purchaserequisitionitem_Wd.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  _Purchaserequisitionitem_Wd.ItemDeliveryAddressID AS ItemDeliveryAddressID,
  _Purchaserequisitionitem_Wd.AddressType AS PurchasingDeliveryAddressType,
  _Purchaserequisitionitem_Wd.FormOfAddress AS FormOfAddress,
  _Purchaserequisitionitem_Wd.FullName AS FullName,
  _Purchaserequisitionitem_Wd.PhoneNumber1 AS PhoneAreaCodeSubscriberNumber,
  _Purchaserequisitionitem_Wd.FaxNumber AS FaxAreaCodeSubscriberNumber,
  _Purchaserequisitionitem_Wd.EmailAddress AS EmailAddress,
  _Purchaserequisitionitem_Wd.CareOfName AS CareOfName,
  _Purchaserequisitionitem_Wd.AddressStreetName AS AddressStreetName,
  _Purchaserequisitionitem_Wd.StreetPrefixName1 AS StreetPrefixName1,
  _Purchaserequisitionitem_Wd.StreetPrefixName2 AS StreetPrefixName2,
  _Purchaserequisitionitem_Wd.AddressHouseNumber AS AddressHouseNumber,
  _Purchaserequisitionitem_Wd.AddressCityName AS AddressCityName,
  _Purchaserequisitionitem_Wd.AddressPostalCode AS AddressPostalCode,
  _Purchaserequisitionitem_Wd.AddressCountry AS AddressCountry,
  _Purchaserequisitionitem_Wd._CountryText AS _CountryText,
  _Purchaserequisitionitem_Wd.AddressRegion AS AddressRegion,
  _Purchaserequisitionitem_Wd._RegionText AS _RegionText,
  _Purchaserequisitionitem_Wd.BusinessPartnerName1 AS BusinessPartnerName1,
  _Purchaserequisitionitem_Wd.BusinessPartnerName2 AS BusinessPartnerName2,
  _Purchaserequisitionitem_Wd.POBox AS POBox,
  _Purchaserequisitionitem_Wd.POBoxPostalCode AS POBoxPostalCode,
  _Purchaserequisitionitem_Wd.Building AS Building,
  _Purchaserequisitionitem_Wd.Floor AS Floor,
  _Purchaserequisitionitem_Wd.RoomNumber AS RoomNumber,
  _Purchaserequisitionitem_Wd.BusinessPartnerName3 AS BusinessPartnerName3,
  _Purchaserequisitionitem_Wd.BusinessPartnerName4 AS BusinessPartnerName4,
  _Purchaserequisitionitem_Wd.SSPPurReqnItmIsInComposing AS SSPPurReqnItmIsInComposing,
  _Purchaserequisitionitem_Wd.PurReqnSSPCatalog AS PurReqnSSPCatalog,
  _Purchaserequisitionitem_Wd.PurReqnSSPCatalogItem AS PurReqnSSPCatalogItem,
  _Purchaserequisitionitem_Wd.PurReqnSSPCrossCatalogItem AS PurReqnSSPCrossCatalogItem,
  _Purchaserequisitionitem_Wd.OpnCtlgMainImageURL AS OpnCtlgMainImageURL,
  _Purchaserequisitionitem_Wd.OpnCtlgHasPriceScale AS OpnCtlgHasPriceScale,
  _Purchaserequisitionitem_Wd.IsDeleted AS IsDeleted,
  _Purchaserequisitionitem_Wd.PurReqnItemLifeCycleStatus AS PurReqnItemLifeCycleStatus,
  _Purchaserequisitionitem_Wd.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  _Purchaserequisitionitem_Wd.PurReqnRejectionIsCancelled AS PurReqnRejectionIsCancelled,
  _Purchaserequisitionitem_Wd.ProcessingStatus AS ProcessingStatus,
  _Purchaserequisitionitem_Wd.ExternalApprovalStatus AS ExternalApprovalStatus,
  _Purchaserequisitionitem_Wd.Language AS Language,
  _Purchaserequisition_Wd.PurReqnSSPAuthor AS PurReqnSSPAuthor,
  _Purchaserequisition_Wd.PurReqnSSPRequestor AS PurReqnSSPRequestor,
  cast(_Purchaserequisitionitem_Wd.BusinessUser as sysid ) AS BusinessUser,
  _Purchaserequisition_Wd.PurchaseRequisitionType AS PurchaseRequisitionType,
  _Purchaserequisitionitem_Wd.ExtPurchaseRequisitionType AS ExtPurchaseRequisitionType,
  _Purchaserequisitionitem_Wd.CntrlReqnIsRpldBfrApprvl AS CntrlReqnIsRpldBfrApprvl,
  cast ( _Purchaserequisitionitem_Wd.ExtSourceSystem as mmpur_d_hub_logsys ) AS ExtSourceSystem,
  _Purchaserequisitionitem_Wd.FixedSupplier AS FixedSupplier,
  _Purchaserequisitionitem_Wd.ExtFixedSupplierForPurg AS ExtFixedSupplierForPurg,
  _Supplier.SupplierName AS FixedSupplierName,
  _Purchaserequisitionitem_Wd.PurchasingInfoRecord AS PurchasingInfoRecord,
  _Purchaserequisitionitem_Wd.ExtInfoRecordForPurg AS ExtInfoRecordForPurg,
  _Purchaserequisitionitem_Wd.PurchaseContract AS PurchaseContract,
  _Purchaserequisitionitem_Wd.ExtContractForPurg AS ExtContractForPurg,
  _Purchaserequisitionitem_Wd.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  _Purchaserequisitionitem_Wd.Manufacturer AS Manufacturer,
  _Purchaserequisitionitem_Wd.ManufacturerMaterial AS ManufacturerMaterial,
  _Purchaserequisitionitem_Wd.PurReqnSSPCtlgItmHasSuplr AS PurReqnSSPCtlgItmHasSuplr,
  _Purchaserequisitionitem_Wd.PurchaseContractItem AS PurchaseContractItem,
  _Purchaserequisitionitem_Wd.ExtContractItemForPurg AS ExtContractItemForPurg,
  cast('' as boolean ) AS IsPurReqnOvrlRel,
  _Purchaserequisitionitem_Wd.TotalNetAmount AS TotalNetAmount,
  _Purchaserequisitionitem_Wd.PurReqnLifeCycleStatusName AS PurReqnLifeCycleStatusName,
  cast ( 0 as int2 ) AS StatusCriticality,
  cast ('' as mmpur_req_d_pr_rework_ind) AS PurReqnIsApplicableForRework,
  _PurReqnRework.PurReqnApproverCommentText AS PurReqnApproverCommentText,
  cast ( '' as abap.char(10) ) AS WorkflowScenarioDefinition,
  cast ( '' as xfeld ) AS PurgHasFlxblWorkflowApproval,
  cast ( '' as xfeld ) AS AcctAssgmtInPurReqnIsRelevant
FROM I_Purchaserequisitionitem_Wd AS _Purchaserequisitionitem_Wd
LEFT OUTER JOIN C_SSPPurchaseReqnHdrTP AS _Purchaserequisition_Wd ON PurchaseRequisition = _Purchaserequisition_Wd.PurchaseRequisition  -- association [1..1]
LEFT OUTER JOIN C_SSPPurchaseReqnAcctAssgmtTP AS _PurReqnAccAssignment_WD ON PurchaseRequisition = _PurReqnAccAssignment_WD.PurchaseRequisition AND PurchaseRequisitionItem = _PurReqnAccAssignment_WD.PurchaseRequisitionItem  -- association [0..*]
LEFT OUTER JOIN C_SSPPurchaseReqnItemTextTP AS _Purreqnitemtext_Wd ON PurchaseRequisition = _Purreqnitemtext_Wd.PurchaseRequisition AND PurchaseRequisitionItem = _Purreqnitemtext_Wd.PurchaseRequisitionItem  -- association [0..*]
LEFT OUTER JOIN C_SSPSupplierPurgOrgVH AS _Supplier ON FixedSupplier = _Supplier.Supplier AND PurchasingOrganization = _Supplier.PurchasingOrganization AND ProcurementHubSourceSystem = _Supplier.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_SSPSupplierPurgOrgVH AS _SupplierValueHelp ON Supplier = _SupplierValueHelp.Supplier AND PurchasingOrganization = _SupplierValueHelp.PurchasingOrganization AND ProcurementHubSourceSystem = _SupplierValueHelp.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubPlantVH AS _BackendPlantVH ON _BackendPlantVH.ProcmtHubPlant = ExtPlantForPurg AND _BackendPlantVH.ProcmtHubCompanyCode = ExtCompanyCodeForPurg AND _BackendPlantVH.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubCompanyCodeVH AS _BackendCoCodeVH ON _BackendCoCodeVH.ProcmtHubCompanyCode = ExtCompanyCodeForPurg AND _BackendCoCodeVH.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubPurgOrgVH AS _BackendPurchasingOrganization ON _BackendPurchasingOrganization.ProcurementHubSourceSystem = ProcurementHubSourceSystem AND _BackendPurchasingOrganization.ProcmtHubPurchasingOrg = ExtPurgOrgForPurg  -- association [0..1]
LEFT OUTER JOIN C_SSPPurchasingDocumentType AS _ExtPurchasingDocumentType ON _ExtPurchasingDocumentType.PurchasingDocumentCategory = 'B' AND ExtPurchaseRequisitionType = _ExtPurchasingDocumentType.PurchasingDocumentType AND ExtSourceSystem = _ExtPurchasingDocumentType.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN R_PurchaseReqnRwrkComments AS _PurReqnRework ON _PurReqnRework.PurchaseRequisition = '' AND _PurReqnRework.PurchaseRequisition <> ''  -- association [0..1]
LEFT OUTER JOIN C_MM_CountryValueHelp AS _Country ON _Country.Country = AddressCountry  -- association [0..1]
LEFT OUTER JOIN C_MM_RegionValueHelp AS _Region ON _Region.Region = AddressRegion AND _Region.Country = AddressCountry  -- association [0..1]
LEFT OUTER JOIN C_MM_ProductTypeValueHelp AS _ProductTypeValueHelp ON _ProductTypeValueHelp.ProductType = ProductTypeCode  -- association [0..1]
;