R_BkAcctIntrstCndnHeaderTP

DDL: R_BKACCTINTRSTCNDNHEADERTP Type: view_entity TRANSACTIONAL Package: FCLM_INTEREST_CONDITION
31 Fields 1 Data Sources 1 Associations

Bank Account Interest Cond Header - TP

R_BkAcctIntrstCndnHeaderTP is a Transactional CDS View that provides data about "Bank Account Interest Cond Header - TP" in SAP S/4HANA. It reads from 1 data source (I_BkAcctIntrstCndnHeader) and exposes 31 fields with key field BkAcctIntrstCndnUUID. It has 1 association to related views. Part of development package FCLM_INTEREST_CONDITION.

Data Sources (1)

SourceAliasJoin Type
I_BkAcctIntrstCndnHeader _BkAcctIntrstCndnHeader from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FactoryCalendar _FactoryCalendar $projection.FinConditionFactoryCalendar1 = _FactoryCalendar.FactoryCalendar

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Bank Account Interest Cond Header - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name BankAccountInterestCondition view
Metadata.allowExtensions true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY BkAcctIntrstCndnUUID BkAcctIntrstCndnUUID
BkAcctIntrstCndnValidFromDate BkAcctIntrstCndnValidFromDate
BankAccountCurrency BankAccountCurrency Currency
InterestConditionType InterestConditionType
BankAccountInterestCategory BankAccountInterestCategory
InterestCalculationMethod InterestCalculationMethod
RoundingCategory RoundingCategory
BkAcctCndnFrequencyUnit BkAcctCndnFrequencyUnit
BkIntrstCndnIndFrequency BkIntrstCndnIndFrequency
BkAcctCndnFrequencyNumber BkAcctCndnFrequencyNumber
CalculationDate CalculationDate
BkAcctIntrstStrtEndInclusive BkAcctIntrstStrtEndInclusive
DueDate DueDate Promised For
BkAcctIntrstCalDteIsMnthEnd BkAcctIntrstCalDteIsMnthEnd
BkIntrstCndnDuDteIsMnthEndDate BkIntrstCndnDuDteIsMnthEndDate
InterestCalcDteWrkgDayShft InterestCalcDteWrkgDayShft
FinConditionFactoryCalendar1 FinConditionFactoryCalendar1
FinConditionFactoryCalendar2 FinConditionFactoryCalendar2
FinConditionFactoryCalendar3 FinConditionFactoryCalendar3
FinConditionFactoryCalendar4 FinConditionFactoryCalendar4
FinConditionFactoryCalendar5 FinConditionFactoryCalendar5
LocalLastChangeDateTime LocalLastChangeDateTime Time Stamp
_BkAcctIntrstConditionTP _BkAcctIntrstConditionTP
_DomainIntrstType _DomainIntrstType
_Rounding _Rounding
_FactoryCalendar _FactoryCalendar
_IntrstCalDomain _IntrstCalDomain
_WorkDayShift _WorkDayShift
_InclusiveInd _InclusiveInd
_Unit _Unit
_IndFrequency _IndFrequency

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 R_BkAcctIntrstCndnHeaderTP.
-- 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 R_BkAcctIntrstCndnHeaderTP AS
SELECT
  BkAcctIntrstCndnUUID,
  BkAcctIntrstCndnValidFromDate,
  BankAccountCurrency,
  InterestConditionType,
  BankAccountInterestCategory,
  InterestCalculationMethod,
  RoundingCategory,
  BkAcctCndnFrequencyUnit,
  BkIntrstCndnIndFrequency,
  BkAcctCndnFrequencyNumber,
  CalculationDate,
  BkAcctIntrstStrtEndInclusive,
  DueDate,
  BkAcctIntrstCalDteIsMnthEnd,
  BkIntrstCndnDuDteIsMnthEndDate,
  InterestCalcDteWrkgDayShft,
  FinConditionFactoryCalendar1,
  FinConditionFactoryCalendar2,
  FinConditionFactoryCalendar3,
  FinConditionFactoryCalendar4,
  FinConditionFactoryCalendar5,
  LocalLastChangeDateTime
FROM I_BkAcctIntrstCndnHeader AS _BkAcctIntrstCndnHeader
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON FinConditionFactoryCalendar1 = _FactoryCalendar.FactoryCalendar  -- association [0..1]
;

Learn More