P_NO_SAFTGRPGACCTMAPPINGCOUNT
P_NO_SAFTGRPGACCTMAPPINGCOUNT is a CDS View in S/4HANA. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_NO_SAFTGenLedgerAcctBalance | view | left_outer | CONSUMPTION | SAF-T Norway GL Accounts Balance |
@AbapCatalog.sqlViewName: 'PNOSAFTGRPACMPCT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #P
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view P_NO_SAFTGrpgAcctMappingCount
with parameters
P_StartDate :dats,
P_EndDate :dats
as select from I_NO_SAFTGrpgAccountMapping
{
key CompanyCode,
key ChartOfAccounts,
count(*) as QtdOfRecords
}
where
StartDate <= $parameters.P_EndDate
and EndDate >= $parameters.P_StartDate
group by
CompanyCode,
ChartOfAccounts
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_NO_SAFTGRPGACCOUNTMAPPING"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/