C_CustomerList_2

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_CustomerList_2.
-- 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_CustomerList_2 AS
SELECT
  cast(Customer as abap.char( 20 )) AS CustomerSequentialNumber,
  cast( Customer as kunnr ) AS Customer,
  cast( '' as bukrs) AS CompanyCode,
  cast( '' as vkorg) AS SalesOrganization,
  cast( '' as vtweg ) AS DistributionChannel,
  cast( '' as spart) AS Division,
  cast( '' as parza) AS PartnerCounter,
  cast( '' as bu_iban) AS IBAN,
  cast( '' as bu_banks) AS BankCountryKey,
  cast( '' as landx50) AS CountryName,
  cast( '' as bu_bankk) AS BankNumber,
  cast( '' as fap_bankn) AS BankAccount,
  cast( '' as bu_bkont) AS BankControlKey,
  cast( '' as bu_ccnum) AS CardNumber,
  cast( '' as cc_institute) AS PaymentCardType,
  cast( '' as parvw_unv) AS PartnerFunction,
  cast( '' as boolean ) AS CustomerIsWithCompanyCode,
  cast( '' as farp_inhouse_contact) AS PartnerFunctionName,
  cast( '' as pernr_d) AS PersonnelNumber,
  cast( '' as busab) AS AccountingClerk,
  cast( '' as farp_sname_001s) AS AccountingClerkName,
  cast( '' as farp_dzterm_fi) AS PaymentTerms,
  cast( '' as md_customer_name) AS BusinessPartnerName,
  cast( _StandardAddress.CityName as ad_city1 ) AS CityName,
  cast ( '' as farp_phone) AS PhoneNumber,
  cast( '' as contactcardemailaddress) AS EmailAddress,
  cast( '' as mahna) AS DunningProcedure,
  cast( '' as mansp) AS DunningBlock,
  cast( '' as farp_customer_account_group) AS CustomerAccountGroup,
  cast( '' as txt30_077t) AS AccountGroupName,
  cast( _CustomerToBusinessPartner._BusinessPartner.FirstName as bu_namep_f) AS FirstName,
  cast( _CustomerToBusinessPartner._BusinessPartner.LastName as bu_namep_l) AS LastName,
  cast( _CustomerToBusinessPartner._BusinessPartner.OrganizationBPName1 as bu_nameor1) AS OrganizationBPName1,
  cast( _CustomerToBusinessPartner._BusinessPartner.OrganizationBPName2 as bu_nameor2) AS OrganizationBPName2,
  cast( _CustomerToBusinessPartner._BusinessPartner.GroupBusinessPartnerName1 as bu_namegr1) AS GroupBusinessPartnerName1,
  cast( _CustomerToBusinessPartner._BusinessPartner.GroupBusinessPartnerName2 as bu_namegr2) AS GroupBusinessPartnerName2,
  cast( '' as bu_bpkind) AS BusinessPartnerType,
  cast( '' as farp_enty) AS LegalForm,
  cast( '' as farp_legal_org) AS LegalEntityOfOrganization,
  cast( '' as bu_bpext) AS BusinessPartnerIDByExtSystem,
  cast( '' as bu_xdele) AS IsMarkedForArchiving,
  cast( '' as bu_xblck) AS BusinessPartnerIsBlocked,
  cast( '' as bu_contact) AS ContactPermission,
  cast( '' as ad_street) AS StreetName,
  cast( '' as ad_pstcd1) AS PostalCode,
  cast( '' as land1) AS Country,
  cast( '' as regio) AS Region,
  cast( '' as farp_tzone) AS AddressTimeZone,
  cast( '' as ad_pobx) AS POBox,
  cast( '' as ad_pstcd2) AS POBoxPostalCode,
  cast( '' as ad_pstcd3) AS CompanyPostalCode,
  cast( '' as spras) AS CorrespondenceLanguage,
  cast ( '' as farp_mobile) AS MobilePhoneNumber,
  cast( '' as telfx) AS FaxNumber,
  cast( '' as ad_comm) AS PrfrdCommMediumType,
  cast( '' as ad_sort1) AS SearchTerm1,
  cast( '' as ad_sort2) AS SearchTerm2,
  cast( '' as ad_strspp1) AS StreetPrefixName,
  cast( '' as ad_strspp2) AS AdditionalStreetPrefixName,
  cast( '' as ad_strspp3) AS StreetSuffixName,
  cast( '' as ad_lctn) AS AdditionalStreetSuffixName,
  cast( '' as ad_city2) AS BusinessPartnerDistrict,
  cast( '' as ad_hsnm1) AS HouseNumber,
  cast( '' as ad_name2) AS BusinessPartnerName2,
  cast( '' as ad_name3) AS BusinessPartnerName3,
  cast( '' as ad_name4) AS BusinessPartnerName4,
  cast( '' as lifnr) AS Supplier,
  cast( '' as sperb_x) AS PostingIsBlocked,
  cast( '' as brgru) AS AuthorizationGroup,
  cast( '' as farp_ernam_rf) AS CreatedByUser,
  cast( '' as stceg) AS VATRegistration,
  cast( '' as stcd1) AS TaxNumber1,
  cast( '' as stcd2) AS TaxNumber2,
  cast( '' as stcd3) AS TaxNumber3,
  cast( '' as stcd4) AS TaxNumber4,
  cast( '' as stcd5) AS TaxNumber5,
  cast( '' as stkzu) AS VATLiability,
  cast( '' as supplist_j_1atoid) AS ResponsibleType,
  cast( '' as farp_supplist_j_1atoid) AS TaxNumberType,
  cast( '' as vkbur) AS SalesOffice,
  cast( '' as vkgrp) AS SalesGroup,
  cast( '' as farp_dzterm_sd) AS CustomerPaymentTerms,
  cast( '' as madat) AS LastDunnedOn,
  cast( '' as gmvdt) AS LegDunningProcedureOn,
  cast( '' as mahns_d) AS DunningLevel,
  cast( '' as sperb_b) AS PhysicalInventoryBlockInd,
  cast( '' as guzte) AS CreditMemoPaymentTerms,
  cast( '' as dzwels) AS PaymentMethodsList,
  cast( '' as hbkid) AS HouseBank,
  cast( '' as dzahls) AS PaymentBlockingReason,
  cast( '' as mgrup) AS DunningNoticeGroup,
  cast( '' as farp_eikto_c) AS AccountByCustomer,
  cast( '' as farp_dzsabe) AS UserAtCustomer,
  cast( '' as tlfns) AS AccountingClerkPhoneNumber,
  cast( '' as intad) AS AccountingClerkInternetAddress,
  cast( '' as farp_akont) AS ReconciliationAccount,
  cast( '' as farp_vzskz_c) AS InterestCalculationCode,
  cast( '' as knrma) AS DunningRecipient,
  cast( '' as busab_ma) AS DunningClerk,
  cast( '' as dzinrt) AS IntrstCalcFrequencyInMonths,
  cast( '' as dzindt) AS InterestCalculationDate,
  cast( '' as datlz) AS LastInterestCalcRunDate,
  cast( '' as altkn) AS BPCustomerNumber,
  cast( '' as fdgrp) AS CashPlanningGroup,
  cast( '' as bp_vip_partner) AS BusinessPartnerIsVIP,
  cast( '' as bp_unw_customer) AS CustomerIsUnwanted,
  cast( '' as bp_unw_reason) AS UndesirabilityReason,
  cast( '' as bp_unw_remark) AS UndesirabilityComment,
  cast( '' as rassc) AS TradingPartner,
  cast('' as farp_contact_date) AS LastCustomerContactDate,
  cast( '' as crm_j_status) AS Status,
  cast( '' as vdm_statusshortname) AS SystemStatusShortName,
  cast( '' as ad_remark1) AS AddressText,
  cast( '' as bcode) AS BranchCode,
  cast( '' as farp_supplist_branch_descr) AS TH_BranchCodeDescription,
  cast( '' as ad_namtext) AS FullName,
  cast( '' as farp_bvtyp) AS BankIdentification,
  IsBusinessPurposeCompleted,
  DataControllerSet,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10
FROM I_Customer
;