I_MDQAnlytsScrCustC

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_MDQAnlytsScrCustC.
-- 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_MDQAnlytsScrCustC AS
SELECT
  _MDQAnlytsScrBPCust.MasterDataChangeProcess AS MasterDataChangeProcess,
  _MDQAnlytsScrBPCust.BusinessPartner AS BusinessPartner,
  _MDQAnlytsScrBPCust.MDQualityBusinessRuleUUID AS MDQualityBusinessRuleUUID,
  _MDQAnlytsScrBPCust.MDQltyBusRuleEvalResultCode AS MDQltyBusRuleEvalResultCode,
  _Customer.AlternativePayeeIsAllowed AS AlternativePayeeIsAllowed,
  _Customer.AuthorizationGroup AS AuthorizationGroup,
  _Customer.BillingIsBlockedForCustomer AS BillingIsBlockedForCustomer,
  _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.OrderIsBlockedForCustomer AS OrderIsBlockedForCustomer,
  _Customer.PaymentIsBlockedForCustomer AS PaymentIsBlockedForCustomer,
  _Customer.PostalCode AS PostalCode,
  _Customer.PostingIsBlocked AS PostingIsBlocked,
  _Customer.Region AS Region,
  _MDQAnlytsScrBPCust._MasterDataChangeProcess.MDChgProcessFinishDate AS MDChgProcessFinishDate,
  _MDQltyScoreEvalDetails.MDChgProcessIsLatest AS MDChgProcessIsLatest,
  _MDQAnlytsScrBPCust.MDQltyBusinessRuleBaseTable AS MDQltyBusinessRuleBaseTable,
  _MDQBusinessRuleBaseTableText[1:Language=$session.system_language].MDQltyBusinessRuleBaseTabName AS MDQltyBusinessRuleBaseTabName,
  _MDQAnlytsScrBPCust.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,
  _MDQAnlytsScrBPCust.MDQltyNmbrOfSuccssflEvalRslts AS MDQltyNmbrOfSuccssflEvalRslts,
  _MDQAnlytsScrBPCust.MDQltyNmbrOfFailedEvalRslts AS MDQltyNmbrOfFailedEvalRslts,
  _MDQAnlytsScrBPCust.MDQltyNmbrOfBusRuleEvalResults AS MDQltyNmbrOfBusRuleEvalResults
FROM I_MDQAnlytsScrBPCust AS _MDQAnlytsScrBPCust
LEFT OUTER JOIN I_BillingBlockReason AS _BillingBlockReason ON _BillingBlockReason.BillingBlockReason = billingisblockedforcustomer  -- association [0..1]
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_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]
;