I_ARUNREQUIREMENTDOCUMENTTYPE

CDS View

Requirement document type

I_ARUNREQUIREMENTDOCUMENTTYPE is a CDS View in S/4HANA. Requirement 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
P_EvtBsdRevnRecgnSalesOrdRslt view inner CONSUMPTION Results Rev. Rec. Issues - Sales Orders
P_EvtBsdRevnRecSalesOrderIss view inner CONSUMPTION Event based rev. rec. sales order issue

Fields (1)

KeyField CDS FieldsUsed in Views
SalesDocumentTypeName SalesDocumentTypeName 2 
@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