P_DFS_MeasureAreaBasic

DDL: P_DFS_MEASUREAREABASIC SQL: PORGMAREABA Type: view BASIC

P_DFS_MeasureAreaBasic is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (I_CaseAttribute) and exposes 23 fields with key field DfsMeasureAreaUUID.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_CaseAttribute _case from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PORGMAREABA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY DfsMeasureAreaUUID CaseUniqueID
CaseType CaseType
CaseID CaseID
CaseExternalReference CaseExternalReference
CaseCreatedBy CaseCreatedBy
CaseLastChangedBy CaseLastChangedBy
CaseClosedBy CaseClosedBy
CaseProcessor CaseProcessor
DfsOrglMeasureResponsible CaseResponsible
DfsMeasureAreaDescription CaseTitle
CaseAuthorizationLevel CaseAuthorizationLevel
CaseSystemStatus CaseSystemStatus
CaseStatusObjectNumber CaseStatusObjectNumber
CaseSystemStatusName CaseSystemStatusName
CaseUserStatusName CaseUserStatusName
CreationDateTime
LastChangeDateTime
CloseDateTime
CaseStatus CaseStatus
CaseStatusName
_CaseTypes _CaseTypes
_CaseSystemStatus _CaseSystemStatus
_CaseEntity _CaseEntity 
@AbapCatalog.sqlViewName: 'PORGMAREABA'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.private: true
@VDM.viewType: #BASIC
define view P_DFS_MeasureAreaBasic
  as select from I_CaseAttribute          as _case
{
  key CaseUniqueID as DfsMeasureAreaUUID,
      CaseType,
      CaseID,
      CaseExternalReference,
      CaseCreatedBy,
      CaseLastChangedBy,
      CaseClosedBy,
      CaseProcessor,
      CaseResponsible as DfsOrglMeasureResponsible,
      CaseTitle as DfsMeasureAreaDescription,
      CaseAuthorizationLevel,
      CaseSystemStatus,
      CaseStatusObjectNumber,
      CaseSystemStatusName,
      CaseUserStatusName,

      cast( CaseCreatedOn as tzntstmps preserving type )        as CreationDateTime,
      cast( CaseLastChangedOn as tzntstmps preserving type )    as LastChangeDateTime,
      cast( CaseClosedTime as tzntstmps preserving type )       as CloseDateTime,
      
      concat('/ISDFPS/MEASURE_AREA||RMS_ID|/ISDFPS/ORG_MEASURE||GUID|', _case.CaseUniqueID ) as DfsObjectConcatenatedID,

      CaseStatus,
      _case._Individual._Text[1:Language = $session.system_language].CaseStatusName,

      case
        when( CaseStatus = '10') then 2  //In Preperation    

        when( CaseStatus = '20') then 0  //In Process

        when( CaseStatus = '25') then 0  //resubmission        

        when( CaseStatus = '30') then 0   //Submitted

        when( CaseStatus = '40') then 0   //Approve

        when( CaseStatus = '50') then 3   //Active        

        when( CaseStatus = '60') then 1   //Withdrawn        

      end                                                                            as StatusCriticality,
      _CaseTypes,
      _CaseSystemStatus,
      _CaseEntity
}
where
         CaseType                              = 'DFP2'

  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CASEATTRIBUTE",
"I_CASEINDIVIDUALSTATUS",
"I_CASEINDIVIDUALSTATUSTEXT"
],
"ASSOCIATED":
[
"I_CASEENTITY",
"I_CASESYSTEMSTATUS",
"I_CASETYPES"
],
"BASE":
[
"I_CASEATTRIBUTE"
],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More