C_MDQltyBPCustSalesAreaResult

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 C_MDQltyBPCustSalesAreaResult.
-- 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.
-- SQL view name: CMDQBPCUSTSARSLT

CREATE VIEW C_MDQltyBPCustSalesAreaResult AS
SELECT
  MasterDataChangeProcess,
  MDQualityBusinessRuleUUID,
  MDQltyBusRuleEvalResultCode,
  MDQltyNmbrOfBusRuleEvalResults,
  MDQltyBusinessRuleBaseTable,
  / _MDQualityBusinessRuleTP.MDQualityBusinessRuleName AS MDQualityBusinessRuleName,
  _Customer._CustomerClassification._Text[1:Language=$session.system_language ].CustomerClassificationDesc AS CustomerClassificationDesc,
  _Customer._CustomerAccountGroupText[1:Language=$session.system_language ].AccountGroupName AS AccountGroupName,
  _Customer._StandardAddress._Country._Text[1:Language=$session.system_language ].CountryName AS CountryName,
  _BusinessPartner._BPGroupingText[1:Language=$session.system_language ].BusinessPartnerGroupingText AS BusinessPartnerGroupingText,
  _BusinessPartner._BPCatHelpText[1:Language=$session.system_language ].BusinessPartnerCategoryText AS BusinessPartnerCategoryText,
  _MDQltyBusinessRuleBaseTblVH._MDQltyBusinessRuleBaseTableT[1:Language=$session.system_language ].MDQltyBusinessRuleBaseTabName AS MDQltyBusinessRuleBaseTabName,
  _BPCustSalesAreaResult._MDQltyBusRuleEvalResultText[1:Language=$session.system_language ].MDQltyBusRuleEvalResultCodeTxt AS MDQltyBusRuleEvalResultCodeTxt,
  / _MDQltyBusRuleEvalResultText AS _MDQltyBusRuleEvalResultText,
  _BPCustSalesAreaResult.BusinessPartner AS BusinessPartner,
  _BPCustSalesAreaResult.Customer AS Customer,
  _BPCustSalesAreaResult.SalesOrganization AS SalesOrganization,
  _BPCustSalesAreaResult.DistributionChannel AS DistributionChannel,
  _BPCustSalesAreaResult.Division AS Division,
  _BPCustSalesAreaResult.AddressNumber AS AddressNumber,
  _BusinessPartner.BusinessPartnerForEdit AS BusinessPartnerForEdit,
  _BusinessPartner.BusinessPartnerCategory AS BusinessPartnerCategory,
  _BusinessPartner.SearchTerm1 AS SearchTerm1,
  _BusinessPartner.SearchTerm2 AS SearchTerm2,
  _BusinessPartner.BusinessPartnerGrouping AS BusinessPartnerGrouping,
  _BusinessPartner.BusinessPartnerIsBlocked AS BusinessPartnerIsBlocked,
  _BusinessPartner.FirstName AS FirstName,
  _BusinessPartner.LastName AS LastName,
  _BusinessPartner.OrganizationBPName1 AS OrganizationBPName1,
  _BusinessPartner.OrganizationBPName2 AS OrganizationBPName2,
  _BusinessPartner.OrganizationBPName3 AS OrganizationBPName3,
  _BusinessPartner.OrganizationBPName4 AS OrganizationBPName4,
  _BusinessPartner.AuthorizationGroup AS AuthorizationGroupObject,
  _BusinessPartner.FullName AS FullName,
  _BusinessPartner.DataControllerSet AS DataControllerSet,
  _BusinessPartner.DataController1 AS DataController1,
  _BusinessPartner.DataController2 AS DataController2,
  _BusinessPartner.DataController3 AS DataController3,
  _BusinessPartner.DataController4 AS DataController4,
  _BusinessPartner.DataController5 AS DataController5,
  _BusinessPartner.DataController6 AS DataController6,
  _BusinessPartner.DataController7 AS DataController7,
  _BusinessPartner.DataController8 AS DataController8,
  _BusinessPartner.DataController9 AS DataController9,
  _BusinessPartner.DataController10 AS DataController10,
  _BusinessPartner._GroupingValueHelp AS _GroupingValueHelp,
  _BusinessPartner._CategoryValueHelp AS _CategoryValueHelp,
  _Customer.CustomerAccountGroup AS CustomerAccountGroup,
  _Customer.AuthorizationGroup AS CustomerAuthznGrp,
  _Customer.CustomerCorporateGroup AS CustomerCorporateGroup,
  _Customer.OrderIsBlockedForCustomer AS OrderIsBlockedForCustomer,
  _Customer.CustomerClassification AS CustomerClassification,
  _Customer.NielsenRegion AS NielsenRegion,
  _Customer.Country AS Country,
  _Customer.PostalCode AS PostalCode,
  _Customer.CityName AS CityName,
  _CustSalesArea.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _CustSalesArea.AuthorizationGroup AS AuthorizationGroup,
  _CustSalesArea.SalesDistrict AS SalesDistrict,
  _CustSalesArea.CustomerGroup AS CustomerGroup,
  _CustSalesArea.SalesOffice AS SalesOffice,
  _CustSalesArea.SalesGroup AS SalesGroup,
  _CustSalesArea.DivisionName AS DivisionName,
  _CustSalesArea.SalesOrganizationName AS SalesOrganizationName,
  _CustSalesArea.DistributionChannelName AS DistributionChannelName,
  _CustSalesArea.SalesDistrictName AS SalesDistrictName,
  _CustSalesArea.CustomerGroupName AS CustomerGroupName,
  _CustSalesArea.SalesOfficeName AS SalesOfficeName,
  _CustSalesArea.SalesGroupName AS SalesGroupName,
  _CustSalesArea._BPAuthorizationGroupVH AS _BPAuthorizationGroupVH,
  _CustSalesArea._CustomerGroupValueHelp AS _CustomerGroupValueHelp,
  _CustSalesArea._SalesDistrictValueHelp AS _SalesDistrictValueHelp,
  _CustSalesArea._SalesGroupValueHelp AS _SalesGroupValueHelp,
  _CustSalesArea._SalesOfficeValueHelp AS _SalesOfficeValueHelp,
  _MDQualityBusinessRuleTP.MDQltyBusinessObjectTypeCode AS MDQltyBusinessObjectTypeCode,
  _MDQualityBusinessRuleTP.MDQualityBusinessRule AS MDQualityBusinessRule,
  _MDQualityBusinessRuleTP.MDQltyTechnicalRuleScopeUUID AS MDQltyTechnicalRuleScopeUUID,
  _MDQualityBusinessRuleTP.MDQltyTechnicalRuleCndnUUID AS MDQltyTechnicalRuleCndnUUID,
  _MDQualityBusinessRuleTP.MDQltyMDGovBRFPlusObjectUUID AS MDQltyMDGovBRFPlusObjectUUID,
  _MDQualityBusinessRuleTP.MDQltyBusRuleCheckedFieldTable AS MDQltyBusRuleCheckedFieldTable,
  _MDQualityBusinessRuleTP.MDQltyBusRuleCheckedField AS MDQltyBusRuleCheckedField,
  _MDQualityBusinessRuleTP.MDQltyBusRuleChkdFieldAndTable AS MDQltyBusRuleChkdFieldAndTable,
  _MDQualityBusinessRuleTP._MDQltyBusRuleCheckedFieldVH AS _MDQltyBusRuleCheckedFieldVH,
  _MDQualityBusinessRuleTP._MDQltyBusRuleChkdFieldText AS _MDQltyBusRuleChkdFieldText,
  _MDQualityEvaluations.MDChgProcessFinishDateTime AS MDChgProcessFinishDateTime,
  _MDQualityRAPBasedSwitch.MDChgProcRAPBsdSwitchIsActive AS MDChgProcRAPBsdSwitchIsActive
