I_MDQAnlytsScrCustSlsC

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_MDQAnlytsScrCustSlsC.
-- 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_MDQAnlytsScrCustSlsC AS
SELECT
  _MDQAnlytsScrBPCustSls.MasterDataChangeProcess AS MasterDataChangeProcess,
  _MDQAnlytsScrBPCustSls.BusinessPartner AS BusinessPartner,
  _MDQAnlytsScrBPCustSls.SalesOrganization AS SalesOrganization,
  _MDQAnlytsScrBPCustSls.DistributionChannel AS DistributionChannel,
  _MDQAnlytsScrBPCustSls.Division AS Division,
  _MDQAnlytsScrBPCustSls.MDQualityBusinessRuleUUID AS MDQualityBusinessRuleUUID,
  _MDQAnlytsScrBPCustSls.MDQltyBusRuleEvalResultCode AS MDQltyBusRuleEvalResultCode,
  _Customer.AlternativePayeeIsAllowed AS AlternativePayeeIsAllowed,
  _Customer.CityName AS CityName,
  _Customer.Country AS Country,
  Customer,
  _Customer.CustomerAccountGroup AS CustomerAccountGroup,
  _Customer.CustomerClassification AS CustomerClassification,
  _Customer.CustomerCorporateGroup AS CustomerCorporateGroup,
  _Customer.DeliveryIsBlocked AS DeliveryIsBlocked,
  _Customer.Industry AS Industry,
  _Customer.IsSalesProspect AS IsSalesProspect,
  _Customer.NielsenRegion AS NielsenRegion,
  _Customer.PaymentIsBlockedForCustomer AS PaymentIsBlockedForCustomer,
  _Customer.PostalCode AS PostalCode,
  _Customer.PostingIsBlocked AS PostingIsBlocked,
  _Customer.Region AS Region,
  _CustomerSalesArea.AuthorizationGroup AS AuthorizationGroup,
  _CustomerSalesArea.BillingIsBlockedForCustomer AS BillingIsBlockedForCustomer,
  _CustomerSalesArea.Currency AS Currency,
  _CustomerSalesArea.CustomerGroup AS CustomerGroup,
  _CustomerSalesArea.OrderIsBlockedForCustomer AS OrderIsBlockedForCustomer,
  _CustomerSalesArea.PaymentTerms AS PaymentTerms,
  _CustomerSalesArea.SalesDistrict AS SalesDistrict,
  _CustomerSalesArea.SalesGroup AS SalesGroup,
  _CustomerSalesArea.SalesOffice AS SalesOffice,
  _MDQAnlytsScrBPCustSls._MasterDataChangeProcess.MDChgProcessFinishDate AS MDChgProcessFinishDate,
  _MDQltyScoreEvalDetails.MDChgProcessIsLatest AS MDChgProcessIsLatest,
  _MDQAnlytsScrBPCustSls.MDQltyBusinessRuleBaseTable AS MDQltyBusinessRuleBaseTable,
  _MDQBusinessRuleBaseTableText[1:Language=$session.system_language].MDQltyBusinessRuleBaseTabName AS MDQltyBusinessRuleBaseTabName,
  _MDQAnlytsScrBPCustSls.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,
  _CustomerSalesArea._BillingIsBlockedForCustomer AS _BillingIsBlockedForCustomer,
  _MDQAnlytsScrBPCustSls.MDQltyNmbrOfSuccssflEvalRslts AS MDQltyNmbrOfSuccssflEvalRslts,
  _MDQAnlytsScrBPCustSls.MDQltyNmbrOfFailedEvalRslts AS MDQltyNmbrOfFailedEvalRslts,
  _MDQAnlytsScrBPCustSls.MDQltyNmbrOfBusRuleEvalResults AS MDQltyNmbrOfBusRuleEvalResults
FROM I_MDQAnlytsScrBPCustSls AS _MDQAnlytsScrBPCustSls
LEFT OUTER JOIN I_Country AS _Country ON _Country.Country = country  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON _Customer.Customer = Customer  -- association [1..1]
LEFT OUTER JOIN I_CustomerAccountGroup AS _CustomerAccountGroup ON _CustomerAccountGroup.CustomerAccountGroup = customeraccountgroup  -- association [0..1]
LEFT OUTER JOIN I_CustomerClassification AS _CustomerClassification ON _CustomerClassification.CustomerClassification = customerclassification  -- association [0..1]
LEFT OUTER JOIN I_CustomerSupplierIndustry AS _CustomerSupplierIndustry ON _CustomerSupplierIndustry.Industry = industry  -- association [0..1]
LEFT OUTER JOIN I_DeliveryBlockReason AS _DeliveryBlockReason ON _DeliveryBlockReason.DeliveryBlockReason = deliveryisblocked  -- association [0..1]
LEFT OUTER JOIN I_RegionText AS _RegionText ON _RegionText.Region = region AND _RegionText.Country = country  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _Currency ON _Currency.Currency = currency  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroup AS _CustomerGroup ON _CustomerGroup.CustomerGroup = customergroup  -- association [1..1]
LEFT OUTER JOIN I_CustomerPaymentTerms AS _CustomerPaymentTerms ON _CustomerPaymentTerms.CustomerPaymentTerms = paymentterms  -- association [1..1]
LEFT OUTER JOIN I_CustomerSalesArea AS _CustomerSalesArea ON _CustomerSalesArea.Customer = Customer AND _CustomerSalesArea.SalesOrganization = SalesOrganization AND _CustomerSalesArea.DistributionChannel = DistributionChannel AND _CustomerSalesArea.Division = Division  -- association [1..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON _DistributionChannel.DistributionChannel = DistributionChannel  -- association [1..1]
LEFT OUTER JOIN I_Division AS _Division ON _Division.Division = Division  -- association [1..1]
LEFT OUTER JOIN I_SalesDistrict AS _SalesDistrict ON _SalesDistrict.SalesDistrict = salesdistrict  -- association [1..1]
LEFT OUTER JOIN I_SalesGroup AS _SalesGroup ON _SalesGroup.SalesGroup = salesgroup  -- association [1..1]
LEFT OUTER JOIN I_SalesOffice AS _SalesOffice ON _SalesOffice.SalesOffice = salesoffice  -- association [1..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON _SalesOrganization.SalesOrganization = SalesOrganization  -- 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_Customer AS _CustomerExtension ON _CustomerExtension.Customer = Customer  -- association [0..1]
LEFT OUTER JOIN E_BPSALESAREA_D AS _CustomerSalesAreaExtension ON _CustomerSalesAreaExtension.Customer = Customer AND _CustomerSalesAreaExtension.SalesOrganization = SalesOrganization AND _CustomerSalesAreaExtension.DistributionChannel = DistributionChannel AND _CustomerSalesAreaExtension.Division = Division  -- association [0..1]
;