I_CSHCONCNBKACCTTP

CDS View

Bank Account of Cash Concentration

I_CSHCONCNBKACCTTP is a CDS View in S/4HANA. Bank Account of Cash Concentration. It contains 49 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_CshConcnBkAcctTP view from CONSUMPTION Bank Account of Cash Concentration

Fields (49)

KeyField CDS FieldsUsed in Views
KEY CashConcentrationID CashConcentrationID 1
KEY PayeeBankAccountInternalID PayeeBankAccountInternalID 1
KEY PayingBankAccountInternalID PayingBankAccountInternalID 1
AccountType AccountType 1
AftBalInBkAcctCrcy AftBalInBkAcctCrcy 1
Bank Bank 1
BankAccountCurrency BankAccountCurrency 1
BankCountry BankCountry 1
CashConcentrationStatus CashConcentrationStatus 1
CashMemoRecordID CashMemoRecordID 1
CashPoolName CashPoolName 1
CashPoolTransfDrctn CashPoolTransfDrctn 1
ClsgBalAmtInBkAcctCrcy ClsgBalAmtInBkAcctCrcy 1
CompanyCode CompanyCode 1
DataExchangeInstruction1 DataExchangeInstruction1 1
DataExchangeInstruction2 DataExchangeInstruction2 1
DataExchangeInstruction3 DataExchangeInstruction3 1
DataExchangeInstruction4 DataExchangeInstruction4 1
DataExchangeInstructionKey DataExchangeInstructionKey 1
ExpirationDate ExpirationDate 1
HouseBank HouseBank 1
HouseBankAccount HouseBankAccount 1
IBAN IBAN 1
IsSinglePayment IsSinglePayment 1
LeadingCashPoolID LeadingCashPoolID 1
MaxTransferAmount MaxTransferAmount 1
MinTransferAmount MinTransferAmount 1
Note Note 1
PayeeBank PayeeBank 1
PayeeBankAccount PayeeBankAccount 1
PayeeBankAccountDescription PayeeBankAccountDescription 1
PayeeBankCountry PayeeBankCountry 1
PayeeCompanyCode PayeeCompanyCode 1
PayeeHouseBank PayeeHouseBank 1
PayeeHouseBankAccount PayeeHouseBankAccount 1
PayeeIBAN PayeeIBAN 1
PayingBankAccount PayingBankAccount 1
PayingBankAccountDescription PayingBankAccountDescription 1
PaymentMethod PaymentMethod 1
PaymentMethodSupplement PaymentMethodSupplement 1
PaymentReference PaymentReference 1
PaymentRequest PaymentRequest 1
PlanningLevel PlanningLevel 1
StateCentralBankPaymentReason StateCentralBankPaymentReason 1
SubscriptionOrder SubscriptionOrder 1
SupplyingCountry SupplyingCountry 1
TgtBalAmtInBkAcctCrcy TgtBalAmtInBkAcctCrcy 1
TransfAmtInBkAcctCrcy TransfAmtInBkAcctCrcy 1
ValueDate ValueDate 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Bank Account of Cash Concentration
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CSHCONCNBKACCTTP (
    CASHCONCENTRATIONID,
    PAYEEBANKACCOUNTINTERNALID,
    PAYINGBANKACCOUNTINTERNALID,
    ACCOUNTTYPE,
    AFTBALINBKACCTCRCY,
    BANK,
    BANKACCOUNTCURRENCY,
    BANKCOUNTRY,
    CASHCONCENTRATIONSTATUS,
    CASHMEMORECORDID,
    CASHPOOLNAME,
    CASHPOOLTRANSFDRCTN,
    CLSGBALAMTINBKACCTCRCY,
    COMPANYCODE,
    DATAEXCHANGEINSTRUCTION1,
    DATAEXCHANGEINSTRUCTION2,
    DATAEXCHANGEINSTRUCTION3,
    DATAEXCHANGEINSTRUCTION4,
    DATAEXCHANGEINSTRUCTIONKEY,
    EXPIRATIONDATE,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    IBAN,
    ISSINGLEPAYMENT,
    LEADINGCASHPOOLID,
    MAXTRANSFERAMOUNT,
    MINTRANSFERAMOUNT,
    NOTE,
    PAYEEBANK,
    PAYEEBANKACCOUNT,
    PAYEEBANKACCOUNTDESCRIPTION,
    PAYEEBANKCOUNTRY,
    PAYEECOMPANYCODE,
    PAYEEHOUSEBANK,
    PAYEEHOUSEBANKACCOUNT,
    PAYEEIBAN,
    PAYINGBANKACCOUNT,
    PAYINGBANKACCOUNTDESCRIPTION,
    PAYMENTMETHOD,
    PAYMENTMETHODSUPPLEMENT,
    PAYMENTREFERENCE,
    PAYMENTREQUEST,
    PLANNINGLEVEL,
    STATECENTRALBANKPAYMENTREASON,
    SUBSCRIPTIONORDER,
    SUPPLYINGCOUNTRY,
    TGTBALAMTINBKACCTCRCY,
    TRANSFAMTINBKACCTCRCY,
    VALUEDATE,
    PRIMARY KEY (CASHCONCENTRATIONID, PAYEEBANKACCOUNTINTERNALID, PAYINGBANKACCOUNTINTERNALID)
);