I_CADocumentType

DDL: I_CADOCUMENTTYPE Type: view_entity BASIC

Document Type

I_CADocumentType is a Basic CDS View (Dimension) that provides data about "Document Type" in SAP S/4HANA. It reads from 2 data sources (I_CAApplicationArea, tfk003) and exposes 7 fields with key fields CADocumentType, CAApplicationArea. It has 2 associations to related views.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_CAApplicationArea ApplArea inner
tfk003 tfk003 from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CAApplicationArea _ApplArea $projection.CAApplicationArea = _ApplArea.CAApplicationArea
[0..*] I_CADocumentTypeText _Text $projection.CADocumentType = _Text.CADocumentType and $projection.CAApplicationArea = _Text.CAApplicationArea

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
EndUserText.label Document Type view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey CADocumentType view
ObjectModel.sapObjectNodeType.name ContrAcctgDocumentType view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #BASIC view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CADocumentType tfk003 blart
KEY CAApplicationArea tfk003 applk
CACrossCompCodePostgIsAllowed tfk003 xgsub
CAManualPostingIsForbidden tfk003 xintf
CANegativePostingCode tfk003 negbl
_ApplArea _ApplArea
_Text _Text 
@AccessControl.authorizationCheck: #NOT_REQUIRED

@Analytics : { dataCategory: #DIMENSION, 
               dataExtraction.enabled : true}

@EndUserText.label: 'Document Type'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel: { modelingPattern: #ANALYTICAL_DIMENSION,
                representativeKey: 'CADocumentType',
                sapObjectNodeType.name: 'ContrAcctgDocumentType',
                supportedCapabilities: [ #ANALYTICAL_DIMENSION, 
                                         #CDS_MODELING_ASSOCIATION_TARGET,
                                         #CDS_MODELING_DATA_SOURCE, 
                                         #EXTRACTION_DATA_SOURCE,
                                         #SQL_DATA_SOURCE ],
                usageType: { serviceQuality: #A,
                             sizeCategory: #S,
                             dataClass: #CUSTOMIZING } }

@VDM.viewType: #BASIC

define view entity I_CADocumentType
  as select from tfk003
    inner join   I_CAApplicationArea as ApplArea on tfk003.applk = ApplArea.CAApplicationArea
  
  association [1..1] to I_CAApplicationArea  as _ApplArea on  $projection.CAApplicationArea = _ApplArea.CAApplicationArea
  association [0..*] to I_CADocumentTypeText as _Text     on  $projection.CADocumentType    = _Text.CADocumentType
                                                          and $projection.CAApplicationArea = _Text.CAApplicationArea
{
      @ObjectModel.text.association: '_Text'
  key tfk003.blart as CADocumentType,
      @ObjectModel.foreignKey.association: '_ApplArea'
  key tfk003.applk as CAApplicationArea,

      tfk003.xgsub as CACrossCompCodePostgIsAllowed,
      tfk003.xintf as CAManualPostingIsForbidden,
      tfk003.negbl as CANegativePostingCode,

      /* only technical fields:
            tfk003.numkr,
            tfk003.bllfz,
            tfk003.arclfz,
      */

      _ApplArea,
      _Text
}
where
  ApplArea.CAApplicationAreaIsActive = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CAAPPLICATIONAREA",
"TFK003"
],
"ASSOCIATED":
[
"I_CAAPPLICATIONAREA",
"I_CADOCUMENTTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More