P_SPECUSAGE

CDS View

P_SPECUSAGE is a CDS View in S/4HANA. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SpecIdentifierUsage view from BASIC Specification Identifier Usage
I_SpecValAssgmtUsage view from BASIC Specification Value Assignment Usage 
@AbapCatalog.sqlViewName: 'PSPECUSAGE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MASTER

@VDM.lifecycle.contract.type: #NONE
@VDM.viewType: #BASIC
@VDM.private: true
define view P_SpecUsage
  as select from estdu
{ 
  key recn        as SpecificationUsageInternalID,
  key actn        as SpecificationUsageChangeState,

      valfr       as SpecificationUsgeValdtyStrtDte,
      valto       as SpecificationUsgeValdtyEndDte,

      recnroot    as SpecificationInternalID,

      namemst     as MasterTable,
      recnmst     as MasterTableElementInternalID,

      vaclid      as SpecificationRating,
      rvlid       as SpecificationValidityArea,

      exclflg     as SpecificationUsageIsExcluded,
      actvflg     as SpecificationUsageIsActive,
      esntflg     as SpecificationUsageIsRelevant,
      delflg      as SpecificationUsageIsDeleted
}   
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ESTDU"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More