P_CASHPOSITION
P_CASHPOSITION 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 |
|---|---|---|---|---|
| I_CashPosition | view | from | COMPOSITE | Cash Position |
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PCASHPOSITION'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropogatedAnnotations: true
define view P_CashPosition
with parameters
P_StartDate : vdm_v_start_date,
P_KeyDate : sydate
as select from P_CshPosUni( P_StartDate: $parameters.P_StartDate, P_KeyDate: $parameters.P_KeyDate) as pos
{
pos.CompanyCode,
--pos.TransactionDate,
pos.BankAccountInternalID,
pos.CertaintyLevel,
pos.Currency,
--pos.HouseBank,
--pos.HouseBankAccount,
pos.BankAccount,
pos.Bank,
pos.BankCountry,
sum(pos.Amount) as Amount
}
group by
pos.CompanyCode,
--pos.TransactionDate,
pos.BankAccountInternalID,
pos.CertaintyLevel,
pos.Currency,
--pos.HouseBank,
--pos.HouseBankAccount,
pos.BankAccount,
pos.Bank,
pos.BankCountry
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CSHPOSUNI"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/