P_ARCustomer

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 P_ARCustomer.
-- 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: PARCUSTOMER

CREATE VIEW P_ARCustomer AS
SELECT
  Customer,
  CompanyCode,
  SalesOrganization,
  DistributionChannel,
  Division,
  CustomerIsWithCompanyCode,
  cast(CustomerAccountGroup as farp_customer_account_group preserving type) AS CustomerAccountGroup,
  _CustomerAccountGroupText[1:Language = $session.system_language].AccountGroupName AS AccountGroupName,
  Supplier,
  PostingIsBlocked,
  AuthorizationGroup,
  cast(CreatedByUser as farp_ernam_rf) AS CreatedByUser,
  VATRegistration,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  TaxNumber4,
  TaxNumber5,
  VATLiability,
  cast(ResponsibleType as supplist_j_1atoid) AS ResponsibleType,
  cast(TaxNumberType as farp_supplist_j_1atoid) AS TaxNumberType,
  _CustomerSalesArea2.SalesOffice AS SalesOffice,
  _CustomerSalesArea2.SalesGroup AS SalesGroup,
  _CustomerSalesArea2.CustomerPaymentTerms AS CustomerPaymentTerms,
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _CustomerToBusinessPartner._BusinessPartner.FirstName AS FirstName,
  _CustomerToBusinessPartner._BusinessPartner.LastName AS LastName,
  _CustomerToBusinessPartner._BusinessPartner.OrganizationBPName1 AS OrganizationBPName1,
  _CustomerToBusinessPartner._BusinessPartner.OrganizationBPName2 AS OrganizationBPName2,
  _CustomerToBusinessPartner._BusinessPartner.GroupBusinessPartnerName1 AS GroupBusinessPartnerName1,
  _CustomerToBusinessPartner._BusinessPartner.GroupBusinessPartnerName2 AS GroupBusinessPartnerName2,
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartnerType AS BusinessPartnerType,
  _CustomerToBusinessPartner._BusinessPartner.LegalForm AS LegalForm,
  _CustomerToBusinessPartner._BusinessPartner.LegalEntityOfOrganization AS LegalEntityOfOrganization,
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartnerIDByExtSystem AS BusinessPartnerIDByExtSystem,
  _CustomerToBusinessPartner._BusinessPartner.IsMarkedForArchiving AS IsMarkedForArchiving,
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartnerIsBlocked AS BusinessPartnerIsBlocked,
  _CustomerToBusinessPartner._BusinessPartner.ContactPermission AS ContactPermission,
  _Customer.AddressID AS AddressID,
  _StandardAddress.CityName AS CityName,
  _StandardAddress.PhoneNumber AS PhoneNumber,
  _StandardAddress._DefaultEmailAddress.EmailAddress AS EmailAddress,
  _StandardAddress.StreetName AS StreetName,
  _StandardAddress.PostalCode AS PostalCode,
  _StandardAddress.Country AS Country,
  _StandardAddress.Region AS Region,
  _StandardAddress.AddressTimeZone AS AddressTimeZone,
  _StandardAddress.POBox AS POBox,
  _StandardAddress.POBoxPostalCode AS POBoxPostalCode,
  _StandardAddress.CompanyPostalCode AS CompanyPostalCode,
  _StandardAddress.CorrespondenceLanguage AS CorrespondenceLanguage,
  _StandardAddress._DefaultMobilePhoneNumber.InternationalPhoneNumber AS MobilePhoneNumber,
  _StandardAddress.FaxNumber AS FaxNumber,
  _StandardAddress.PrfrdCommMediumType AS PrfrdCommMediumType,
  _StandardAddress.SearchTerm1 AS SearchTerm1,
  _StandardAddress.SearchTerm2 AS SearchTerm2,
  _StandardAddress.StreetPrefixName AS StreetPrefixName,
  _StandardAddress.AdditionalStreetPrefixName AS AdditionalStreetPrefixName,
  _StandardAddress.StreetSuffixName AS StreetSuffixName,
  _StandardAddress.AdditionalStreetSuffixName AS AdditionalStreetSuffixName,
  _StandardAddress.District AS District,
  _StandardAddress.HouseNumber AS HouseNumber,
  _StandardAddress.BusinessPartnerName2 AS BusinessPartnerName2,
  _StandardAddress.BusinessPartnerName3 AS BusinessPartnerName3,
  _StandardAddress.BusinessPartnerName4 AS BusinessPartnerName4,
  _CustomerCompany2.AccountingClerk AS AccountingClerk,
  _CustomerCompany2.PaymentTerms AS PaymentTerms,
  _CustomerCompany2._CustomerDefaultDunning.DunningProcedure AS DunningProcedure,
  _CustomerCompany2._CustomerDefaultDunning.DunningBlock AS DunningBlock,
  _CustomerCompany2._CustomerDefaultDunning.LastDunnedOn AS LastDunnedOn,
  _CustomerCompany2._CustomerDefaultDunning.LegDunningProcedureOn AS LegDunningProcedureOn,
  _CustomerCompany2._CustomerDefaultDunning.DunningLevel AS DunningLevel,
  _CustomerCompany2.PhysicalInventoryBlockInd AS PhysicalInventoryBlockInd,
  _CustomerCompany2.CreditMemoPaymentTerms AS CreditMemoPaymentTerms,
  _CustomerCompany2.PaymentMethodsList AS PaymentMethodsList,
  _CustomerCompany2.HouseBank AS HouseBank,
  _CustomerCompany2.PaymentBlockingReason AS PaymentBlockingReason,
  _CustomerCompany2.DunningNoticeGroup AS DunningNoticeGroup,
  _CustomerCompany2.AccountByCustomer AS AccountByCustomer,
  _CustomerCompany2.UserAtCustomer AS UserAtCustomer,
  _CustomerCompany2.AccountingClerkPhoneNumber AS AccountingClerkPhoneNumber,
  _CustomerCompany2.AccountingClerkInternetAddress AS AccountingClerkInternetAddress,
  _CustomerCompany2.ReconciliationAccount AS ReconciliationAccount,
  _CustomerCompany2.InterestCalculationCode AS InterestCalculationCode,
  _CustomerCompany2._CustomerDefaultDunning.DunningRecipient AS DunningRecipient,
  _CustomerCompany2._CustomerDefaultDunning.DunningClerk AS DunningClerk,
  _CustomerCompany2.IntrstCalcFrequencyInMonths AS IntrstCalcFrequencyInMonths,
  _CustomerCompany2.InterestCalculationDate AS InterestCalculationDate,
  _CustomerCompany2.LastInterestCalcRunDate AS LastInterestCalcRunDate,
  _CustomerCompany2.CustPreviousMasterRecordNumber AS CustPreviousMasterRecordNumber,
  _CustomerCompany2.CashPlanningGroup AS CashPlanningGroup,
  _BranchCode.BranchCode AS BranchCode,
  cast(_BranchCode.TH_BranchCodeDescription as farp_supplist_branch_descr preserving type) AS TH_BranchCodeDescription,
  DataControllerSet,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10