FROM I_MDQltyBPCustSalesAreaResult AS _BPCustSalesAreaResult
LEFT OUTER JOIN C_MDQualityEvaluations AS _MDQualityEvaluations ON _MDQualityEvaluations.MasterDataChangeProcess = MasterDataChangeProcess  -- association [1..1]
LEFT OUTER JOIN C_MDQualityBusinessRuleTP AS _MDQualityBusinessRuleTP ON _MDQualityBusinessRuleTP.MDQualityBusinessRuleUUID = MDQualityBusinessRuleUUID  -- association [1..1]
LEFT OUTER JOIN C_MDQltyBusinessRuleVH AS _MDQltyBusinessRuleQuickView ON _MDQltyBusinessRuleQuickView.MDQualityBusinessRule = mdqualitybusinessrule AND _MDQltyBusinessRuleQuickView.MDQltyBusinessObjectTypeCode = mdqltybusinessobjecttypecode  -- association [1..1]
LEFT OUTER JOIN C_MDQltyBusinessRuleBaseTblVH AS _MDQltyBusinessRuleBaseTblVH ON _MDQltyBusinessRuleBaseTblVH.MDQltyBusinessRuleBaseTable = MDQltyBusinessRuleBaseTable AND _MDQltyBusinessRuleBaseTblVH.MDQltyBusinessObjectTypeCode = '147'  -- association [1..1]
LEFT OUTER JOIN I_MDQualityRAPBasedSwitch AS _MDQualityRAPBasedSwitch ON _MDQualityRAPBasedSwitch.MDQltyBusinessObjectTypeCode = '147'  -- association [0..1]
LEFT OUTER JOIN C_MDQltyBusinessPartnerDetail AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_MDQltyCustSalesAreaDetail AS _CustSalesArea ON _CustSalesArea.Customer = Customer AND _CustSalesArea.DistributionChannel = DistributionChannel AND _CustSalesArea.SalesOrganization = SalesOrganization AND _CustSalesArea.Division = Division  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN C_SalesOrgVHTemp AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization AND DistributionChannel = _SalesOrganization.DistributionChannel AND Division = _SalesOrganization.Division  -- association [0..1]
LEFT OUTER JOIN C_SalesOrgVHTemp AS _DistributionChannel ON SalesOrganization = _DistributionChannel.SalesOrganization AND DistributionChannel = _DistributionChannel.DistributionChannel AND Division = _DistributionChannel.Division  -- association [0..1]
LEFT OUTER JOIN C_SalesOrgVHTemp AS _Division ON SalesOrganization = _Division.SalesOrganization AND DistributionChannel = _Division.DistributionChannel AND Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_CountryVH AS _CountryVH ON country = _CountryVH.Country  -- association [0..1]
LEFT OUTER JOIN I_CustomerAccountGroupStdVH AS _AccountGroupValueHelp ON customeraccountgroup = _AccountGroupValueHelp.CustomerAccountGroup  -- association [0..1]
LEFT OUTER JOIN I_CustomerClassification AS _CustomerClassificationVH ON customerclassification = _CustomerClassificationVH.CustomerClassification  -- association [0..1]
LEFT OUTER JOIN C_OrderIsBlockedTextVHTemp AS _OrderIsBlockedTextVH ON orderisblockedforcustomer = _OrderIsBlockedTextVH.OrderIsBlockedForCustomer AND _OrderIsBlockedTextVH.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_AllocationCustGroupKeyVH AS _GroupKeyVH ON customercorporategroup = _GroupKeyVH.CustomerCorporateGroup  -- association [0..1]
LEFT OUTER JOIN C_MDQltyBusPartQuickView AS _MDQltyBusPartQuickView ON BusinessPartner = _MDQltyBusPartQuickView.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN E_BP_D AS _BusinessPartnerExtension ON BusinessPartner = _BusinessPartnerExtension.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN E_Customer AS _CustomerExtension ON Customer = _CustomerExtension.Customer  -- association [0..1]
LEFT OUTER JOIN E_BPSALESAREA_D AS _SalesExtension ON Customer = _SalesExtension.Customer AND SalesOrganization = _SalesExtension.SalesOrganization AND DistributionChannel = _SalesExtension.DistributionChannel AND Division = _SalesExtension.Division  -- association [0..1]
;