R_FXDASTCOCODETP

CDS View

Fixed Asset Company Code

R_FXDASTCOCODETP is a CDS View in S/4HANA. Fixed Asset Company Code. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_FxdAstCoCodeTP view_entity projection CONSUMPTION Fixed Asset Company Code 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Fixed Asset Company Code'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@AccessControl.privilegedAssociations: [ '_ChangeDocuments' ]
@Metadata.ignorePropagatedAnnotations: true
//@ObjectModel.dataCategory: #VALUE_HELP

@ObjectModel: {
  usageType: {
        serviceQuality: #C,
        sizeCategory: #L,
        dataClass: #TRANSACTIONAL
    }
 }
@ObjectModel.sapObjectNodeType.name: 'FixedAsset'
@ObjectModel.representativeKey: 'CompanyCode'
define root view entity R_FxdAstCoCodeTP as select from I_FixedAssetCompanyCode
composition[1..*] of R_FxdAstCoCodeLgcyDtaTransfTP   as _LegacyDataTransfer
composition[1..*] of R_FxdAstCoCodeLdgrTP            as _Ledger
//association [0..1] to I_CompanyCode                  as _CompanyCode                on  $projection.CompanyCode = _CompanyCode.CompanyCode

//association [0..1] to I_ChartOfAccountsText          as _ChartOfAccountsText on   $projection.ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts

//                                                                         and  _ChartOfAccountsText.Language = $session.system_language

association[0..1] to I_FixedAssetCompanyCodeStsTxt   as _CompanyCodeStatusText on $projection.FixedAssetCompanyCodeStatus = _CompanyCodeStatusText.FixedAssetCompanyCodeStatus
                                                                     and _CompanyCodeStatusText.Language = $session.system_language
association[0..1] to I_FixedAssetHighestOpenFY       as _HighestOpenFY on $projection.CompanyCode = _HighestOpenFY.CompanyCode
association[0..1] to I_FixedAssetLowestClosedFY      as _LowestClosedFY on $projection.CompanyCode = _LowestClosedFY.CompanyCode
association [0..*] to I_ChangeDocument_2             as _ChangeDocuments   on  _ChangeDocuments.ChangeDocObjectClass = 'FAA_COMP_CODE'
                                                               and _ChangeDocuments.ChangeDocObject      = $projection.CompanyCode
{
  key CompanyCode,
  FixedAssetCompanyCodeStatus,
  IsLocked,
  LocalLastChangeDateTime,
  LastChangeDateTime,

  //Associations

  _LegacyDataTransfer,
  _Ledger,
  _CompanyCodeStatusText,
  _CompanyCode,
  _HighestOpenFY,
  _LowestClosedFY,
  _ChangeDocuments
}

Learn More