I_ARunRequirementDocumentType

DDL: I_ARUNREQUIREMENTDOCUMENTTYPE SQL: IARUNREQDOCTYPE Type: view BASIC

Requirement document type

I_ARunRequirementDocumentType is a Basic CDS View (Dimension) that provides data about "Requirement document type" in SAP S/4HANA. It reads from 2 data sources (I_PurchasingDocumentType, I_SalesDocumentType) and exposes 4 fields with key field SalesDocumentType. It has 2 associations to related views.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_PurchasingDocumentType _PurcDocumentType union
I_SalesDocumentType _SalesDocumentType from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_SalesDocumentTypeText _Text $projection.SalesDocumentType = _Text.SalesDocumentType
[0..1] I_PurchasingDocumentTypeText _Textpurch $projection.SalesDocumentType = _Textpurch.PurchasingDocumentType and $projection.SDDocumentCategory = _Textpurch.PurchasingDocumentCategory

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey SalesDocumentType view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Requirement document type view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName IARUNREQDOCTYPE view
Metadata.allowExtensions true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY SalesDocumentType SalesDocumentType
SDDocumentCategory SDDocumentCategory
SDDocumentCategory PurchasingDocumentCategory
SalesDocumentTypeName _Textpurch PurchasingDocumentTypeName 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'SalesDocumentType'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M
@EndUserText.label: 'Requirement document type'
@Analytics: { dataCategory: #DIMENSION}
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck:#CHECK
@AbapCatalog.sqlViewName: 'IARUNREQDOCTYPE'
@Metadata.allowExtensions:true

define view I_ARunRequirementDocumentType 
as select from I_SalesDocumentType as _SalesDocumentType
   association [0..1] to I_SalesDocumentTypeText as _Text 
                      on $projection.SalesDocumentType = _Text.SalesDocumentType
   
   {
   key SalesDocumentType,
     SDDocumentCategory,
       _Text.SalesDocumentTypeName as SalesDocumentTypeName
 //      _Text

  
   } where _Text.Language = $session.system_language and
     ( SDDocumentCategory = 'C' or
      SDDocumentCategory = 'I' or
      SDDocumentCategory = 'G' )
      
union 
     select from  I_PurchasingDocumentType as _PurcDocumentType
     association [0..1] to I_PurchasingDocumentTypeText    as _Textpurch
                       on $projection.SalesDocumentType = _Textpurch.PurchasingDocumentType 
                       and $projection.SDDocumentCategory = _Textpurch.PurchasingDocumentCategory 
      { 
       key PurchasingDocumentType    as SalesDocumentType,
         PurchasingDocumentCategory as SDDocumentCategory,
         _Textpurch.PurchasingDocumentTypeName as SalesDocumentTypeName
         
      }
      where _Textpurch.Language = $session.system_language and
             PurchasingDocumentCategory = 'F'
            
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASINGDOCUMENTTYPE",
"I_PURCHASINGDOCUMENTTYPETEXT",
"I_SALESDOCUMENTTYPE",
"I_SALESDOCUMENTTYPETEXT"
],
"ASSOCIATED":
[
"I_SALESDOCUMENTTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More