I_DocInfoRecdDocumentStatus

DDL: I_DOCINFORECDDOCUMENTSTATUS SQL: ICVDOCUMENSTATUS Type: view BASIC

Document Status

I_DocInfoRecdDocumentStatus is a Basic CDS View (Dimension) that provides data about "Document Status" in SAP S/4HANA. It reads from 2 data sources (tdws, tdwst) and exposes 7 fields with key fields DocumentType, InternalDocumentStatus, Language. It has 2 associations to related views.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
tdws status from
tdwst status_text left_outer

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_DocInfoRecdDocumentType _DocumentType $projection.DocumentType = _DocumentType.DocumentType
[1..1] I_Language _Language $projection.Language = _Language.Language

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ICVDOCUMENSTATUS view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Document Status view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
ObjectModel.representativeKey InternalDocumentStatus view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_DocumentInfoRecordDocStatus view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY DocumentType tdws dokar
KEY InternalDocumentStatus tdws dokst Internal Document Status
KEY Language tdwst cvlang
ExternalDocumentStatus tdwst stabk External Document Status
DocumentStatusName tdwst dostx Document Status Description
_Language _Language
_DocumentType _DocumentType 
@AbapCatalog.sqlViewName: 'ICVDOCUMENSTATUS'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Document Status'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions: true
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'InternalDocumentStatus'
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory : #S
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@VDM.lifecycle: {
  contract: {
    type: #PUBLIC_LOCAL_API
  },
  status: #DEPRECATED,
  successor: 'I_DocumentInfoRecordDocStatus'
}

define view I_DocInfoRecdDocumentStatus
  as select from    tdws  as status
    left outer join tdwst as status_text on status.dokst = status_text.dokst

  --Get Document Type Association
  association [1..1] to I_DocInfoRecdDocumentType as _DocumentType on $projection.DocumentType = _DocumentType.DocumentType

  association [1..1] to I_Language                as _Language     on $projection.Language = _Language.Language

{
      @ObjectModel.foreignKey.association: '_DocumentType'
  key status.dokar  as DocumentType,

      @ObjectModel.text.element: 'DocumentStatusName'
      @EndUserText.label:'Internal Document Status'
  key status.dokst  as InternalDocumentStatus,

      @Semantics.language: true
      @ObjectModel.foreignKey.association:'_Language'
  key status_text.cvlang  as Language,

      @EndUserText.label:'External Document Status'
      status_text.stabk as ExternalDocumentStatus,

      @Semantics.text: true
      @EndUserText.label:'Document Status Description'
      status_text.dostx as DocumentStatusName,
      
      //Associations

      _Language,
      _DocumentType
} 
where
  status_text.cvlang = $session.system_language
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TDWS",
"TDWST"
],
"ASSOCIATED":
[
"I_DOCINFORECDDOCUMENTTYPE",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More