I_MDQAnlytsScrSuplrPurC

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_MDQAnlytsScrSuplrPurC.
-- 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 I_MDQAnlytsScrSuplrPurC AS
SELECT
  _MDQAnlytsScrBPSuplrPur.MasterDataChangeProcess AS MasterDataChangeProcess,
  _MDQAnlytsScrBPSuplrPur.BusinessPartner AS BusinessPartner,
  _MDQAnlytsScrBPSuplrPur.PurchasingOrganization AS PurchasingOrganization,
  _MDQAnlytsScrBPSuplrPur.MDQualityBusinessRuleUUID AS MDQualityBusinessRuleUUID,
  _MDQAnlytsScrBPSuplrPur.MDQltyBusRuleEvalResultCode AS MDQltyBusRuleEvalResultCode,
  Supplier,
  _Supplier.AlternativePayeeIsAllowed AS AlternativePayeeIsAllowed,
  _Supplier.CityName AS CityName,
  _Supplier.Country AS Country,
  _Supplier.Industry AS Industry,
  _Supplier.PaymentIsBlockedForSupplier AS PaymentIsBlockedForSupplier,
  _Supplier.PaymentReason AS PaymentReason,
  _Supplier.PostalCode AS PostalCode,
  _Supplier.PostingIsBlocked AS PostingIsBlocked,
  _Supplier.PurchasingIsBlocked AS PurchasingIsBlocked,
  _Supplier.Region AS Region,
  _Supplier.ResponsibleType AS ResponsibleType,
  _Supplier.SuplrProofOfDelivRlvtCode AS SuplrProofOfDelivRlvtCode,
  _Supplier.SuplrQualityManagementSystem AS SuplrQualityManagementSystem,
  _Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _Supplier.SupplierCorporateGroup AS SupplierCorporateGroup,
  _Supplier.SupplierIsPlantRelevant AS SupplierIsPlantRelevant,
  _Supplier.SupplierIsSubRangeRelevant AS SupplierIsSubRangeRelevant,
  _Supplier.SupplierProcurementBlock AS SupplierProcurementBlock,
  _SupplierPurchasingOrg.AuthorizationGroup AS AuthorizationGroup,
  _SupplierPurchasingOrg.PaymentTerms AS PaymentTerms,
  _SupplierPurchasingOrg.PurchaseOrderCurrency AS PurchaseOrderCurrency,
  _SupplierPurchasingOrg.PurchasingGroup AS PurchasingGroup,
  _SupplierPurchasingOrg.PurchasingIsBlockedForSupplier AS PurchasingIsBlockedForSupplier,
  _SupplierPurchasingOrg.RoundingProfile AS RoundingProfile,
  _SupplierPurchasingOrg.PlanningCycle AS PlanningCycle,
  _MDQAnlytsScrBPSuplrPur._MasterDataChangeProcess.MDChgProcessFinishDate AS MDChgProcessFinishDate,
  _MDQltyScoreEvalDetails.MDChgProcessIsLatest AS MDChgProcessIsLatest,
  _MDQAnlytsScrBPSuplrPur.MDQltyBusinessRuleBaseTable AS MDQltyBusinessRuleBaseTable,
  _MDQBusinessRuleBaseTableText[1:Language=$session.system_language].MDQltyBusinessRuleBaseTabName AS MDQltyBusinessRuleBaseTabName,
  _MDQAnlytsScrBPSuplrPur.MDQltyBusinessRuleOwner AS MDQltyBusinessRuleOwner,
  _MDQualityBusinessRule.MDQltyBusRuleCheckedField AS MDQltyBusRuleCheckedField,
  _MDQualityBusinessRule.MDQltyBusRuleCheckedFieldTable AS MDQltyBusRuleCheckedFieldTable,
  _MDQualityBusinessRule.MDQltyBusRuleChkdFieldAndTable AS MDQltyBusRuleChkdFieldAndTable,
  _MDQualityBusinessRule.MDQualityBusinessRule AS MDQualityBusinessRule,
  _MDQualityBusinessRule.MDQualityBusinessRuleName AS MDQualityBusinessRuleName,
  _BusinessPartner.AcademicTitle AS AcademicTitle,
  _BusinessPartner.BPFirstNameSearchHelp AS BPFirstNameSearchHelp,
  _BusinessPartner.BPLastNameSearchHelp AS BPLastNameSearchHelp,
  _BusinessPartner.BusinessPartnerCategory AS BusinessPartnerCategory,
  _BusinessPartner.BusinessPartnerGrouping AS BusinessPartnerGrouping,
  _BusinessPartner.BusinessPartnerIsBlocked AS BusinessPartnerIsBlocked,
  _BusinessPartner.CreatedByUser AS CreatedByUser,
  _BusinessPartner.CreationDate AS CreationDate,
  _BusinessPartner.FirstName AS FirstName,
  _BusinessPartner.GenderCodeName AS GenderCodeName,
  _BusinessPartner.IsMarkedForArchiving AS IsMarkedForArchiving,
  _BusinessPartner.IsNaturalPerson AS IsNaturalPerson,
  _BusinessPartner.LastChangeDate AS LastChangeDate,
  _BusinessPartner.LastChangedByUser AS LastChangedByUser,
  _BusinessPartner.LastName AS LastName,
  _BusinessPartner.LegalForm AS LegalForm,
  _BusinessPartner.OrganizationBPName1 AS OrganizationBPName1,
  _BusinessPartner.OrganizationBPName2 AS OrganizationBPName2,
  _BusinessPartner.OrganizationFoundationDate AS OrganizationFoundationDate,
  _BusinessPartner.SearchTerm1 AS SearchTerm1,
  _BusinessPartner.SearchTerm2 AS SearchTerm2,
  _BusinessPartner._DefaultAddress._AddressDefaultRepresentation.StreetName AS StreetName,
  _BusinessPartner._AcademicTitleValueHelp AS _AcademicTitleValueHelp,
  _MDQAnlytsScrBPSuplrPur.MDQltyNmbrOfSuccssflEvalRslts AS MDQltyNmbrOfSuccssflEvalRslts,
  _MDQAnlytsScrBPSuplrPur.MDQltyNmbrOfFailedEvalRslts AS MDQltyNmbrOfFailedEvalRslts,
  _MDQAnlytsScrBPSuplrPur.MDQltyNmbrOfBusRuleEvalResults AS MDQltyNmbrOfBusRuleEvalResults
