I_CHMLCMPLNCREQMKTCNTRY

CDS View

Market Countries/Regions of a Compliance Request

I_CHMLCMPLNCREQMKTCNTRY is a CDS View in S/4HANA. Market Countries/Regions of a Compliance Request. It contains 3 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 3 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_ChmlCmplncReqMktCntry view from CONSUMPTION Market Overview of a Chemical Compliance Request

Fields (3)

KeyField CDS FieldsUsed in Views
KEY ChmlCmplncBusinessProcess ChmlCmplncBusinessProcess 1
KEY ChmlCmplncRequestUUID ChmlCmplncRequestUUID 1
_Country _Country 1 
@EndUserText.label: 'Market Countries/Regions of a Compliance Request'
@AbapCatalog:
{
 sqlViewName: 'ICRQMREQCTRY',
 compiler.compareFilter: true
}

@AccessControl:
{
  authorizationCheck: #MANDATORY
}
--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API

@ObjectModel:
{
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #L,
    serviceQuality: #C
  }
}

/*-----------------------------------------------------------------------------------
  For each business process a distinct list of all involved market countries for a
  chemical compliance request is retrieved.
--------------------------------------------------------------------------------------*/

define view I_ChmlCmplncReqMktCntry
  as select from P_ChmlCmplncReqMktCntrySell _ChmlCmplncReqMktCntrySell
{
  key          _ChmlCmplncReqMktCntrySell.ChmlCmplncRequestUUID,
  key          _ChmlCmplncReqMktCntrySell.Country,
  key          _ChmlCmplncReqMktCntrySell.ChmlCmplncBusinessProcess,

               _Country,
               _ChmlCmplncReq
}
union all select from P_ChmlCmplncReqMktCntryProduce as _ChmlCmplncReqMktCntryProduce
{
  key         _ChmlCmplncReqMktCntryProduce.ChmlCmplncRequestUUID,
  key         _ChmlCmplncReqMktCntryProduce.Country,
  key         _ChmlCmplncReqMktCntryProduce.ChmlCmplncBusinessProcess,

              _Country,
              _ChmlCmplncReq
}
union all select from P_ChmlCmplncReqMktCntryAll as _ChmlCmplncReqMktCntryAll
{
  key         _ChmlCmplncReqMktCntryAll.ChmlCmplncRequestUUID,
  key         _ChmlCmplncReqMktCntryAll.Country,
  key         _ChmlCmplncReqMktCntryAll.ChmlCmplncBusinessProcess,

              _Country,
              _ChmlCmplncReq
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CHMLCMPLNCREQMKTCNTRYALL",
"P_CHMLCMPLNCREQMKTCNTRYPRODUCE",
"P_CHMLCMPLNCREQMKTCNTRYSELL"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCREQ",
"I_COUNTRY"
],
"BASE":
[
"P_CHMLCMPLNCREQMKTCNTRYSELL"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More