C_Customer360

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_Customer360.
-- 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 C_Customer360 AS
SELECT
  Customer,
  _CustomerToBusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartnerType AS BusinessPartnerType,
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartnerCategory AS BusinessPartnerCategory,
  cast ( case when _CustomerToBusinessPartner._BusinessPartner.BusinessPartnerCategory = '1' then 'sap-icon: else 'sap-icon: end as abap.sstring( 500 ) ) as BusinessPartnerImageURL AS sstring500asBusinessPartnerImageURL,
  cast( 'EUR' as vdm_v_display_currency ) AS DisplayCurrency,
  cast('0' as abap.curr( 15, 2 )) AS SlsVolumeNetAmtInDspCrcy,
  cast('' as boole_d ) AS Cust360CrteSlsQtanIsAuthzd,
  cast('' as boole_d ) AS Cust360CrteSalesOrderIsAuthzd,
  cast('' as boole_d ) AS Cust360SlsSchedAgrmtIsAuthzd,
  cast('' as boole_d ) AS Cust360CrteSlsContractIsAuthzd,
  cast('' as boole_d ) AS Cust360CrteCustReturnIsAuthzd,
  cast('' as boole_d ) AS Cust360OrdWthoutChrgIsAuthzd,
  cast('' as boole_d ) AS Cust360CrteCrdtMemoReqIsAuthzd,
  cast('' as boole_d ) AS Cust360CrteDbtMemoReqIsAuthzd,
  cast('' as boole_d ) AS Cust360CrteSrvcQtanIsAuthzd,
  cast('' as boole_d ) AS Cust360CrteSrvcOrdIsAuthzd,
  CustomerName,
  StreetName,
  _StreetValueHelpTmp._Text[1:Language = $session.system_language ].StreetName AS CustomerStreetName,
  PostalCode,
  CityName,
  Country,
  _CountryVH.Description AS CountryName,
  AddressID,
  cast( ' ' as ad_line_s) AS AddressLine1,
  cast( ' ' as ad_line_s) AS AddressLine2,
  cast( ' ' as ad_line_s) AS AddressLine3,
  cast( ' ' as vkorg) AS SalesOrganization,
  cast( ' ' as vkorg) AS SalesOrganizationName,
  cast( ' ' as vtweg) AS DistributionChannel,
  cast( ' ' as vtweg) AS DistributionChannelName,
  cast( ' ' as spart) AS Division,
  cast( ' ' as spart) AS DivisionName,
  cast( ' ' as vkgrp) AS SalesGroup,
  cast( ' ' as vkgrp) AS SalesGroupName,
  cast( ' ' as vkbur) AS SalesOffice,
  cast( ' ' as vkbur) AS SalesOfficeName,
  AuthorizationGroup,
  CustomerAccountGroup,
  IsBusinessPurposeCompleted,
  OrganizationBPName1,
  OrganizationBPName2,
  Customer.DataControllerSet AS DataControllerSet,
  Customer.DataController1 AS DataController1,
  Customer.DataController2 AS DataController2,
  Customer.DataController3 AS DataController3,
  Customer.DataController4 AS DataController4,
  Customer.DataController5 AS DataController5,
  Customer.DataController6 AS DataController6,
  Customer.DataController7 AS DataController7,
  Customer.DataController8 AS DataController8,
  Customer.DataController9 AS DataController9,
  Customer.DataController10 AS DataController10
