What is C_BankAccountWithRevision in SAP S/4HANA?

C_BankAccountWithRevision is a consumption CDS view in SAP S/4HANA. Bank Account With Revision It contains 122 fields.

Which tables does C_BankAccountWithRevision read from?

C_BankAccountWithRevision reads data from: I_BankAccountWithRevision.

What VDM layer is C_BankAccountWithRevision?

C_BankAccountWithRevision is classified as a Consumption view optimized for specific business scenarios and reporting.

C_BankAccountWithRevision

DDL: C_BANKACCOUNTWITHREVISION SQL: CBANKACCTWITHREV Type: view CONSUMPTION

122 Fields 1 Data Sources

Bank Account With Revision

C_BankAccountWithRevision is a Consumption CDS View that provides data about "Bank Account With Revision" in SAP S/4HANA. It reads from 1 data source (I_BankAccountWithRevision) and exposes 122 fields with key fields BankAccountInternalID, BankAccountRevision.

Data Sources (1)

Source	Alias	Join Type
I_BankAccountWithRevision	Amd	from

Annotations (9)

Name	Value	Level
AbapCatalog.sqlViewName	CBANKACCTWITHREV	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Bank Account With Revision	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.dataClass	#MIXED	view
AccessControl.personalData.blocking	#REQUIRED	view

Fields (122)

