P_OPLACCTGDOCITEMDEBITSUM
P_OPLACCTGDOCITEMDEBITSUM 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 |
|---|---|---|---|---|
| P_StRpTaxItmWithEUTaxClass7 | view | left_outer | COMPOSITE |
@AbapCatalog.sqlViewName: 'PFIOPACCTGDITDS'
@AbapCatalog.preserveKey:true
@VDM.viewType: #COMPOSITE
@VDM.private: true
//@Analytics: { dataCategory: #DIMENSION }
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Operational Acc. Doc. It. - Debit Sum'
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_OplAcctgDocItemDebitSum as
select from I_OperationalAcctgDocItem
{
key CompanyCode,
key AccountingDocument,
key FiscalYear,
key TaxCode,
sum(AmountInCompanyCodeCurrency) as AmountInCompanyCodeCurrency
}
where
AccountingDocumentItemType <> 'T' and
FinancialAccountType = 'S' and
(DebitCreditCode = 'S' or (DebitCreditCode = 'H' and IsNegativePosting = 'X')) //DebitCreditCode(=shkzg_calc) changed in P_BSEG_COM1 in case XNEGP=X
group by CompanyCode, AccountingDocument, FiscalYear, TaxCode
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OPERATIONALACCTGDOCITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/