I_PURCHASINGCATTRANSLATIONSTS
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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
}