P_CnsldtnTskDocTypeDtaColl

DDL: P_CNSLDTNTSKDOCTYPEDTACOLL Type: view BASIC

P_CnsldtnTskDocTypeDtaColl is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (I_CnsldtnVersion, tf572) and exposes 4 fields with key fields ConsolidationTask, ConsolidationVersion, CnsldtnDocTypeSequenceValue.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_CnsldtnVersion _Version inner
tf572 tf572 from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCSTSKDOCDCASGN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view
VDM.private true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationTask tf572 cacti
KEY ConsolidationVersion I_CnsldtnVersion ConsolidationVersion
KEY CnsldtnDocTypeSequenceValue tf572 seqnr
ConsolidationDocumentType tf572 docty 
@AbapCatalog:{
  sqlViewName: 'PCSTSKDOCDCASGN',
  compiler.compareFilter: true
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel:{
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #B,
    sizeCategory: #S}
}
@VDM.viewType: #BASIC
@VDM.private: true
define view P_CnsldtnTskDocTypeDtaColl as 
  select from tf572 as tf572
    inner join I_CnsldtnVersion as _Version on tf572.inpvs = _Version.ConsolidationDataEntryVersion
{
  key tf572.cacti                     as ConsolidationTask,
  
  key _Version.ConsolidationVersion   as ConsolidationVersion,
  
  key case
        when tf572.ryear = '0000' then cast( '0000' as gjahr preserving type )
        else cast( lpad( cast( 9999 - cast( tf572.ryear as abap.int4 ) as abap.char( 11 ) ), 4, '0') as gjahr )
      end                             
                                      as CnsldtnDocTypeValdFrmFsclYear,
                                      
  key case
        when tf572.perid = '000' then cast( '000' as poper preserving type )
        else cast( lpad( cast( 999 - cast( tf572.perid as abap.int2 ) as abap.char( 11 ) ), 3, '0') as poper )
      end 
                                      as CnsldtnDocTypeValdFrmFsclPerd,
                                      
  key tf572.seqnr                     as CnsldtnDocTypeSequenceValue,
  
      tf572.docty                     as ConsolidationDocumentType
}
  where tf572.dimen = 'Y1'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNSLDTNVERSION",
"TF572"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More