I_MDQAnlytsScrCustCoCodeC

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_MDQAnlytsScrCustCoCodeC.
-- 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_MDQAnlytsScrCustCoCodeC AS
SELECT
  _MDQAnlytsScrBPCustCoCode.MasterDataChangeProcess AS MasterDataChangeProcess,
  _MDQAnlytsScrBPCustCoCode.BusinessPartner AS BusinessPartner,
  _MDQAnlytsScrBPCustCoCode.CompanyCode AS CompanyCode,
  _MDQAnlytsScrBPCustCoCode.MDQualityBusinessRuleUUID AS MDQualityBusinessRuleUUID,
  _MDQAnlytsScrBPCustCoCode.MDQltyBusRuleEvalResultCode AS MDQltyBusRuleEvalResultCode,
  _Customer.AlternativePayeeIsAllowed AS AlternativePayeeIsAllowed,
  _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,
  _CustomerCompanyCode.AuthorizationGroup AS AuthorizationGroup,
  _CustomerCompanyCode.CashPlanningGroup AS CashPlanningGroup,
  _CustomerCompanyCode.CustomerHeadOffice AS CustomerHeadOffice,
  _CustomerCompanyCode.DunningBlock AS DunningBlock,
  _CustomerCompanyCode.DunningLevel AS DunningLevel,
  _CustomerCompanyCode.DunningProcedure AS DunningProcedure,
  _CustomerCompanyCode.HouseBank AS HouseBank,
  _CustomerCompanyCode.PaymentBlockingReason AS PaymentBlockingReason,
  _CustomerCompanyCode.PaymentReason AS PaymentReason,
  _CustomerCompanyCode.PaymentTerms AS PaymentTerms,
  _CustomerCompanyCode.PhysicalInventoryBlockInd AS PhysicalInventoryBlockInd,
  _CustomerCompanyCode.ReconciliationAccount AS ReconciliationAccount,
  _CustomerCompanyCode.SupplierReleaseGroup AS SupplierReleaseGroup,
  _MDQAnlytsScrBPCustCoCode._MasterDataChangeProcess.MDChgProcessFinishDate AS MDChgProcessFinishDate,
  _MDQltyScoreEvalDetails.MDChgProcessIsLatest AS MDChgProcessIsLatest,
  _MDQAnlytsScrBPCustCoCode.MDQltyBusinessRuleBaseTable AS MDQltyBusinessRuleBaseTable,
  _MDQBusinessRuleBaseTableText[1:Language=$session.system_language].MDQltyBusinessRuleBaseTabName AS MDQltyBusinessRuleBaseTabName,
  _MDQAnlytsScrBPCustCoCode.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,
  _MDQAnlytsScrBPCustCoCode.MDQltyNmbrOfSuccssflEvalRslts AS MDQltyNmbrOfSuccssflEvalRslts,
  _MDQAnlytsScrBPCustCoCode.MDQltyNmbrOfFailedEvalRslts AS MDQltyNmbrOfFailedEvalRslts,
  _MDQAnlytsScrBPCustCoCode.MDQltyNmbrOfBusRuleEvalResults AS MDQltyNmbrOfBusRuleEvalResults
FROM I_MDQAnlytsScrBPCustCoCode AS _MDQAnlytsScrBPCustCoCode
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_CompanyCode AS _CompanyCode ON _CompanyCode.CompanyCode = CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _CustomerHeadOffice ON _CustomerHeadOffice.Customer = customerheadoffice  -- association [1..1]
LEFT OUTER JOIN I_CustomerCompany AS _CustomerCompanyCode ON _CustomerCompanyCode.Customer = Customer AND _CustomerCompanyCode.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_DunningBlockingReasonCode AS _DunningBlock ON _DunningBlock.DunningBlockingReason = dunningblock  -- association [1..1]
LEFT OUTER JOIN I_PaymentBlockingReason AS _PaymentBlockingReason ON _PaymentBlockingReason.PaymentBlockingReason = paymentblockingreason  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON _PaymentTerms.PaymentTerms = paymentterms  -- 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_CUSCO_D AS _CustomerCompanyCodeExtension ON _CustomerCompanyCodeExtension.Customer = Customer AND _CustomerCompanyCodeExtension.CompanyCode = CompanyCode  -- association [0..1]
;