C_BankAccLimitTP

DDL: C_BANKACCLIMITTP Type: view CONSUMPTION
20 Fields 1 Data Sources 1 Associations

Bank Account Limit on Draft 2.0

C_BankAccLimitTP is a Consumption CDS View that provides data about "Bank Account Limit on Draft 2.0" in SAP S/4HANA. It reads from 1 data source (I_BankAccLimitTP) and exposes 20 fields with key fields BankAccountInternalID, OverdraftLimit, BankAccountRevision. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_BankAccLimitTP AccountLim from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_BankAccountTP _Account $projection.BankAccountInternalID = _Account.BankAccountInternalID and $projection.BankAccountRevision = _Account.BankAccountRevision

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CBANKACCLIMTP view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Bank Account Limit on Draft 2.0 view
VDM.viewType #CONSUMPTION view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.allowExtensions true view
UI.headerInfo.typeName Overdraft Limits view
UI.headerInfo.typeNamePlural Overdraft Limits view
UI.headerInfo.title.value OverdraftLimitForEdit view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY BankAccountInternalID BankAccountInternalID Technical ID
KEY OverdraftLimit OverdraftLimit Overdraft Limit ID
KEY BankAccountRevision BankAccountRevision Revision Number
OverdraftLimitForEdit OverdraftLimitForEdit Overdraft Limit ID
OverdraftLimitStartDate OverdraftLimitStartDate Validity Start Time
OverdraftLimitEndDate OverdraftLimitEndDate Validity End Time
OverdraftLimitAmount OverdraftLimitAmount Value Amount
OverdraftLimitCurrency OverdraftLimitCurrency Transaction Currency
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
_Account _Account
CompanyCode _Account CompanyCode Receiver Company Code
CompanyCodeName _Account CompanyCodeName Company Name
BankAccountType _Account BankAccountType Account Type
BusinessArea _Account BusinessArea Business Area
BusinessAreaName _Account BusinessAreaName Business Area Name
Segment _Account Segment Segment number
SegmentName _Account SegmentName Segment Name
ControllingArea _Account ControllingArea Controlling Area
ControllingAreaName _Account ControllingAreaName Long Text
ProfitCenter _Account ProfitCenter Profit Center

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_BankAccLimitTP.
-- 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_BankAccLimitTP AS
SELECT
  BankAccountInternalID,
  OverdraftLimit,
  BankAccountRevision,
  OverdraftLimitForEdit,
  OverdraftLimitStartDate,
  OverdraftLimitEndDate,
  OverdraftLimitAmount,
  OverdraftLimitCurrency,
  IsMarkedForDeletion,
  _Account.CompanyCode AS CompanyCode,
  _Account.CompanyCodeName AS CompanyCodeName,
  _Account.BankAccountType AS BankAccountType,
  _Account.BusinessArea AS BusinessArea,
  _Account.BusinessAreaName AS BusinessAreaName,
  _Account.Segment AS Segment,
  _Account.SegmentName AS SegmentName,
  _Account.ControllingArea AS ControllingArea,
  _Account.ControllingAreaName AS ControllingAreaName,
  _Account.ProfitCenter AS ProfitCenter
FROM I_BankAccLimitTP AS AccountLim
LEFT OUTER JOIN C_BankAccountTP AS _Account ON BankAccountInternalID = _Account.BankAccountInternalID AND BankAccountRevision = _Account.BankAccountRevision  -- association [1..1]
;

Learn More