I_CADOCUMENTTYPE

CDS View

Document Type

I_CADOCUMENTTYPE is a CDS View in S/4HANA. Document Type. It contains 1 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 1 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_CADocumentTypeValueHelp view from CONSUMPTION Belegart Wertehilfe
I_CADocumentTypeVH view from COMPOSITE Document Type

Fields (1)

KeyField CDS FieldsUsed in Views
KEY CADocumentType CADocumentType 1 
@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'

Learn More