P_Swdocver

DDL: P_SWDOCVER SQL: PSWVERSIONS Type: view BASIC

P_Swdocver is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (drat, draw, tdwst) and exposes 8 fields with key fields DocumentType, DocNumber, DocumentVersion, DocumentPart.

3 data source(s) 8 fields

Data Sources (3)

SourceAliasJoin Type
drat drat left_outer
draw draw from
tdwst tdwst left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PSWVERSIONS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY DocumentType draw dokar
KEY DocNumber draw doknr
KEY DocumentVersion draw dokvr
KEY DocumentPart draw doktl
InternalDocumentStatus draw dokst
EmbeddedSwExternalVersion draw res1
DocumentStatusName tdwst dostx
DocumentDescription drat dktxt 
@AbapCatalog.sqlViewName: 'PSWVERSIONS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@VDM.private: true

define view P_Swdocver
  as select from    draw
    left outer join drat  on  draw.dokar = drat.dokar
                          and draw.doknr = drat.doknr
                          and draw.dokvr = drat.dokvr
                          and draw.doktl = drat.doktl
                          and drat.langu = $session.system_language
    left outer join tdwst on  tdwst.dokst  = draw.dokst
                          and tdwst.cvlang = $session.system_language
{
  key draw.dokar  as DocumentType,
  key draw.doknr  as DocNumber,
  key draw.dokvr  as DocumentVersion,
  key draw.doktl  as DocumentPart,
      draw.dokst  as InternalDocumentStatus,
      draw.res1   as EmbeddedSwExternalVersion,
      tdwst.dostx as DocumentStatusName,
      drat.dktxt  as DocumentDescription
} 
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"DRAT",
"DRAW",
"TDWST"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More