P_AR_MappingOfclDocTypeDetn

DDL: P_AR_MAPPINGOFCLDOCTYPEDETN Type: view_entity COMPOSITE

P_AR_MappingOfclDocTypeDetn is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_AR_OfficialDocumentTypeDetn, I_CompanyCode, I_CountrySpecificDocumentType) and exposes 5 fields with key fields CompanyCode, AccountingDocumentType, AR_OfficialDocumentClass, AR_PrintCharacter.

3 data source(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
I_AR_OfficialDocumentTypeDetn AR_OfficialDocumentTypeDetn inner
I_CompanyCode CompanyCode from
I_CountrySpecificDocumentType CountrySpecificDocumentType inner

Parameters (1)

NameTypeDefault
P_AR_Report progname

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #M view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCode CompanyCode
KEY AccountingDocumentType
KEY AR_OfficialDocumentClass
KEY AR_PrintCharacter
AR_OfficialDocumentType 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  dataClass: #MIXED,
  serviceQuality: #P,
  sizeCategory: #M
}
@VDM:{
  private: true,
  viewType: #COMPOSITE
}
define view entity P_AR_MappingOfclDocTypeDetn
  with parameters
    @EndUserText.label: 'Statutory Report Name'
    P_AR_Report : progname

  as select from I_CompanyCode                 as CompanyCode

    inner join   I_CountrySpecificDocumentType as CountrySpecificDocumentType on CountrySpecificDocumentType.Country = CompanyCode.Country

    inner join   I_AR_OfficialDocumentTypeDetn as AR_OfficialDocumentTypeDetn on  AR_OfficialDocumentTypeDetn.AR_OfficialDocumentClass = CountrySpecificDocumentType.AR_OfficialDocumentClass
                                                                              and AR_OfficialDocumentTypeDetn.Country                  = CompanyCode.Country
                                                                              and AR_OfficialDocumentTypeDetn.AR_Report                = $parameters.P_AR_Report
{
  key CompanyCode.CompanyCode,
  key cast( CountrySpecificDocumentType.AccountingDocumentType as fis_blart preserving type )   as AccountingDocumentType,
  key cast( AR_OfficialDocumentTypeDetn.AR_OfficialDocumentClass as doccls preserving type )    as AR_OfficialDocumentClass,
  key cast( AR_OfficialDocumentTypeDetn.AR_PrintCharacter as j_1apchar preserving type )        as AR_PrintCharacter,
      cast( AR_OfficialDocumentTypeDetn.AR_OfficialDocumentType as j_1aoftp_d preserving type ) as AR_OfficialDocumentType
}
where
  CompanyCode.Country = 'AR'

Learn More