C_CshConcnBkAcctTP

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_CshConcnBkAcctTP.
-- 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_CshConcnBkAcctTP AS
SELECT
  base.CashConcentrationID AS CashConcentrationID,
  base.PayingBankAccountInternalID AS PayingBankAccountInternalID,
  base.PayeeBankAccountInternalID AS PayeeBankAccountInternalID,
  base.PayingBankAccount AS PayingBankAccount,
  base.PayeeBankAccount AS PayeeBankAccount,
  base.AccountType AS AccountType,
  base.Bank AS Bank,
  base.BankCountry AS BankCountry,
  base.IBAN AS IBAN,
  base.PayingBankAccountDescription AS PayingBankAccountDescription,
  base.HouseBank AS HouseBank,
  base.HouseBankAccount AS HouseBankAccount,
  base.CashPoolName AS CashPoolName,
  base.PayeeBankAccountDescription AS PayeeBankAccountDescription,
  base.PayeeHouseBank AS PayeeHouseBank,
  base.PayeeHouseBankAccount AS PayeeHouseBankAccount,
  base.PayeeBank AS PayeeBank,
  base.PayeeBankCountry AS PayeeBankCountry,
  base.PayeeIBAN AS PayeeIBAN,
  base.CompanyCode AS CompanyCode,
  _PayingCompanyCode.CompanyCodeName AS CompanyCodeName,
  base.PayeeCompanyCode AS PayeeCompanyCode,
  base.ClsgBalAmtInBkAcctCrcy AS ClsgBalAmtInBkAcctCrcy,
  base.TgtBalAmtInBkAcctCrcy AS TgtBalAmtInBkAcctCrcy,
  base.TransfAmtInBkAcctCrcy AS TransfAmtInBkAcctCrcy,
  base.ValueDate AS ValueDate,
  base.AftBalInBkAcctCrcy AS AftBalInBkAcctCrcy,
  base.BankAccountCurrency AS BankAccountCurrency,
  base.PaymentRequest AS PaymentRequest,
  base.CashConcentrationStatus AS CashConcentrationStatus,
  base.PaymentMethod AS PaymentMethod,
  base.MinTransferAmount AS MinTransferAmount,
  base.LeadingCashPoolID AS LeadingCashPoolID,
  base.Note AS Note,
  base.IsSinglePayment AS IsSinglePayment,
  BankTransferReleaseAndPay,
  SystemStatusName,
  base.SubscriptionOrder AS SubscriptionOrder,
  base.CashPoolTransfDrctn AS CashPoolTransfDrctn,
  base.MaxTransferAmount AS MaxTransferAmount,
  base.DataExchangeInstructionKey AS DataExchangeInstructionKey,
  base.DataExchangeInstruction1 AS DataExchangeInstruction1,
  base.DataExchangeInstruction2 AS DataExchangeInstruction2,
  base.DataExchangeInstruction3 AS DataExchangeInstruction3,
  base.DataExchangeInstruction4 AS DataExchangeInstruction4,
  base.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  base.SupplyingCountry AS SupplyingCountry,
  base.PaymentMethodSupplement AS PaymentMethodSupplement,
  base.PaymentReference AS PaymentReference,
  BankAccountRevision,
  base.PlanningLevel AS PlanningLevel,
  base.ExpirationDate AS ExpirationDate,
  base.CashMemoRecordID AS CashMemoRecordID
FROM I_CshConcnBkAcctTP AS base
LEFT OUTER JOIN I_CshConcnStatusText AS _StatusText ON CashConcentrationStatus = _StatusText.CashConcentrationStatus  -- association [0..1]
LEFT OUTER JOIN C_CshConcnTP AS _CashConcentration ON CashConcentrationID = _CashConcentration.CashConcentrationID  -- association [1..1]
LEFT OUTER JOIN I_CompanyCodeVH AS _PayingCompanyCode ON CompanyCode = _PayingCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CashPoolTransfDrctnText AS _DrctnText ON CashPoolTransfDrctn = _DrctnText.CashPoolTransfDrctn  -- association [0..1]
LEFT OUTER JOIN I_Bank_2 AS _PayingBankName ON Bank = _PayingBankName.BankInternalID AND BankCountry = _PayingBankName.BankCountry  -- association [0..1]
LEFT OUTER JOIN I_Bank_2 AS _PayeeBankName ON PayeeBank = _PayeeBankName.BankInternalID AND PayeeBankCountry = _PayeeBankName.BankCountry  -- association [0..1]
LEFT OUTER JOIN I_PaymentMethodText AS _PaymentMethodText ON BankCountry = _PaymentMethodText.Country AND PaymentMethod = _PaymentMethodText.PaymentMethod  -- association [0..*]
;