C_Supplier

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_Supplier.
-- 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: CSUPPLIST

CREATE VIEW C_Supplier AS
SELECT
  _SuppCoCodePurOrg.Supplier AS Supplier,
  case when _SuppCoCodePurOrg.CompanyCode is null then ' ' else _SuppCoCodePurOrg.CompanyCode end as CompanyCode AS CompanyCodeendasCompanyCode,
  BusinessPartner.BusinessPartner AS BusinessPartner,
  case when BusinessPartner._SupplierBankDetails.BankCountry is null then ' ' else BusinessPartner._SupplierBankDetails.BankCountry end as BankCountry AS BankCountryendasBankCountry,
  case when BusinessPartner._SupplierBankDetails.Bank is null then ' ' else BusinessPartner._SupplierBankDetails.Bank end AS Bank,
  case when BusinessPartner._SupplierBankDetails.BankAccount is null then ' ' else BusinessPartner._SupplierBankDetails.BankAccount end as BankAccount AS BankAccountendasBankAccount,
  Country,
  case when _BPTaxNumber.BPTaxType is null then ' ' else _BPTaxNumber.BPTaxType end AS BPTaxType,
  BusinessPartner._SupplierBankDetails._BusinessPartnerBank.BankIdentification AS BankIdentification,
  SupplierName,
  SupplierFullName,
  OrganizationBPName1,
  OrganizationBPName2,
  _CountryText.CountryName AS SupplierCountryName,
  _SuppCoCodePurOrg.Region AS Region,
  _RegionText[1:Language = $session.system_language].RegionName AS RegionName,
  PostalCode,
  cast (CityName as farp_supplist_ort01_gp) AS CityName,
  StreetName,
  _StandardAddress.StreetPrefixName AS StreetPrefixName,
  _StandardAddress.AdditionalStreetPrefixName AS AdditionalStreetPrefixName,
  _StandardAddress.StreetSuffixName AS StreetSuffixName,
  _StandardAddress.AdditionalStreetSuffixName AS AdditionalStreetSuffixName,
  PhoneNumber1,
  FaxNumber,
  CreationDate,
  CreatedByUser,
  PhoneNumber2,
  IsNaturalPerson,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  TaxNumber4,
  TaxNumber5,
  VATRegistration,
  _BPTaxNumber.BPTaxNumber AS BPTaxNumber,
  _BPTaxNumber.TaxTypeName AS TaxTypeName,
  cast (ResponsibleType as supplist_j_1atoid preserving type) AS ResponsibleType,
  cast (TaxNumberType as farp_supplist_j_1atoid preserving type) AS TaxNumberType,
  cast(TaxNumberResponsible as supplist_taxnumber) AS TaxNumberResponsible,
  AddressID,
  cast (DeletionIndicator as farp_supplist_loevm_x preserving type) AS DeletionIndicator,
  TradingPartner,
  cast(SupplierAccountGroup as farp_supplier_account_group preserving type) AS SupplierAccountGroup,
  _SupplierAccountGroup._SupplierAccountGroupText[1:Language = $session.system_language].AccountGroupName AS AccountGroupName,
  _SuppCoCodePurOrg.AuthorizationGroup AS AuthorizationGroup,
  cast (AccountIsBlockedForPosting as farp_supplist_sperr preserving type) AS AccountIsBlockedForPosting,
  cast (_SuppCoCodePurOrg.SupplierIsBlockedForPosting as farp_supplist_sperb_b preserving type) AS SupplierIsBlockedForPosting,
  _SuppCoCodePurOrg.PurchasingIsBlocked AS PurchasingIsBlocked,
  cast (_SuppCoCodePurOrg.PurchasingIsBlockedForSupplier as supplist_sperm_m preserving type) AS PurchasingIsBlockedForSupplier,
  cast (PaymentIsBlockedForSupplier as supplist_sperz preserving type) AS PaymentIsBlockedForSupplier,
  AlternativePayeeAccountNumber,
  _SuppCoCodePurOrg.CompanyCode AS SearchString,
  _SuppCoCodePurOrg.LayoutSortingRule AS LayoutSortingRule,
  cast (_SuppCoCodePurOrg.ReconciliationAccount as farp_akont preserving type) AS ReconciliationAccount,
  _SuppCoCodePurOrg.PaymentMethodsList AS PaymentMethodsList,
  cast(_SuppCoCodePurOrg.AccountingClerk as farp_busab preserving type) AS AccountingClerk,
  cast(_SuppCoCodePurOrg.AccountingClerkFaxNumber as farp_supplist_tlfxs preserving type) AS AccountingClerkFaxNumber,
  cast(_SuppCoCodePurOrg.SupplierClerkURL as farp_supplist_intad preserving type) AS SupplierClerkURL,
  _SuppCoCodePurOrg.AccountingClerkPhoneNumber AS AccountingClerkPhoneNumber,
  cast (_SuppCoCodePurOrg.SuplrCoCodePaymentTerms as farp_dzterm_cc preserving type) AS SuplrCoCodePaymentTerms,
  cast (_SuppCoCodePurOrg.PaymentBlockingReason as farp_dzlspr preserving type ) AS PaymentBlockingReason,
  cast (_SuppCoCodePurOrg.SuplrIsDeltdCoCode as farp_supplist_loevm_b preserving type) AS SuplrIsDeltdCoCode,
  _SuppCoCodePurOrg.CashPlanningGroup AS CashPlanningGroup,
  _SuppCoCodePurOrg.IsToBeCheckedForDuplicates AS IsToBeCheckedForDuplicates,
  _SuppCoCodePurOrg.CompanyCodeName AS CompanyCodeName,
  _SuppCoCodePurOrg.AlternativePayee AS AlternativePayee,
  _SuppCoCodePurOrg.SupplierAccountNote AS SupplierAccountNote,
  _SuppCoCodePurOrg.PurOrdAutoGenerationIsAllowed AS PurOrdAutoGenerationIsAllowed,
  _SuppCoCodePurOrg.PurchasingGroup AS PurchasingGroup,
  cast (_SuppCoCodePurOrg.SupplierPurgOrgPaymentTerms as farp_dzterm_po preserving type) AS SupplierPurgOrgPaymentTerms,
  cast (_SuppCoCodePurOrg.SuplrIsDeltdPurgOrg as supplist_loevm_m preserving type) AS SuplrIsDeltdPurgOrg,
  _SuppCoCodePurOrg.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  _SuppCoCodePurOrg.PurchaseOrderCurrency AS PurchaseOrderCurrency,
  _SuppCoCodePurOrg.SupplierReleaseGroup AS SupplierReleaseGroup,
  _SuppCoCodePurOrg.IncotermsClassification AS IncotermsClassification,
  _SuppCoCodePurOrg.IncotermsTransferLocation AS IncotermsTransferLocation,
  _SuppCoCodePurOrg._IncotermsClassification._Text[1:Language = $session.system_language].IncotermsClassificationName AS IncotermsClassificationName,
  MinorityGroup,
  cast (_StandardAddress._DefaultEmailAddress.EmailAddress as supplist_smtpadr preserving type) AS EmailAddress,
  _StandardAddress._DefaultEmailAddress.SearchEmailAddress AS SearchEmailAddress,
  BusinessPartner._SupplierBankDetails._Bank.BankName AS BankName,
  cast (BusinessPartner._SupplierBankDetails._Bank.BankInternalID as farp_supplist_bankk preserving type) AS BankInternalID,
  BusinessPartner._SupplierBankDetails._Bank.SWIFTCode AS SWIFTCode,
  BusinessPartner._SupplierBankDetails._IBAN.IBAN AS IBAN,
  cast(BusinessPartner._SupplierBankDetails.BankControlKey as farp_supplist_bkont preserving type) AS BankControlKey,
  cast (BusinessPartner._SupplierBankDetails.BankAccountHolderName as fclm_bam_beneficiary_name preserving type) AS BankAccountHolderName,
  concat_with_space(BusinessPartner._SupplierBankDetails.BankCountry, concat(concat('(',BusinessPartner._SupplierBankDetails._Country._Text[1:Language = $session.system_language].CountryName),')'), 1) as CountryName AS CountryName1asCountryName,
  BusinessPartner._SupplierBankDetails._BusinessPartnerBank.BPBankIsProtected AS BPBankIsProtected,
  VATLiability,
  DataControllerSet,
  _SuppCoCodePurOrg.WithholdingTaxCountry AS WithholdingTaxCountry,
  _UserContactCard.FullName AS FullName,
  _BusinessPartner.SearchTerm1 AS SearchTerm1,
  _BusinessPartner.SearchTerm2 AS SearchTerm2,
  _BusinessPartner.BusinessPartnerType AS BusinessPartnerType,
  _BranchCode.BranchCode AS BranchCode,
  cast(_BranchCode.TH_BranchCodeDescription as farp_supplist_branch_descr preserving type) AS TH_BranchCodeDescription,
  _BranchCode.IsDefaultValue AS IsDefaultValue,
  BusinessPartner._SupplierBankDetails._BusinessPartnerBank.BankAccountReferenceText AS BankAccountReferenceText,
  _SuppCoCodePurOrg.PreviousAccountNumber AS PreviousAccountNumber
FROM P_SuplrCoCodePurOrgAssgmt AS _SuppCoCodePurOrg
INNER JOIN P_SupplierBusinessPartner AS BusinessPartner ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CountryText AS _CountryText ON _CountryText.Country = Country AND _CountryText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN C_SupplierUserValueHelp AS _UserContactCard ON _UserContactCard.CreatedByUser = CreatedByUser  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_SupplierBusinessPartnerTax AS _BPTaxNumber ON BusinessPartner = _BPTaxNumber.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN I_TH_SupplierBranchCodeVH AS _BranchCode ON Supplier = _BranchCode.Supplier AND _BranchCode.IsDefaultValue = 'X'  -- association [0..*]
LEFT OUTER JOIN C_RegionTextVHTemp AS _RegionText ON Country = _RegionText.Country AND Region = _RegionText.Region  -- association [1..*]
;