I_PRODCMPLNCLEGALAREA
Legal Area
I_PRODCMPLNCLEGALAREA is a CDS View in S/4HANA. Legal Area. It contains 1 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_ChmlCmplncLegalAreaVH | view | from | CONSUMPTION | Legal Area for Chemical Compliance Information |
| C_PCTrdScrtAssgmtVH | view_entity | from | CONSUMPTION | Trade Secret Assignment |
| C_ProdCmplncLegalAreaVH | view | from | CONSUMPTION | Legal Area for Product Complience |
| C_SubstanceMnmrCmpstnVH | view | from | CONSUMPTION | Not Assigned Legal Area |
| P_ChmlCmplncUse | view | cross | CONSUMPTION |
Fields (1)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ProdCmplncLegalArea | ProdCmplncLegalArea | 1 |
--Label of view
-- e.g. display as filter name in the consumption
@EndUserText.label: 'Legal Area'
@AbapCatalog:
{
-- SQL view name (16 characters)
sqlViewName: 'IPCLEGALAREA',
--If it's true, the filter conditions are compared and, if they match, the associated join expression is evaluated only once
compiler.compareFilter: true,
preserveKey: true
}
--Access Control: Authorizations Checks
@AccessControl:
{
// authorization check not required as view only reads customizing values
authorizationCheck: #NOT_REQUIRED
}
--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE
--VDM view type
@VDM.viewType: #BASIC
@ObjectModel:
{
--Performance Annotations
usageType:
{
dataClass: #CUSTOMIZING,
sizeCategory: #S,
serviceQuality: #B
},
representativeKey: 'ProdCmplncLegalArea'
}
define view I_ProdCmplncLegalArea
as select from ehfndc_cmpstype as LegalArea
--Text association
association [0..*] to I_ProdCmplncLegalAreaText as _Text on $projection.ProdCmplncLegalArea = _Text.ProdCmplncLegalArea
{
--Composition Type
@ObjectModel.text.association: '_Text'
key LegalArea.composition_type as ProdCmplncLegalArea,
/*Association*/
_Text
}
where
LegalArea.composition_type <> 'MATLBSD1'
and LegalArea.composition_type <> 'MATLBSD2'
and LegalArea.composition_type <> 'ANALYTIC1'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHFNDC_CMPSTYPE"
],
"ASSOCIATED":
[
"I_PRODCMPLNCLEGALAREATEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/