I_MDQAnlytsScrSuplrCoCodeC

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_MDQAnlytsScrSuplrCoCodeC.
-- 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_MDQAnlytsScrSuplrCoCodeC AS
SELECT
  _MDQAnlytsScrBPSuplrCoCode.MasterDataChangeProcess AS MasterDataChangeProcess,
  _MDQAnlytsScrBPSuplrCoCode.BusinessPartner AS BusinessPartner,
  _MDQAnlytsScrBPSuplrCoCode.MDQualityBusinessRuleUUID AS MDQualityBusinessRuleUUID,
  _MDQAnlytsScrBPSuplrCoCode.MDQltyBusRuleEvalResultCode AS MDQltyBusRuleEvalResultCode,
  _MDQAnlytsScrBPSuplrCoCode.CompanyCode AS CompanyCode,
  _MDQAnlytsScrBPSuplrCoCode._MasterDataChangeProcess.MDChgProcessFinishDate AS MDChgProcessFinishDate,
  _MDQltyScoreEvalDetails.MDChgProcessIsLatest AS MDChgProcessIsLatest,
  _MDQAnlytsScrBPSuplrCoCode.MDQltyBusinessRuleBaseTable AS MDQltyBusinessRuleBaseTable,
  _MDQBusinessRuleBaseTableText[1:Language=$session.system_language].MDQltyBusinessRuleBaseTabName AS MDQltyBusinessRuleBaseTabName,
  _MDQAnlytsScrBPSuplrCoCode.MDQltyBusinessRuleOwner AS MDQltyBusinessRuleOwner,
  _MDQltyBusRule.MDQltyBusRuleCheckedField AS MDQltyBusRuleCheckedField,
  _MDQltyBusRule.MDQltyBusRuleCheckedFieldTable AS MDQltyBusRuleCheckedFieldTable,
  _MDQltyBusRule.MDQltyBusRuleChkdFieldAndTable AS MDQltyBusRuleChkdFieldAndTable,
  _MDQltyBusRule.MDQualityBusinessRule AS MDQualityBusinessRule,
  _MDQltyBusRule.MDQualityBusinessRuleName AS MDQualityBusinessRuleName,
  Supplier,
  _Supplier.AlternativePayeeIsAllowed AS AlternativePayeeIsAllowed,
  _Supplier.Industry AS Industry,
  _Supplier.PaymentIsBlockedForSupplier AS PaymentIsBlockedForSupplier,
  _Supplier.PostingIsBlocked AS PostingIsBlocked,
  _Supplier.PurchasingIsBlocked AS PurchasingIsBlocked,
  _Supplier.SupplierProcurementBlock AS SupplierProcurementBlock,
  _Supplier.ResponsibleType AS ResponsibleType,
  _Supplier.SuplrProofOfDelivRlvtCode AS SuplrProofOfDelivRlvtCode,
  _Supplier.CityName AS CityName,
  _Supplier.Country AS Country,
  _Supplier.PostalCode AS PostalCode,
  _Supplier.Region AS Region,
  _Supplier.SuplrQualityManagementSystem AS SuplrQualityManagementSystem,
  _Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _Supplier.SupplierCorporateGroup AS SupplierCorporateGroup,
  _Supplier.SupplierIsPlantRelevant AS SupplierIsPlantRelevant,
  _Supplier.SupplierIsSubRangeRelevant AS SupplierIsSubRangeRelevant,
  _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,
  _SupplierCompanyCode.PaymentBlockingReason AS PaymentBlockingReason,
  _SupplierCompanyCode.SupplierIsBlockedForPosting AS SupplierIsBlockedForPosting,
  _SupplierCompanyCode.AccountingClerk AS AccountingClerk,
  _SupplierCompanyCode.SupplierClerk AS SupplierClerk,
  _SupplierCompanyCode.PaymentTerms AS PaymentTerms,
  _SupplierCompanyCode.HouseBank AS HouseBank,
  _SupplierCompanyCode.Currency AS Currency,
  _SupplierCompanyCode.ReconciliationAccount AS ReconciliationAccount,
  _SupplierCompanyCode.WithholdingTaxCountry AS WithholdingTaxCountry,
  _SupplierCompanyCode.CashPlanningGroup AS CashPlanningGroup,
  _SupplierCompanyCode.SupplierReleaseGroup AS SupplierReleaseGroup,
  _SupplierCompanyCode.PaymentMethodSupplement AS PaymentMethodSupplement,
  _SupplierCompanyCode.PaymentReason AS PaymentReason,
  _SupplierCompanyCode.AuthorizationGroup AS AuthorizationGroup,
  _BusinessPartner._AcademicTitleValueHelp AS _AcademicTitleValueHelp,
  _MDQAnlytsScrBPSuplrCoCode.MDQltyNmbrOfSuccssflEvalRslts AS MDQltyNmbrOfSuccssflEvalRslts,
  _MDQAnlytsScrBPSuplrCoCode.MDQltyNmbrOfFailedEvalRslts AS MDQltyNmbrOfFailedEvalRslts,
  _MDQAnlytsScrBPSuplrCoCode.MDQltyNmbrOfBusRuleEvalResults AS MDQltyNmbrOfBusRuleEvalResults