FROM P_ARCustomerUnion AS _Customer
LEFT OUTER JOIN I_Paymentcard AS _PaymentCard ON BusinessPartner = _PaymentCard.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartnerBank AS _BusinessPartnerBank ON BusinessPartner = _BusinessPartnerBank.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN P_BusinessPartnerFSAttr AS _ARBusinessPartnerFSAttr ON BusinessPartner = _ARBusinessPartnerFSAttr.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectUUIDStatus AS _StatusObject ON BusinessPartnerUUID = _StatusObject.StatusObjectUUID AND _StatusObject.StatusIsInactive != 'X'  -- association [0..1]
LEFT OUTER JOIN P_ADDRESSTEXT AS _AddressText ON AddressID = _AddressText.AddressID AND _AddressText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN P_ARCustSalesPartnerFunc AS _CustSalesPartnerFunc ON Customer = _CustSalesPartnerFunc.Customer AND SalesOrganization = _CustSalesPartnerFunc.SalesOrganization AND DistributionChannel = _CustSalesPartnerFunc.DistributionChannel AND Division = _CustSalesPartnerFunc.Division  -- association [0..*]
LEFT OUTER JOIN I_AccountingClerk AS _AccountingClerk ON accountingclerk = _AccountingClerk.AccountingClerk AND CompanyCode = _AccountingClerk.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_TH_CustomerBranchCodeVH AS _BranchCode ON Customer = _BranchCode.Customer AND _BranchCode.IsDefaultValue = 'X'  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _CustomerCompany2 ON Customer = _CustomerCompany2.Customer AND CompanyCode = _CustomerCompany2.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CustomerSalesArea AS _CustomerSalesArea2 ON Customer = _CustomerSalesArea2.Customer AND SalesOrganization = _CustomerSalesArea2.SalesOrganization AND DistributionChannel = _CustomerSalesArea2.DistributionChannel AND Division = _CustomerSalesArea2.Division  -- association [0..1]
LEFT OUTER JOIN I_CustomerToBusinessPartner AS _CustomerToBusinessPartner ON Customer = _CustomerToBusinessPartner.Customer  -- association [1..1]
LEFT OUTER JOIN I_Address AS _StandardAddress ON AddressID = _StandardAddress.AddressID  -- association [1..1]
;