P_OplAcctgDocItemCreditSum

DDL: P_OPLACCTGDOCITEMCREDITSUM SQL: PFIOPACCTGDITCS Type: view COMPOSITE

P_OplAcctgDocItemCreditSum is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 5 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxCode.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PFIOPACCTGDITCS view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
KEY TaxCode TaxCode
AmountInCompanyCodeCurrency 
@AbapCatalog.sqlViewName: 'PFIOPACCTGDITCS'
@AbapCatalog.preserveKey:true 
@VDM.viewType: #COMPOSITE
@VDM.private: true
//@Analytics: { dataCategory: #DIMENSION }

@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Operational Acc. Doc. It. - Credit Sum'

@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_OplAcctgDocItemCreditSum 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 = 'H' or (DebitCreditCode = 'S' 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":""
}
}*/

Learn More