FROM I_MDQAnlytsScrBPSuplrCoCode AS _MDQAnlytsScrBPSuplrCoCode
LEFT OUTER JOIN I_CnsldtnIndustryT AS _CnsldtnIndustryT ON _CnsldtnIndustryT.Industry = industry  -- association [0..*]
LEFT OUTER JOIN I_PaymentReasonText AS _PaymentReasonText ON _PaymentReasonText.PaymentReason = paymentreason  -- association [0..*]
LEFT OUTER JOIN I_ProcurementBlockText AS _ProcurementBlockText ON _ProcurementBlockText.ProcurementBlock = supplierprocurementblock  -- association [0..*]
LEFT OUTER JOIN I_SupplierAccountGroup AS _SupplierAccountGroup ON _SupplierAccountGroup.SupplierAccountGroup = supplieraccountgroup  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON _BusinessPartner.BusinessPartner = BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_Country AS _Country ON _Country.Country = country  -- association [1..1]
LEFT OUTER JOIN I_Country AS _CountryTaxCode ON _CountryTaxCode.Country = withholdingtaxcountry  -- association [1..1]
LEFT OUTER JOIN I_MDQltyBusinessRuleBaseTableT AS _MDQBusinessRuleBaseTableText ON _MDQBusinessRuleBaseTableText.MDQltyBusinessObjectTypeCode = '147' AND _MDQBusinessRuleBaseTableText.MDQltyBusinessRuleBaseTable = MDQltyBusinessRuleBaseTable  -- association [0..*]
LEFT OUTER JOIN I_MDQltyFioriLaunchpadHostPath AS _FLPHostPath 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 _MDQltyBusRule ON _MDQltyBusRule.MDQualityBusinessRuleUUID = MDQualityBusinessRuleUUID  -- association [1..1]
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_SupplierCompany AS _SupplierCompanyCode ON _SupplierCompanyCode.Supplier = Supplier AND _SupplierCompanyCode.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _CompanyCode.CompanyCode = CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON _PaymentTerms.PaymentTerms = paymentterms  -- association [1..1]
LEFT OUTER JOIN I_User AS _UserRuleOwner ON _UserRuleOwner.UserID = MDQltyBusinessRuleOwner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerGroupingText AS _BusinessPartnerGroupingText ON _BusinessPartnerGroupingText.BusinessPartnerGrouping = businesspartnergrouping  -- association [0..*]
LEFT OUTER JOIN I_User AS _UserCreatedBy ON _UserCreatedBy.UserID = createdbyuser  -- association [0..1]
LEFT OUTER JOIN I_BPGenderValueHelpText AS _GenderText ON _GenderText.GenderCodeName = gendercodename  -- association [0..*]
LEFT OUTER JOIN I_User AS _UserChangedBy ON _UserChangedBy.UserID = lastchangedbyuser  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerLegalFormText AS _BusinessPartnerLegalFormText ON _BusinessPartnerLegalFormText.LegalForm = legalform  -- association [0..*]
LEFT OUTER JOIN I_PaymentBlockingReason AS _PaymentBlockingReason ON _PaymentBlockingReason.PaymentBlockingReason = paymentblockingreason  -- association [0..1]
LEFT OUTER JOIN I_AccountingClerk AS _AccountingClerk ON _AccountingClerk.CompanyCode = CompanyCode AND _AccountingClerk.AccountingClerk = accountingclerk  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON _Currency.Currency = currency  -- association [0..1]
LEFT OUTER JOIN I_CashPlanningGroup AS _CashPlanningGroup ON cashplanninggroup = _CashPlanningGroup.CashPlanningGroup  -- association [0..1]
LEFT OUTER JOIN I_DocumentInfoRecordAuthznGrp AS _DocumentInfoRecordAuthznGrp ON _DocumentInfoRecordAuthznGrp.AuthorizationGroup = authorizationgroup  -- association [0..1]
LEFT OUTER JOIN E_Supplier AS _SupplierExtension ON _SupplierExtension.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN E_BP_D AS _BusinessPartnerExtension ON _BusinessPartnerExtension.BusinessPartner = BusinessPartner  -- association [0..1]
LEFT OUTER JOIN E_SUPCO_D AS _CompanyCodeExtension ON Supplier = _CompanyCodeExtension.Supplier  -- association [0..1]
;