I_PURCHASINGCATTRANSLATIONSTS

CDS View

Purchasing Category Translation Status

I_PURCHASINGCATTRANSLATIONSTS is a CDS View in S/4HANA. Purchasing Category Translation Status. It contains 3 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_PurgCatTranslationStatus view from BASIC Translation Status
C_PurchasingCategoryTranST view inner CONSUMPTION Translate Purchasing Categories
I_PurgCatTranslationStsAPI01 view from BASIC Translation Status of Purg Category

Fields (3)

KeyField CDS FieldsUsed in Views
KEY PurgCatTranslationTgtLang PurgCatTranslationTgtLang 2
KEY PurgCatTranslationTgtLangSts PurgCatTranslationTgtLangSts 1
_PurgCatTranslationTgtLang _PurgCatTranslationTgtLang 1
@EndUserText.label: 'Purchasing Category Translation Status'
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IPURGCATTRANSST'
define view I_PurchasingCatTranslationSts as select from /srmsmc/d_puctrl 
  association [1..1] to I_PurchasingCategory as _PurchasingCategory on $projection.PurgCatUUID = _PurchasingCategory.PurgCatUUID
//  association [0..1] to I_SLCTranslationStatus as _SLCTranslationStatus on $projection.PurgCatTranslationTgtLangSts = _SLCTranslationStatus.SLCTranslationStatus

  association [0..1] to I_SLCTranslationStatus as _PurgCatTranslationTgtLangSts on $projection.PurgCatTranslationTgtLangSts = _PurgCatTranslationTgtLangSts.SLCTranslationStatus
//  association [0..1] to I_Language as _Language on $projection.PurgCatTranslationTgtLang = _Language.Language

  association [0..1] to I_Language as _PurgCatTranslationTgtLang on $projection.PurgCatTranslationTgtLang = _PurgCatTranslationTgtLang.Language   
   
{
    
    //key

    key cast (db_key as /srmsmc/puc_translation_uuid ) as PurgCatTranslationUUID,

    cast (parent_key as /srmsmc/puc_uuid)   as PurgCatUUID,
    
    
    //Admin

    @Semantics.language: true
    @ObjectModel.foreignKey.association: '_PurgCatTranslationTgtLang' //Inserted by VDM CDS Suite Plugin

    cast(language_code as /srmsmc/target_language) as PurgCatTranslationTgtLang,
    //obsolete

//    cast(language_code as /srmsmc/target_language ) as Language,


    //status

    @ObjectModel.foreignKey.association: '_PurgCatTranslationTgtLangSts' //Inserted by VDM CDS Suite Plugin

    cast(trans_status as /srmsmc/target_lang_transl_sts) as PurgCatTranslationTgtLangSts,
    
    //obsolete

    cast(trans_status as /srmsmc/target_lang_transl_sts) as SLCTranslationStatus,

    //Associations

    @ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]   
    _PurchasingCategory,
    _PurgCatTranslationTgtLangSts,
    _PurgCatTranslationTgtLang
}