C_FinInvcBankAcctBasicDataFDP

DDL: C_FININVCBANKACCTBASICDATAFDP Type: view_entity CONSUMPTION Package: FINS_OUTPUT_MGMT_FO_FICUS_INV
58 Fields 1 Data Sources

Bank Acct Basic Data for FI Invoice

C_FinInvcBankAcctBasicDataFDP is a Consumption CDS View that provides data about "Bank Acct Basic Data for FI Invoice" in SAP S/4HANA. It reads from 1 data source (I_BankAccountBasicData) and exposes 58 fields with key field BankAccountInternalID. Part of development package FINS_OUTPUT_MGMT_FO_FICUS_INV.

Data Sources (1)

SourceAliasJoin Type
I_BankAccountBasicData I_BankAccountBasicData from

Annotations (8)

NameValueLevelField
EndUserText.label Bank Acct Basic Data for FI Invoice view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY BankAccountInternalID BankAccountInternalID Technical ID
BankCountry BankCountry Bank Ctry/Rgn. Key
Bank Bank Bank Number
BankAccountNumber BankAccountNumber Bank Account
BankAccountType BankAccountType Account Type
BankAccountContractType BankAccountContractType
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
IBAN IBAN IBAN House Bank
BankAccountStatus BankAccountStatus Account Status
CompanyCode CompanyCode Receiver Company Code
ProfitCenter ProfitCenter Profit Center
BusinessArea BusinessArea Business Area
Segment Segment Segment number
BankAccountHolderName BankAccountHolderName Account Holder
BankContactPerson BankContactPerson General Contact
BankRelationshipManager BankRelationshipManager Relationship Manager
CompanyContactPerson CompanyContactPerson Contact Person
BankAccountSupervisor BankAccountSupervisor Account Supervisor
CreatedByUser CreatedByUser User Name
OpenedByUser OpenedByUser Opened By
LastChangedByUser LastChangedByUser User Name
ReviewedByUser ReviewedByUser Reviewed By
ClosedByUser ClosedByUser Closed By
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
DomesticCutOffTime DomesticCutOffTime Cut-Off Domestic
CrossBorderCutOffTime CrossBorderCutOffTime Cut-Off Cross Border
PlannedClosingDate PlannedClosingDate Planned Closing
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
OpenedDate OpenedDate Opened On
OpenedTime OpenedTime Opened At
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
ClosedDate ClosedDate Closed On
ClosedTime ClosedTime Closed At
BankControlKey BankControlKey Control Key
IBANValidityStartDate IBANValidityStartDate IBAN Valid From
PaymentTransactionTypeGroup PaymentTransactionTypeGroup Payment Transaction Type Group
BankAccountCurrency BankAccountCurrency Currency
LeadingCashPoolID LeadingCashPoolID Cash Pool Name
ParticipantCashPoolID ParticipantCashPoolID Cash Pool Name
MaxTargetAmount MaxTargetAmount Target Balance
MinTransferAmount MinTransferAmount Min.Transfer Amount
LeadingPaymentMethod LeadingPaymentMethod Payment Method
ParticipantPaymentMethod ParticipantPaymentMethod Payment Method
PaymentServiceProvider PaymentServiceProvider Payt Srvc Provider
CashToleranceGroup CashToleranceGroup Tolerance Group
IntradayIsReconciled IntradayIsReconciled Reconcile Intraday
TreasuryFinancialObject TreasuryFinancialObject Val. Obj. No.
BankStatementCheckTime BankStatementCheckTime Check Time
BankStatementImportMethod BankStatementImportMethod EoD
IntraDayBankStateImportMethod IntraDayBankStateImportMethod Intraday
BankStatementImportChannel BankStatementImportChannel Importing Channel
IsUploadOfIntraDayStatement IsUploadOfIntraDayStatement Intraday Upload
EndOfDayIsReconciled EndOfDayIsReconciled Reconcile End-of-Day
IHBAccountHolder IHBAccountHolder Busn. Partner
BankAccountCharacteristic BankAccountCharacteristic

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_FinInvcBankAcctBasicDataFDP.
-- 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_FinInvcBankAcctBasicDataFDP AS
SELECT
  BankAccountInternalID,
  BankCountry,
  Bank,
  BankAccountNumber,
  BankAccountType,
  BankAccountContractType,
  ValidityStartDate,
  ValidityEndDate,
  IBAN,
  BankAccountStatus,
  CompanyCode,
  ProfitCenter,
  BusinessArea,
  Segment,
  BankAccountHolderName,
  BankContactPerson,
  BankRelationshipManager,
  CompanyContactPerson,
  BankAccountSupervisor,
  CreatedByUser,
  OpenedByUser,
  LastChangedByUser,
  ReviewedByUser,
  ClosedByUser,
  IsMarkedForDeletion,
  DomesticCutOffTime,
  CrossBorderCutOffTime,
  PlannedClosingDate,
  CreationDate,
  CreationTime,
  OpenedDate,
  OpenedTime,
  LastChangeDate,
  LastChangeTime,
  ClosedDate,
  ClosedTime,
  BankControlKey,
  IBANValidityStartDate,
  PaymentTransactionTypeGroup,
  BankAccountCurrency,
  LeadingCashPoolID,
  ParticipantCashPoolID,
  MaxTargetAmount,
  MinTransferAmount,
  LeadingPaymentMethod,
  ParticipantPaymentMethod,
  PaymentServiceProvider,
  CashToleranceGroup,
  IntradayIsReconciled,
  TreasuryFinancialObject,
  BankStatementCheckTime,
  BankStatementImportMethod,
  IntraDayBankStateImportMethod,
  BankStatementImportChannel,
  IsUploadOfIntraDayStatement,
  EndOfDayIsReconciled,
  IHBAccountHolder,
  BankAccountCharacteristic
FROM I_BankAccountBasicData
;

Learn More