P_ProdTextSilentDataMigration

DDL: P_PRODTEXTSILENTDATAMIGRATION Type: view_entity BASIC Package: VDM_MD_PRODUCT

Silent Data Migration of Product texts

P_ProdTextSilentDataMigration is a Basic CDS View that provides data about "Silent Data Migration of Product texts" in SAP S/4HANA. It reads from 1 data source (I_TextObject) and exposes 4 fields with key fields TextObjectKey, Language. Part of development package VDM_MD_PRODUCT.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_TextObject Text from

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
VDM.private true view
ObjectModel.usageType.serviceQuality #B view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY TextObjectKey I_TextObject TextObjectKey
KEY Language I_TextObject Language
TextObjectCategory I_TextObject TextObjectCategory
TextObjectType I_TextObject TextObjectType 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC
@VDM.private: true
@ObjectModel:{
usageType.serviceQuality: #B

}
define view entity P_ProdTextSilentDataMigration
  as select from           I_TextObject     as Text
    left outer to one join cmd_prd_text     as ProdText         on  Text.TextObjectKey  = ProdText.text_name
                                                                and Text.Language       = ProdText.language
                                                                and Text.TextObjectType = ProdText.text_id
    left outer to one join cmd_prdplant_txt as ProdPlantMRPText on  Text.TextObjectKey  = ProdPlantMRPText.text_name
                                                                and Text.Language       = ProdPlantMRPText.language
                                                                and Text.TextObjectType = ProdPlantMRPText.text_id
    left outer to one join cmd_prdsales_txt as ProdSalesText    on  Text.TextObjectKey  = ProdSalesText.text_name
                                                                and Text.Language       = ProdSalesText.language
                                                                and Text.TextObjectType = ProdSalesText.text_id 
{   
  key Text.TextObjectKey                                                                     as TextObjectKey,
  key Text.Language                                                                          as Language,
      coalesce( ProdText.sdm_ver,
      coalesce ( ProdPlantMRPText.sdm_ver,
      coalesce ( ProdSalesText.sdm_ver, cast('  ' as cmd_prd_sdm_vers preserving type) ) ) ) as ProdTxtSilentDataMigrtnStatus,
      Text.TextObjectCategory                                                                as TextObjectCategory,
      Text.TextObjectType                                                                    as TextObjectType
}
where
  (
         Text.TextObjectCategory = 'MATERIAL'
    and(
         Text.TextObjectType     = 'BEST'
      or Text.TextObjectType     = 'GRUN'
      or Text.TextObjectType     = 'IVER'
      or Text.TextObjectType     = 'PRUE'
    )
  )
  or(
         Text.TextObjectCategory = 'MDTXT'
    and  Text.TextObjectType     = 'LTXT'
  )
  or(
         Text.TextObjectCategory = 'MVKE'
    and  Text.TextObjectType     = '0001'
  )

Learn More