I_SlsDocChgDocumentFieldName

DDL: I_SLSDOCCHGDOCUMENTFIELDNAME SQL: ISDCHGDFNAME Type: view BASIC Package: VDM_SD_ANALYTICS

Field in Change Document Item for Sales Document

I_SlsDocChgDocumentFieldName is a Basic CDS View that provides data about "Field in Change Document Item for Sales Document" in SAP S/4HANA. It reads from 1 data source (dd03m) and exposes 9 fields with key fields DatabaseTable, DatabaseTableField, Language. It has 2 associations to related views. Part of development package VDM_SD_ANALYTICS.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
dd03m dd03m from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[0..1] I_SlsDocChgDocumentTableName _TableName _TableName.DatabaseTable = $projection.DatabaseTable and _TableName.Language = $projection.Language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISDCHGDFNAME view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Field in Change Document Item for Sales Document view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey DatabaseTableField view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY DatabaseTable tabname
KEY DatabaseTableField fieldname
KEY Language ddlanguage
ABAPLongFieldLabel scrtext_l
ABAPMediumFieldLabel scrtext_m
ABAPShortFieldLabel scrtext_s
DatabaseTableFieldText ddtext
DatabaseTableText _TableName DatabaseTableText
_Language _Language 
@AbapCatalog.sqlViewName: 'ISDCHGDFNAME'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Field in Change Document Item for Sales Document'

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey:'DatabaseTableField'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.dataCategory: #TEXT

@VDM.viewType: #BASIC

define view I_SlsDocChgDocumentFieldName
  as select from dd03m
  association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
  association [0..1] to I_SlsDocChgDocumentTableName  as _TableName on  _TableName.DatabaseTable   = $projection.DatabaseTable
                                                                    and _TableName.Language        =  $projection.Language
{
  key tabname    as DatabaseTable,
      
  key fieldname  as DatabaseTableField,
  
      @Semantics.language: true
  key ddlanguage as Language,
      
      @UI.hidden: true
      scrtext_l  as ABAPLongFieldLabel,
      
      @UI.hidden: true
      scrtext_m  as ABAPMediumFieldLabel,
      
      @UI.hidden: true
      scrtext_s  as ABAPShortFieldLabel,
      
      ddtext    as DatabaseTableFieldText,
      
      @UI.hidden: true
      _TableName.DatabaseTableText,
      
      _Language

} // only select fields that are marked write change document flag

  // only select tables and fields that revenue accounting writes to CDPOS

where
       logflag = 'X'
  and(
       tabname = 'KONVC' or tabname = 'VBEP'  or tabname = 'VBAP' 
    or tabname = 'VBPA'  or tabname = 'VBKD'  or tabname = 'VBAK'
    or tabname = 'FPLTC' or tabname = 'FPLT'  
    or tabname = 'FPLA'  or tabname = 'VBLB'  or tabname = 'VBPA2'
    or tabname = 'VEDA'  or tabname = 'VBPA3' or tabname = 'VBSN'
    or tabname = 'MSR_SD_CD'
    //or tabname = '/NFM/TDEFAULT' or tabname = '/NFM/TORDERPOS'

  )

Learn More