Which tables does C_ChgRecdRefObjVisibility use?

C_ChgRecdRefObjVisibility reads from 1 data source(s): I_ChgRecdRefObjVisibility.

How many fields does C_ChgRecdRefObjVisibility have?

C_ChgRecdRefObjVisibility has 1 fields. Key fields: ChangeRecordType.

C_ChgRecdRefObjVisibility

DDL: C_CHGRECDREFOBJVISIBILITY SQL: CCRTRFOBJVIB Type: view CONSUMPTION

Change Record Reference Object Visible

C_ChgRecdRefObjVisibility is a Consumption CDS View that provides data about "Change Record Reference Object Visible" in SAP S/4HANA. It reads from 1 data source (I_ChgRecdRefObjVisibility) and exposes 1 field with key field ChangeRecordType.

Data Sources (1)

Source	Alias	Join Type
I_ChgRecdRefObjVisibility	ObjVisibility	from

Annotations (9)

Name	Value	Level
AbapCatalog.sqlViewName	CCRTRFOBJVIB	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
EndUserText.label	Change Record Reference Object Visible	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.dataClass	#CUSTOMIZING	view
ObjectModel.usageType.sizeCategory	#S	view

Fields (1)

Key	Field	Source Table	Source Field	Description
KEY	ChangeRecordType	I_ChgRecdRefObjVisibility	ChangeRecordType

@AbapCatalog.sqlViewName: 'CCRTRFOBJVIB'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Change Record Reference Object Visible'
@ClientHandling.algorithm: #SESSION_VARIABLE
//@AbapCatalog.preserveKey:true

@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType: {serviceQuality: #B,
                         dataClass: #CUSTOMIZING,
                         sizeCategory: #S}                      
define view C_ChgRecdRefObjVisibility
as select from            I_ChgRecdRefObjVisibility as ObjVisibility 

{
  key ObjVisibility.ChangeRecordType,
      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'DOC'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )    as ChgRecdRefObjDocVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'MAT'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdRefObjMatlVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'BOM'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdRefObjBOMVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'BIT'
        then cast ( 0  as int4 ) else cast( 1 as int4 )   end )       as ChgRecdRefObjBOMItemVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'EBM'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdRefObjEngBOMVisible,


      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'MBM'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdRefObjMfgBOMVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'PLS'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdRefObjPlngScpVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'ROU'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdRefObjRoutingVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'OSR'
        then cast ( 0  as int4 ) else cast( 1 as int4 )   end )       as ChgRecdOrdSpcfcRtgRefIsVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'PRN'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdRefObjProdnOrderVisible,


      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'PO'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdRefObjPurOrderVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'PSV'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdRefProdStrucVarVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'SPC'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )        as ChgRecdRefObjSpecVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'SNP'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )       as ChgRecdRefObjEngSnpshtVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'MRC'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdRefObjMstrRcpVisible,


      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'INP'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdRefObjInspPlanVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'RCP'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdRefObjRecipeVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'LBL'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdRefObjLabelVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'PRG'
        then cast ( 0  as int4 ) else cast( 1 as int4 )   end )       as ChgRecdRefObjProdnRtgVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'PLR'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdRefObjPlngRtgVisible,


      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'TER'
            then cast ( 0  as int4 ) else cast( 1 as int4 )   end )    as ChgRecdRefObjTmplRtgVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'OBM'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdRefObjOrderBOMVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'CLS'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdRefObjClassVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'CHR'
        then cast ( 0  as int4 ) else cast( 1 as int4 )   end )       as ChgRecdRefObjCharcVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'MTL'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdObjMaintTskListVisible,


      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'SBM'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdObjStdBOMVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'ETL'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdObjEquipTskListVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'WBM'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdObjWBSElmntBOMVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'EQB'
        then cast ( 0  as int4 ) else cast( 1 as int4 )   end )       as ChgRecdObjEquipBOMVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'FBM'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdObjFuncLocBOMVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'VBM'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdObjVarBOMVisible,


      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'RRT'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdRefRateRtgVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'RRO'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdRateRtgVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'CPP'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdRefCutPlngPrflVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'ROS'
        then cast ( 0  as int4 ) else cast( 1 as int4 )   end )       as ChgRecdRefOpSetVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'FTL'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdFuncLocTskListVisible,

      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'MSP'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdRefObjMfgSnpshtVisible,
      
      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'EOB'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdRefObjETOVersBOMVisible,
      
      min ( case when   ObjVisibility.ChangeRecordReferenceType = 'DEF'
      then cast ( 0  as int4 ) else cast( 1 as int4 )   end )         as ChgRecdRefObjDefectVisible            

}
where
  ObjVisibility.ChangeRecordType is not null
group by
  ObjVisibility.ChangeRecordType



//  as select from           I_ChgRecdTypeRefObj       as ChgRecdTypeRefObj

//    left outer to one join I_ChgRecdRefObjVisibility as ObjVisibility on  ObjVisibility.ChangeRecordType          = ChgRecdTypeRefObj.ChangeRecordType

//                                                                      and ObjVisibility.ChangeRecordReferenceType = ChgRecdTypeRefObj.ChangeRecordReferenceType

//{

//  key

//       case when ObjVisibility.ChangeRecordType is not null then ObjVisibility.ChangeRecordType

//                 else ChgRecdTypeRefObj.ChangeRecordType

//                 end                as ChangeRecordType,

//

//  key  case when ObjVisibility.ChangeRecordType is not null then ObjVisibility.ChangeRecordReferenceType

//        else ChgRecdTypeRefObj.ChangeRecordReferenceType

//        end                         as ChangeRecordReferenceType,

//

//       //field is used in annotation, 0 - visible 1 - hidden

//       case

//       when ObjVisibility.ChangeRecordType is not null then cast ( 0 as int4 )

//       else cast ( 1 as int4 )  end as ChgRecdRefObjVisible

//

//}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHGRECDREFOBJVISIBILITY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

C_ChgRecdRefObjVisibility view

I_ChgRecdRefObjVisibility view