P_XB_GeneralLedgerFieldsGroup

DDL: P_XB_GENERALLEDGERFIELDSGROUP Type: view_entity BASIC Package: GLO_FIN_IS_CS_GEN

General Ledger Fields Group

P_XB_GeneralLedgerFieldsGroup is a Basic CDS View that provides data about "General Ledger Fields Group" in SAP S/4HANA. It reads from 2 data sources (dd03l, dd04t) and exposes 4 fields with key fields Language, XB_CostStmntHierCndnNdeFldName. It has 1 association to related views. Part of development package GLO_FIN_IS_CS_GEN.

Data Sources (2)

SourceAliasJoin Type
dd03l dd03l from
dd04t dd04t inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (10)

NameValueLevelField
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.dataCategory #TEXT view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Language dd04t ddlanguage
KEY XB_CostStmntHierCndnNdeFldName dd03l fieldname
XB_CostStmntHierCndnNdeFldText dd04t ddtext
_Language _Language
@VDM.viewType: #BASIC
@VDM.private:true

@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #C,
  sizeCategory: #M
}
@ObjectModel.dataCategory:#TEXT
@ObjectModel.modelingPattern: #LANGUAGE_DEPENDENT_TEXT
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE, #LANGUAGE_DEPENDENT_TEXT ]

define view entity P_XB_GeneralLedgerFieldsGroup
  as select from dd03l
    inner join   dd04t on dd03l.rollname = dd04t.rollname
  association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
{
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key dd04t.ddlanguage as Language,
  key dd03l.fieldname  as XB_CostStmntHierCndnNdeFldName,
      @Semantics.text:true
      dd04t.ddtext     as XB_CostStmntHierCndnNdeFldText,
      _Language
}
where
       dd03l.tabname   = 'ACDOCA'
  and  dd03l.as4local  = 'A'
  and  dd03l.as4vers   = '0000'
  and(
       dd03l.fieldname = 'RACCT'
    or dd03l.fieldname = 'RFAREA'
    or dd03l.fieldname = 'KTOSL'
    or dd03l.fieldname = 'ACCASTY'
  )