FROM I_Customer AS Customer
LEFT OUTER JOIN C_Customer360RecentBusDoc AS _Customer360RecentBusDoc ON Customer = _Customer360RecentBusDoc.SoldToParty  -- association [1..*]
LEFT OUTER JOIN C_Customer360FulfillmentIssue AS _Customer360FulfillmentIssue ON Customer = _Customer360FulfillmentIssue.SoldToParty  -- association [1..*]
LEFT OUTER JOIN C_Cust360FulfillmentIssueCnt AS _Cust360FulfillmentIssueCnt ON Customer = _Cust360FulfillmentIssueCnt.SoldToParty  -- association [1..*]
LEFT OUTER JOIN C_Customer360ApprovalBusDoc AS _Cust360ApprovalBusDoc ON Customer = _Cust360ApprovalBusDoc.SoldToParty  -- association [1..*]
LEFT OUTER JOIN C_Customer360ServiceQuotation AS _Cust360ServiceQuotation ON Customer = _Cust360ServiceQuotation.SoldToParty  -- association [1..*]
LEFT OUTER JOIN C_Customer360SalesOrder AS _Cust360SalesOrder ON Customer = _Cust360SalesOrder.SoldToParty  -- association [1..*]
LEFT OUTER JOIN C_Customer360ServiceContract AS _Cust360ServiceContract ON Customer = _Cust360ServiceContract.SoldToParty  -- association [1..*]
LEFT OUTER JOIN C_Customer360ServiceOrder AS _Cust360ServiceOrder ON Customer = _Cust360ServiceOrder.SoldToParty  -- association [1..*]
LEFT OUTER JOIN C_Customer360InternalContact AS _Customer360InternalContact ON Customer = _Customer360InternalContact.Customer  -- association [1..*]
LEFT OUTER JOIN C_Customer360ExternalContact AS _Customer360ExternalContact ON Customer = _Customer360ExternalContact.Customer  -- association [1..*]
LEFT OUTER JOIN C_Cust360RecentDeliveryDoc AS _Cust360RecentDelivery ON Customer = _Cust360RecentDelivery.SoldToParty  -- association [1..*]
LEFT OUTER JOIN C_Customer360SalesContract AS _Cust360SalesContract ON Customer = _Cust360SalesContract.SoldToParty  -- association [1..*]
LEFT OUTER JOIN C_Cust360SalesSchedgAgrmt AS _Cust360SalesSchedgAgrmt ON Customer = _Cust360SalesSchedgAgrmt.SoldToParty  -- association [1..*]
LEFT OUTER JOIN C_Customer360SalesQuotation AS _Customer360SalesQuotation ON Customer = _Customer360SalesQuotation.SoldToParty  -- association [1..*]
LEFT OUTER JOIN C_Customer360CreditMemoRequest AS _Customer360CreditMemoRequest ON Customer = _Customer360CreditMemoRequest.SoldToParty  -- association [1..*]
LEFT OUTER JOIN C_Cust360SlsOrdWithoutCharge AS _Cust360SlsOrdWithoutCharge ON Customer = _Cust360SlsOrdWithoutCharge.SoldToParty  -- association [1..*]
LEFT OUTER JOIN C_Customer360DebitMemoRequest AS _Customer360DebitMemoRequest ON Customer = _Customer360DebitMemoRequest.SoldToParty  -- association [1..*]
LEFT OUTER JOIN C_Customer360CustomerReturn AS _Cust360CustomerReturn ON Customer = _Cust360CustomerReturn.SoldToParty  -- association [1..*]
LEFT OUTER JOIN C_Customer360DeliveryDocument AS _Customer360DeliveryDocument ON Customer = _Customer360DeliveryDocument.ShipToParty  -- association [1..*]
LEFT OUTER JOIN C_Customer360Invoice AS _Customer360Invoice ON Customer = _Customer360Invoice.SoldToParty  -- association [1..*]
LEFT OUTER JOIN C_Customer360CancelledInvoice AS _Customer360CancelledInvoice ON Customer = _Customer360CancelledInvoice.SoldToParty  -- association [1..*]
LEFT OUTER JOIN C_Customer360InvoiceList AS _Customer360InvoiceList ON Customer = _Customer360InvoiceList.SoldToParty  -- association [1..*]
LEFT OUTER JOIN C_Cust360BillingDocReq AS _Cust360BillingDocReq ON Customer = _Cust360BillingDocReq.SoldToParty  -- association [1..*]
LEFT OUTER JOIN C_Cust360PreliminaryBillDoc AS _Cust360PreliminaryBillDoc ON Customer = _Cust360PreliminaryBillDoc.SoldToParty  -- association [1..*]
LEFT OUTER JOIN I_Customer360BusDocSetting AS _Customer360BusDocSetting ON _Customer360BusDocSetting.BusinessDocumentIsEnabled = 'X'  -- association [0..*]
LEFT OUTER JOIN C_Customer360SalesArea AS _Customer360SalesArea ON Customer = _Customer360SalesArea.Customer  -- association [1..*]
LEFT OUTER JOIN C_Cust360SoldProductWithPrice AS _Cust360SoldProductEnt ON Customer = _Cust360SoldProductEnt.SoldToParty  -- association [1..*]
LEFT OUTER JOIN I_Customer360GeneralSetting AS _Customer360GeneralSetting ON _Customer360GeneralSetting.CustomerViewProfileName = 'CUSTPROFL'  -- association [1..1]
LEFT OUTER JOIN I_CountryVH AS _CountryVH ON Country = _CountryVH.Country  -- association [1..1]
LEFT OUTER JOIN I_BPStreetValueHelpTmp AS _StreetValueHelpTmp ON Country = _StreetValueHelpTmp.Country AND StreetName = _StreetValueHelpTmp.StreetName AND CityName = _StreetValueHelpTmp.BusinessPartnerCityCode  -- association [0..1]
LEFT OUTER JOIN C_Q2CCustomerQuickView AS _SoldToParty ON Customer = _SoldToParty.Customer  -- association [0..1]
;