P_AU_StRpBASGLBal

DDL: P_AU_STRPBASGLBAL SQL: PAUSTRPGLBAL Type: view COMPOSITE Package: GLO_FIN_IS_AU

AU BAS GL Balance

P_AU_StRpBASGLBal is a Composite CDS View that provides data about "AU BAS GL Balance" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 17 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem. Part of development package GLO_FIN_IS_AU.

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from

Parameters (4)

NameTypeDefault
P_AU_WETIsRequired boolean
P_WithholdingTaxIsRequired boolean
P_LuxuryCarTxIsRequired boolean
P_FuelTaxIsRequired boolean

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PAUSTRPGLBAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
KEY AccountingDocumentItem AccountingDocumentItem
AU_WETIsRequired
WithholdingTaxIsRequired
LuxuryCarTxIsRequired
FuelTaxIsRequired
GLAccount GLAccount
ChartOfAccounts ChartOfAccounts
DebitCreditCode DebitCreditCode
TransactionTypeDetermination TransactionTypeDetermination
PostingDate PostingDate
AccountingDocumentType AccountingDocumentType
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency
CompanyCodeCurrency CompanyCodeCurrency
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy
@AbapCatalog.sqlViewName: 'PAUSTRPGLBAL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.authorizationCheck: #CHECK
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_AU_StRpBASGLBal
    with parameters P_AU_WETIsRequired : boolean,
                    P_WithholdingTaxIsRequired : boolean,
                    P_LuxuryCarTxIsRequired : boolean,
                    P_FuelTaxIsRequired : boolean   
                                     
as select from I_OperationalAcctgDocItem {
    //I_OperationalAcctgDocItem

    key CompanyCode,
    key AccountingDocument,
    key FiscalYear,
    key AccountingDocumentItem,
    $parameters.P_AU_WETIsRequired  as AU_WETIsRequired,
    $parameters.P_WithholdingTaxIsRequired as WithholdingTaxIsRequired,
    $parameters.P_LuxuryCarTxIsRequired as LuxuryCarTxIsRequired,
    $parameters.P_FuelTaxIsRequired as FuelTaxIsRequired,
    GLAccount,
    ChartOfAccounts,  
    DebitCreditCode,    
    TransactionTypeDetermination,                
    PostingDate,    
    AccountingDocumentType,
    AmountInCompanyCodeCurrency,
    CompanyCodeCurrency,
    TaxAmountInCoCodeCrcy
}