P_GMAVCLDGRACTMINMAX
P_GMAVCLDGRACTMINMAX is a CDS View in S/4HANA. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_GMAVCSetLocCurr | view | left_outer | BASIC | |
| P_GMAVCSetLocCurr | view | union_all | BASIC |
@AbapCatalog.sqlViewName: 'PGMAVCLDRMAX'
//@ClientDependent: true
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@VDM.private: true
//@EndUserText.label: 'Minimum/maximum values from GMAVCLDGRACT'
define view P_GMAVCLDGRACTMinMax as select from gmavcldgract {
min(comp_code) as min_comp_code,
max(comp_code) as max_comp_code,
min(aldnr) as min_aldnr,
max(aldnr) as max_aldnr,
min(fiscyearfrom) as min_fiscyearfrom,
max(fiscyearfrom) as max_fiscyearfrom
}
where ldgrstat is not null
and ldgrstat <> ' '
and ldgrstat <> 'N'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"GMAVCLDGRACT"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/