FROM I_MDQAnlytsScrBPSuplrPur AS _MDQAnlytsScrBPSuplrPur
LEFT OUTER JOIN I_CnsldtnIndustryT AS _CnsldtnIndustryT ON _CnsldtnIndustryT.Industry = industry  -- association [0..*]
LEFT OUTER JOIN I_Country AS _Country ON _Country.Country = country  -- association [1..1]
LEFT OUTER JOIN I_ProcurementBlockText AS _ProcurementBlockText ON _ProcurementBlockText.ProcurementBlock = supplierprocurementblock  -- association [0..*]
LEFT OUTER JOIN I_RegionText AS _RegionText ON _RegionText.Region = region AND _RegionText.Country = country  -- association [0..*]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [1..1]
LEFT OUTER JOIN I_SupplierAccountGroup AS _SupplierAccountGroup ON _SupplierAccountGroup.SupplierAccountGroup = supplieraccountgroup  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON _Currency.Currency = purchaseordercurrency  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON _PaymentTerms.PaymentTerms = paymentterms  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON _PurchasingGroup.PurchasingGroup = purchasinggroup  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON _PurchasingOrganization.PurchasingOrganization = PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_SupplierPurchasingOrg AS _SupplierPurchasingOrg ON _SupplierPurchasingOrg.Supplier = Supplier AND _SupplierPurchasingOrg.PurchasingOrganization = PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_BPGenderValueHelpText AS _GenderText ON _GenderText.GenderCodeName = gendercodename  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON _BusinessPartner.BusinessPartner = BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartnerGroupingText AS _BusinessPartnerGroupingText ON _BusinessPartnerGroupingText.BusinessPartnerGrouping = businesspartnergrouping  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartnerLegalFormText AS _BusinessPartnerLegalFormText ON _BusinessPartnerLegalFormText.LegalForm = legalform  -- association [0..*]
LEFT OUTER JOIN I_MDQltyBusinessRuleBaseTableT AS _MDQBusinessRuleBaseTableText ON _MDQBusinessRuleBaseTableText.MDQltyBusinessObjectTypeCode = '147' AND _MDQBusinessRuleBaseTableText.MDQltyBusinessRuleBaseTable = MDQltyBusinessRuleBaseTable  -- association [0..*]
LEFT OUTER JOIN I_MDQltyFioriLaunchpadHostPath AS _MDQltyFioriLaunchpadHostPath ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_MDQltyScoreEvalDetails AS _MDQltyScoreEvalDetails ON _MDQltyScoreEvalDetails.MasterDataChangeProcess = MasterDataChangeProcess  -- association [1..1]
LEFT OUTER JOIN I_MDQualityBusinessRule AS _MDQualityBusinessRule ON _MDQualityBusinessRule.MDQualityBusinessRuleUUID = MDQualityBusinessRuleUUID  -- association [1..1]
LEFT OUTER JOIN I_User AS _UserChangedBy ON _UserChangedBy.UserID = lastchangedbyuser  -- association [0..1]
LEFT OUTER JOIN I_User AS _UserCreatedBy ON _UserCreatedBy.UserID = createdbyuser  -- association [0..1]
LEFT OUTER JOIN I_User AS _UserRuleOwner ON _UserRuleOwner.UserID = MDQltyBusinessRuleOwner  -- association [0..1]
LEFT OUTER JOIN E_BP_D AS _BusinessPartnerExtension ON _BusinessPartnerExtension.BusinessPartner = BusinessPartner  -- association [0..1]
LEFT OUTER JOIN E_Supplier AS _SupplierExtension ON _SupplierExtension.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN E_BPPURORG_D AS _PurchaseExtension ON _PurchaseExtension.Supplier = Supplier AND _PurchaseExtension.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
;