P_RU_EXTNUMBYDEFAULT1

CDS View

Long Document Texts and Addition Info

P_RU_EXTNUMBYDEFAULT1 is a CDS View in S/4HANA. Long Document Texts and Addition Info. It contains 4 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_RU_ExtNumByDefault2 view from COMPOSITE Long Document Texts and Addition Info

Fields (4)

KeyField CDS FieldsUsed in Views
AccountingDocumentType CustAccountingDocumentType 1
CompanyCode CustCompanyCode 1
ExtDocNmbrAndDteAreFilled ExtDocNmbrAndDteAreFilled 1
Rank Rank 1
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'PRUEXTNUMBYDEF1'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_RU_ExtNumByDefault1
  as select from I_RU_ExtNumByDefault

{
  key CompanyCode,
  key AccountingDocumentType,
      ExtDocNmbrAndDteAreFilled,

      case
          when CompanyCode <> '' and AccountingDocumentType <> ''
               then 3
          when CompanyCode <> '' and AccountingDocumentType = ''
               then 2
          when CompanyCode = '' and AccountingDocumentType <> ''
               then 1
          else 0
       end as Rank
}