Key	Field	Source Table	Source Field	Description
KEY	BankAccountInternalID	I_BankAccountWithRevision	BankAccountInternalID	Technical ID
KEY	BankAccountRevision	I_BankAccountWithRevision	BankAccountRevision	Revision Number
	BankAccountDescription
	BankCountry	I_BankAccountWithRevision	BankCountry	Bank Ctry/Rgn. Key
	Bank	I_BankAccountWithRevision	Bank	Bank Number
	BankAccountNumber	I_BankAccountWithRevision	BankAccountNumber	Bank Account
	BankAccountType	I_BankAccountWithRevision	BankAccountType	Account Type
	BankAccountTypeText
	ValidityStartDate	I_BankAccountWithRevision	ValidityStartDate	Validity Start Date
	ValidityEndDate	I_BankAccountWithRevision	ValidityEndDate	ValidTo
	IBAN	I_BankAccountWithRevision	IBAN	IBAN House Bank
	BankAccountStatus	I_BankAccountWithRevision	BankAccountStatus	Account Status
	LeadingCashPoolID	I_BankAccountWithRevision	LeadingCashPoolID	Cash Pool Name
	CompanyCode	I_BankAccountWithRevision	CompanyCode	Receiver Company Code
	ProfitCenter	I_BankAccountWithRevision	ProfitCenter	Profit Center
	BusinessArea	I_BankAccountWithRevision	BusinessArea	Business Area
	Segment	I_BankAccountWithRevision	Segment	Segment number
	BankAccountHolderName	I_BankAccountWithRevision	BankAccountHolderName	Account Holder
	BankContactPerson	I_BankAccountWithRevision	BankContactPerson	General Contact
	BankRelationshipManager	I_BankAccountWithRevision	BankRelationshipManager	Relationship Manager
	CompanyContactPerson	I_BankAccountWithRevision	CompanyContactPerson	Contact Person
	BankAccountSupervisor	I_BankAccountWithRevision	BankAccountSupervisor	Account Supervisor
	BankStatementImportMethod	I_BankAccountWithRevision	BankStatementImportMethod	EoD
	IntraDayBankStateImportMethod	I_BankAccountWithRevision	IntraDayBankStateImportMethod	Intraday
	BankStatementCheckTime	I_BankAccountWithRevision	BankStatementCheckTime	Check Time
	CreatedByUser	I_BankAccountWithRevision	CreatedByUser	User Name
	OpenedByUser	I_BankAccountWithRevision	OpenedByUser	Opened By
	LastChangedByUser	I_BankAccountWithRevision	LastChangedByUser	User Name
	ReviewedByUser	I_BankAccountWithRevision	ReviewedByUser	Reviewed By
	ClosedByUser	I_BankAccountWithRevision	ClosedByUser	Closed By
	BankStatementImportChannel	I_BankAccountWithRevision	BankStatementImportChannel	Importing Channel
	DomesticCutOffTime	I_BankAccountWithRevision	DomesticCutOffTime	Cut-Off Domestic
	CrossBorderCutOffTime	I_BankAccountWithRevision	CrossBorderCutOffTime	Cut-Off Cross Border
	PlannedClosingDate	I_BankAccountWithRevision	PlannedClosingDate	Planned Closing
	IsUploadOfIntraDayStatement	I_BankAccountWithRevision	IsUploadOfIntraDayStatement	Intraday Upload
	CreationDate	I_BankAccountWithRevision	CreationDate	Time Stamp
	CreationTime	I_BankAccountWithRevision	CreationTime	Time of Change
	OpenedDate	I_BankAccountWithRevision	OpenedDate	Opened On
	LastChangeDate	I_BankAccountWithRevision	LastChangeDate	Time Stamp
	LastChangeTime	I_BankAccountWithRevision	LastChangeTime	Time changed
	ClosedDate	I_BankAccountWithRevision	ClosedDate	Closed On
	ClosedTime	I_BankAccountWithRevision	ClosedTime	Closed At
	BankControlKey	I_BankAccountWithRevision	BankControlKey	Control Key
	IBANValidityStartDate	I_BankAccountWithRevision	IBANValidityStartDate	IBAN Valid From
	ArchObjectNumber	I_BankAccountWithRevision	ArchObjectNumber	Text Name
	PaymentTransactionTypeGroup	I_BankAccountWithRevision	PaymentTransactionTypeGroup	Payment Transaction Type Group
	ProcessingStatus	I_BankAccountWithRevision	ProcessingStatus	Worklist Status
	DifferenceStatus	I_BankAccountWithRevision	DifferenceStatus	Difference Sts
	SerialNumberStatus	I_BankAccountWithRevision	SerialNumberStatus	Serial No. Sts
	ReconciliationStatus	I_BankAccountWithRevision	ReconciliationStatus	Reconcil. Sts
	ExpectedInterval	I_BankAccountWithRevision	ExpectedInterval	Interval
	ControlFrequency	I_BankAccountWithRevision	ControlFrequency	Interval Unit
	FactoryCalendar	I_BankAccountWithRevision	FactoryCalendar	Factory Calendar
	DisplayItem	I_BankAccountWithRevision	DisplayItem
	DifferenceAmount	I_BankAccountWithRevision	DifferenceAmount	Amount Difference in Foreign Currency
	BankAccountCurrency	I_BankAccountWithRevision	BankAccountCurrency	Currency
	ParticipantCashPoolID	I_BankAccountWithRevision	ParticipantCashPoolID	Cash Pool Name
	MaxTargetAmount	I_BankAccountWithRevision	MaxTargetAmount	Target Balance
	MinTargetAmount	I_BankAccountWithRevision	MinTargetAmount	Min. Target Amount
	MinTransferAmount	I_BankAccountWithRevision	MinTransferAmount	Min.Transfer Amount
	LeadingPaymentMethod	I_BankAccountWithRevision	LeadingPaymentMethod	Payment Method
	ParticipantPaymentMethod	I_BankAccountWithRevision	ParticipantPaymentMethod	Payment Method
	PaymentServiceProvider	I_BankAccountWithRevision	PaymentServiceProvider	Payt Srvc Provider
	_Bank	I_BankAccountWithRevision	_Bank
	BankAddressID	_Bank	AddressID	Ship-to address
	BankName	_Bank	BankName	Bank Name
	BankBranch	_Bank	BankBranch
	ShortStreetName	_Bank	ShortStreetName
	ShortCityName	_Bank	ShortCityName
	CountryName
	District
	PostalCode
	HouseNumber
	HouseNumberSupplementText
	Building
	Floor
	RoomNumber
	Region
	FormOfAddress
	Nation
	PhoneNumber
	FaxNumber
	EmailAddress
	_CompanyCode	I_BankAccountWithRevision	_CompanyCode
	CompanyCodeName	_CompanyCode	CompanyCodeName	Company Name
	CompanyStreetName
	CompanyPostalCode
	CompanyCodeCityName
	CompanyCodeCountry
	CompanyDistrict
	CompanyHouseNumber
	CompanyBuilding
	CompanyFloor
	CompanyRoomNumber
	CompanyRegion
	CompanyNation
	CompanyPhoneNumber
	CompanyFaxNumber
	CompanyCountryName
	CompanyEmailAddress
	_BankContact	I_BankAccountWithRevision	_BankContact
	_BankContactAddress	I_BankAccountWithRevision	_BankContactAddress
	BusinessPartnerName	_BankContact	BusinessPartnerName	Extracted Customer Name
	BusinessPartnerFullName	_BankContact	BusinessPartnerFullName	Broker Name
	BusinessPartnerTitle
	PersonFullName	_BankContact	PersonFullName	Full Name
	ContactPersonDepartmentName
	ContactPersonFunctionName
	BusinessPartnerCityName	_BankContactAddress	CityName	Name
	BusinessPartnerDistrict	_BankContactAddress	District	District Court
	BusinessPartnerPostalCode	_BankContactAddress	PostalCode	Postal Code
	BusinessPartnerStreetName	_BankContactAddress	StreetName	Text
	BusinessPartnerHouseNumber	_BankContactAddress	HouseNumber	House Number
	BusinessPartnerCountry	_BankContactAddress	Country	Venue: Ctry/Reg
	BusinessPartnerCountryName
	BPRgn	_BankContactAddress	Region	Venue Region
	BusinessPartnerPhoneNumber	_BankContactAddress	PhoneNumber	Telephone no.
	BusinessPartnerFaxNumber	_BankContactAddress	FaxNumber	Fax Number
	BusinessPartnerEmailAddress	_BankContactAddress	EmailAddress	E-Mail Address
	CompanyAddressID	_CompanyCode	AddressID	Ship-to address
	_Address	_CompanyCode	_Address
	FormPrintDate

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_BankAccountWithRevision.
-- 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: CBANKACCTWITHREV

