C_SupplierList

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_SupplierList.
-- 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_SupplierList AS
SELECT
  cast(Supplier as pph_flgzl) AS SequenceInternalID,
  Supplier,
  cast( '' as bukrs) AS CompanyCode,
  cast( '' as bu_partner) AS BusinessPartner,
  cast( '' as ekorg) AS PurchasingOrganization,
  cast( '' as banks) AS BankCountry,
  cast( '' as bankl) AS Bank,
  cast( '' as bu_bankn) AS BankAccount,
  cast( '' as land1) AS Country,
  cast( '' as bptaxtype) AS BPTaxType,
  cast( '' as bu_bkvid) AS BankIdentification,
  cast( '' as butxt) AS CompanyCodeName,
  cast( '' as md_supplier_name) AS SupplierName,
  cast( '' as fap_supplier_full_name) AS SupplierFullName,
  cast( '' as name1_gp) AS OrganizationBPName1,
  cast( '' as bu_nameor2) AS OrganizationBPName2,
  cast( '' as landx50) AS SupplierCountryName,
  cast( '' as regio) AS Region,
  cast( '' as bezei20) AS RegionName,
  cast( '' as pstlz) AS PostalCode,
  cast( '' as farp_supplist_ort01_gp) AS CityName,
  cast( '' as stras_gp) AS StreetName,
  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 telf1) AS PhoneNumber1,
  cast( '' as telfx) AS FaxNumber,
  cast( '' as erdat_rf) AS CreationDate,
  cast( '' as fap_supplier_list_created_by) AS CreatedByUser,
  cast( '' as telf2) AS PhoneNumber2,
  cast( '' as stkzn) AS IsNaturalPerson,
  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 fap_supplier_bptaxnum) AS BPTaxNumber,
  cast( '' as stceg) AS VATRegistration,
  cast( '' as splr_tax_type_name) AS TaxTypeName,
  cast( '' as supplist_j_1atoid) AS ResponsibleType,
  cast( '' as farp_supplist_j_1atoid) AS TaxNumberType,
  cast( '' as supplist_taxnumber) AS TaxNumberResponsible,
  cast( '' as adrnr) AS AddressID,
  cast( '' as rassc) AS TradingPartner,
  cast( '' as farp_supplier_account_group) AS SupplierAccountGroup,
  cast( '' as suplr_account_grp_name) AS AccountGroupName,
  cast( '' as brgru) AS AuthorizationGroup,
  cast( '' as supplist_sperz) AS PaymentIsBlockedForSupplier,
  cast( '' as fap_supplier_list_lnrza) AS AlternativePayeeAccountNumber,
  cast( '' as fap_supplier_list_lnrzb) AS AlternativePayee,
  cast( '' as bukrs) AS SearchString,
  cast( '' as dzuawa) AS LayoutSortingRule,
  cast( '' as farp_akont) AS ReconciliationAccount,
  cast( '' as dzwels) AS PaymentMethodsList,
  cast( '' as farp_busab) AS AccountingClerk,
  cast( '' as farp_supplist_tlfxs) AS AccountingClerkFaxNumber,
  cast( '' as farp_supplist_intad) AS SupplierClerkURL,
  cast( '' as supplier_list_tlfns) AS AccountingClerkPhoneNumber,
  cast( '' as fap_supplier_list_zterm_cocode) AS SuplrCoCodePaymentTerms,
  cast( '' as farp_dzlspr) AS PaymentBlockingReason,
  cast( '' as fap_supplier_list_fdgrv) AS CashPlanningGroup,
  cast( '' as fap_supplier_list_reprf) AS IsToBeCheckedForDuplicates,
  cast( '' as kzaut) AS PurOrdAutoGenerationIsAllowed,
  cast( ' ' as farp_supplist_loevm_b preserving type ) AS SuplrIsDeltdCoCode,
  cast( ' ' as supplist_loevm_m preserving type ) AS SuplrIsDeltdPurgOrg,
  cast( ' ' as farp_supplist_loevm_x preserving type ) AS DeletionIndicator,
  cast( ' ' as fap_supplier_deletion_status preserving type ) AS SupplierDeletionFlag,
  cast( '' as fap_supplier_deletion_flag_tex ) AS SupplierDeletionFlagText,
  cast( '' as ekgrp) AS PurchasingGroup,
  cast( '' as fap_supplier_list_zterm_po) AS SupplierPurgOrgPaymentTerms,
  cast( ' ' as farp_supplist_sperr preserving type ) AS AccountIsBlockedForPosting,
  cast( ' ' as farp_supplist_sperb_b preserving type ) AS SupplierIsBlockedForPosting,
  cast( ' ' as fap_supplier_posting_block_id preserving type ) AS SupplierPostingBlock,
  cast( '' as fap_posting_block_text ) AS SupplierPostingBlockText,
  cast( ' ' as sperm_x preserving type ) AS PurchasingIsBlocked,
  cast( ' ' as supplist_sperm_m preserving type ) AS PurchasingIsBlockedForSupplier,
  cast( ' ' as fap_supplier_purch_block_id preserving type ) AS SupplierPurchasingBlock,
  cast( '' as fap_purchasing_block_text ) AS SupplierPurchasingBlockText,
  cast( 1 as eve_tv_criticality ) AS CriticalityCode,
  cast( '' as webre) AS InvoiceIsGoodsReceiptBased,
  cast( '' as fap_supplier_list_bstwa) AS PurchaseOrderCurrency,
  cast( '' as supplist_smtpadr) AS EmailAddress,
  cast( '' as ad_smtpad2) AS SearchEmailAddress,
  cast( '' as banka) AS BankName,
  cast( '' as farp_supplist_bankk) AS BankInternalID,
  cast( '' as swift) AS SWIFTCode,
  cast( '' as bu_iban) AS IBAN,
  cast( '' as farp_supplist_bkont) AS BankControlKey,
  cast( '' as fclm_bam_beneficiary_name) AS BankAccountHolderName,
  cast( '' as landx50) AS CountryName,
  cast( '' as glo_partner_pobox_dvtg_city) AS BusPartPOBoxDvtgCityName,
  cast( '' as bu_protected ) AS BPBankIsProtected,
  cast( '' as stkzu) AS VATLiability,
  cast( '' as qland) AS WithholdingTaxCountry,
  cast( '' as fap_supplier_created_by_name) AS FullName,
  cast( '' as bu_sort1) AS SearchTerm1,
  cast( '' as bu_sort2) AS SearchTerm2,
  cast( '' as bu_bpkind) AS BusinessPartnerType,
  cast( '' as kverm) AS SupplierAccountNote,
  cast( '' as bcode) AS BranchCode,
  cast( '' as farp_supplist_branch_descr) AS TH_BranchCodeDescription,
  cast( '' as fith_default_bcode) AS IsDefaultValue,
  cast( '' as altkn) AS PreviousAccountNumber,
  cast( '' as frgrp) AS SupplierReleaseGroup,
  cast( '' as mindk) AS MinorityGroup,
  cast( '' as fap_supplier_list_bu_bkref ) AS BankAccountReferenceText,
  cast( '' as inco1 ) AS IncotermsClassification,
  cast( '' as inco2 ) AS IncotermsTransferLocation,
  cast( '' as incoterms_classification_name ) AS IncotermsClassificationName
FROM I_Supplier
;