Finsvd_F4_Rldnr_For_Simulation

DDL: FINSVD_F4_RLDNR_FOR_SIMULATION SQL: FINSV_F4_LDSIM Type: view

Value help view: extension ledger for simulation

Finsvd_F4_Rldnr_For_Simulation is a CDS View that provides data about "Value help view: extension ledger for simulation" in SAP S/4HANA. It reads from 3 data sources (finsc_actve_appl, finsc_ledger, finsc_ledger_t) and exposes 6 fields with key fields mandt, rldnr. It has 1 association to related views.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
finsc_actve_appl finsc_actve_appl inner
finsc_ledger finsc_ledger from
finsc_ledger_t finsc_ledger_t left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_LedgerExtTypeText _extledger_type_name $projection.ExtensionLedgerType = _extledger_type_name.ExtensionLedgerType

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FINSV_F4_LDSIM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Value help view: extension ledger for simulation view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #S view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY mandt finsc_ledger mandt
KEY rldnr finsc_ledger rldnr
name finsc_ledger_t name
ExtensionLedgerType finsc_ledger ext_ledger_type
ExtensionLedgerTypeName
core finsc_ledger core 
@AbapCatalog.sqlViewName: 'FINSV_F4_LDSIM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Value help view: extension ledger for simulation'

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass:#MASTER
@ObjectModel.usageType.sizeCategory:#S 

define view Finsvd_F4_Rldnr_For_Simulation
  as select from    finsc_ledger
    left outer join finsc_ledger_t   on  finsc_ledger_t.mandt = finsc_ledger.mandt
                                     and finsc_ledger_t.rldnr = finsc_ledger.rldnr
                                     and finsc_ledger_t.langu = $session.system_language
    inner join      finsc_actve_appl on  finsc_actve_appl.mandt   = finsc_ledger.mandt
                                     and finsc_actve_appl.appl    = finsc_ledger.appl
                                     and finsc_actve_appl.subappl = finsc_ledger.subappl
  association [0..*] to I_LedgerExtTypeText as _extledger_type_name on $projection.ExtensionLedgerType = _extledger_type_name.ExtensionLedgerType
{
  key finsc_ledger.mandt,
  key finsc_ledger.rldnr,
      finsc_ledger_t.name,
      finsc_ledger.ext_ledger_type as ExtensionLedgerType,
      cast( _extledger_type_name[1:Language=$session.system_language].ExtensionLedgerTypeName as fins_ext_ledger_type_name ) as ExtensionLedgerTypeName,
      finsc_ledger.core
}
where
  finsc_ledger.ext_ledger_type = 'S'          
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGEREXTTYPETEXT",
"FINSC_ACTVE_APPL",
"FINSC_LEDGER",
"FINSC_LEDGER_T"
],
"ASSOCIATED":
[
"I_LEDGEREXTTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More