aps_com_cs_ca

DDL: APS_COM_CS_CA SQL: APS_COM_CS_C Type: view Package: SR_APS_COM_CSCN

Arrangements where scenario is used

aps_com_cs_ca is a CDS View that provides data about "Arrangements where scenario is used" in SAP S/4HANA. It reads from 1 data source (C_APS_COM_CA) and exposes 5 fields with key fields CommunicationScenario, CommuncationArrangement, dbKey. It is exposed through 1 OData service (APS_COM_MCS_D_SD). Part of development package SR_APS_COM_CSCN.

1 data source(s) Exposed by 1 service(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
C_APS_COM_CA commArrangement from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName APS_COM_CS_C view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Arrangements where scenario is used view

OData Services (1)

ServiceBindingVersionContractRelease
APS_COM_MCS_D_SD APS_COM_MCS_D_V2 V2 C1 NOT_RELEASED

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CommunicationScenario C_APS_COM_CA CommunicationScenario
KEY CommuncationArrangement C_APS_COM_CA CommArrgmtName
KEY dbKey C_APS_COM_CA db_key
ActiveCommArrgmtUUID C_APS_COM_CA db_key
CommunicationSystem 
@AbapCatalog.sqlViewName: 'APS_COM_CS_C'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Arrangements where scenario is used'
/*+[hideWarning] { "IDS" : [ "DOUBLE_JOIN" ]  } */
define view aps_com_cs_ca
  as select from C_APS_COM_CA as commArrangement
{

  key commArrangement.CommunicationScenario             as CommunicationScenario,
  key commArrangement.CommArrgmtName                    as CommuncationArrangement,
  key commArrangement.db_key                            as dbKey,
      //      commArrangement.db_key                            as commarrgmtdraftuuid,

      commArrangement.db_key                            as ActiveCommArrgmtUUID,
      commArrangement._CommunicationSystem.CommSystName as CommunicationSystem
}
group by
  commArrangement.CommArrgmtName,
  commArrangement.db_key,
  commArrangement.db_key,
  commArrangement.CommunicationScenario,
  commArrangement.db_key,
  commArrangement._CommunicationSystem.CommSystName;


//define view aps_com_cs_ca as select from C_APS_COM_CA as commArrangement {

//

// key commArrangement.CommunicationScenario as CommunicationScenario,

// key commArrangement.CommArrgmtName as CommuncationArrangement,

// key commArrangement.db_key as dbKey,

// commArrangement.CommSyst as CommunicationSystem,

// commArrangement.CommArrgmtStatus as ArrangementStatus

//}


// DUMMY

//define view aps_com_cs_ca as select from aps_com_w_cscn{

//key cast ( 'blafasel' as abap.char( 30 )) as CommunicationScenario,

//key cast ( 'blafasel' as abap.char( 30 )) as CommunicationArrangement,

//key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as dbKey,

// cast ( 'blafasel' as abap.char( 30 )) as CommunicationSystem,

//     cast ( '01' as abap.char( 2 )) as ArrangementStatus

//}

Learn More