CREATE VIEW C_BankAccountWithRevision AS
SELECT
  Amd.BankAccountInternalID AS BankAccountInternalID,
  Amd.BankAccountRevision AS BankAccountRevision,
  _AccountTextInCurrentLang[1: Language=$session.system_language].BankAccountDescription AS BankAccountDescription,
  Amd.BankCountry AS BankCountry,
  Amd.Bank AS Bank,
  Amd.BankAccountNumber AS BankAccountNumber,
  Amd.BankAccountType AS BankAccountType,
  _AccountTypeText[1: Language=$session.system_language].BankAccountTypeText AS BankAccountTypeText,
  Amd.ValidityStartDate AS ValidityStartDate,
  Amd.ValidityEndDate AS ValidityEndDate,
  Amd.IBAN AS IBAN,
  Amd.BankAccountStatus AS BankAccountStatus,
  Amd.LeadingCashPoolID AS LeadingCashPoolID,
  Amd.CompanyCode AS CompanyCode,
  Amd.ProfitCenter AS ProfitCenter,
  Amd.BusinessArea AS BusinessArea,
  Amd.Segment AS Segment,
  Amd.BankAccountHolderName AS BankAccountHolderName,
  Amd.BankContactPerson AS BankContactPerson,
  Amd.BankRelationshipManager AS BankRelationshipManager,
  Amd.CompanyContactPerson AS CompanyContactPerson,
  Amd.BankAccountSupervisor AS BankAccountSupervisor,
  Amd.BankStatementImportMethod AS BankStatementImportMethod,
  Amd.IntraDayBankStateImportMethod AS IntraDayBankStateImportMethod,
  Amd.BankStatementCheckTime AS BankStatementCheckTime,
  Amd.CreatedByUser AS CreatedByUser,
  Amd.OpenedByUser AS OpenedByUser,
  Amd.LastChangedByUser AS LastChangedByUser,
  Amd.ReviewedByUser AS ReviewedByUser,
  Amd.ClosedByUser AS ClosedByUser,
  Amd.BankStatementImportChannel AS BankStatementImportChannel,
  Amd.DomesticCutOffTime AS DomesticCutOffTime,
  Amd.CrossBorderCutOffTime AS CrossBorderCutOffTime,
  Amd.PlannedClosingDate AS PlannedClosingDate,
  Amd.IsUploadOfIntraDayStatement AS IsUploadOfIntraDayStatement,
  Amd.CreationDate AS CreationDate,
  Amd.CreationTime AS CreationTime,
  Amd.OpenedDate AS OpenedDate,
  Amd.LastChangeDate AS LastChangeDate,
  Amd.LastChangeTime AS LastChangeTime,
  Amd.ClosedDate AS ClosedDate,
  Amd.ClosedTime AS ClosedTime,
  Amd.BankControlKey AS BankControlKey,
  Amd.IBANValidityStartDate AS IBANValidityStartDate,
  Amd.ArchObjectNumber AS ArchObjectNumber,
  Amd.PaymentTransactionTypeGroup AS PaymentTransactionTypeGroup,
  Amd.ProcessingStatus AS ProcessingStatus,
  Amd.DifferenceStatus AS DifferenceStatus,
  Amd.SerialNumberStatus AS SerialNumberStatus,
  Amd.ReconciliationStatus AS ReconciliationStatus,
  Amd.ExpectedInterval AS ExpectedInterval,
  Amd.ControlFrequency AS ControlFrequency,
  Amd.FactoryCalendar AS FactoryCalendar,
  Amd.DisplayItem AS DisplayItem,
  Amd.DifferenceAmount AS DifferenceAmount,
  Amd.BankAccountCurrency AS BankAccountCurrency,
  Amd.ParticipantCashPoolID AS ParticipantCashPoolID,
  Amd.MaxTargetAmount AS MaxTargetAmount,
  Amd.MinTargetAmount AS MinTargetAmount,
  Amd.MinTransferAmount AS MinTransferAmount,
  Amd.LeadingPaymentMethod AS LeadingPaymentMethod,
  Amd.ParticipantPaymentMethod AS ParticipantPaymentMethod,
  Amd.PaymentServiceProvider AS PaymentServiceProvider,
  Amd._Bank AS _Bank,
  _Bank.AddressID AS BankAddressID,
  _Bank.BankName AS BankName,
  _Bank.BankBranch AS BankBranch,
  _Bank.ShortStreetName AS ShortStreetName,
  _Bank.ShortCityName AS ShortCityName,
  _Bank._Country._Text[1: Language=$session.system_language].CountryName AS CountryName,
  _Bank._Address.District AS District,
  _Bank._Address.PostalCode AS PostalCode,
  _Bank._Address.HouseNumber AS HouseNumber,
  _Bank._Address.HouseNumberSupplementText AS HouseNumberSupplementText,
  _Bank._Address.Building AS Building,
  _Bank._Address.Floor AS Floor,
  _Bank._Address.RoomNumber AS RoomNumber,
  _Bank._Address.Region AS Region,
  _Bank._Address.FormOfAddress AS FormOfAddress,
  _Bank._Address.Nation AS Nation,
  _Bank._Address.PhoneNumber AS PhoneNumber,
  _Bank._Address.FaxNumber AS FaxNumber,
  _Bank._Address._DefaultEmailAddress.EmailAddress AS EmailAddress,
  Amd._CompanyCode AS _CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _CompanyCode._Address.StreetName AS CompanyStreetName,
  _CompanyCode._Address.PostalCode AS CompanyPostalCode,
  _CompanyCode._Address.CityName AS CompanyCodeCityName,
  _CompanyCode._Address.Country AS CompanyCodeCountry,
  _CompanyCode._Address.District AS CompanyDistrict,
  _CompanyCode._Address.HouseNumber AS CompanyHouseNumber,
  _CompanyCode._Address.Building AS CompanyBuilding,
  _CompanyCode._Address.Floor AS CompanyFloor,
  _CompanyCode._Address.RoomNumber AS CompanyRoomNumber,
  _CompanyCode._Address.Region AS CompanyRegion,
  _CompanyCode._Address.Nation AS CompanyNation,
  _CompanyCode._Address.PhoneNumber AS CompanyPhoneNumber,
  _CompanyCode._Address.FaxNumber AS CompanyFaxNumber,
  _CompanyCode._Address._Country._Text[1: Language=$session.system_language].CountryName AS CompanyCountryName,
  _CompanyCode._Address._DefaultEmailAddress.EmailAddress AS CompanyEmailAddress,
  Amd._BankContact AS _BankContact,
  Amd._BankContactAddress AS _BankContactAddress,
  _BankContact.BusinessPartnerName AS BusinessPartnerName,
  _BankContact.BusinessPartnerFullName AS BusinessPartnerFullName,
  _BankContact._FormOfAddress._Text[1: Language=$session.system_language].FormOfAddressName AS BusinessPartnerTitle,
  _BankContact.PersonFullName AS PersonFullName,
  _ContactRelationship._ContactPersonDepartmentText[1: Language=$session.system_language].ContactPersonDepartmentName AS ContactPersonDepartmentName,
  _ContactRelationship._ContactPersonFunctionText[1: Language=$session.system_language].ContactPersonFunctionName AS ContactPersonFunctionName,
  _BankContactAddress.CityName AS BusinessPartnerCityName,
  _BankContactAddress.District AS BusinessPartnerDistrict,
  _BankContactAddress.PostalCode AS BusinessPartnerPostalCode,
  _BankContactAddress.StreetName AS BusinessPartnerStreetName,
  _BankContactAddress.HouseNumber AS BusinessPartnerHouseNumber,
  _BankContactAddress.Country AS BusinessPartnerCountry,
  _BankContactAddress._Address._Country._Text[1: Language=$session.system_language].CountryName AS BusinessPartnerCountryName,
  _BankContactAddress.Region AS BPRgn,
  _BankContactAddress.PhoneNumber AS BusinessPartnerPhoneNumber,
  _BankContactAddress.FaxNumber AS BusinessPartnerFaxNumber,
  _BankContactAddress.EmailAddress AS BusinessPartnerEmailAddress,
  _CompanyCode.AddressID AS CompanyAddressID,
  _CompanyCode._Address AS _Address,
  $session.system_date AS FormPrintDate
FROM I_BankAccountWithRevision AS Amd
;

Depth:

C_BankAccountWithRevision view

I_BankAccountWithRevision view