P_AU_StRpBASItem

DDL: P_AU_STRPBASITEM SQL: PAUSTRPBASITEM Type: view COMPOSITE
60 Fields 3 Data Sources

P_AU_StRpBASItem is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_AU_StRpBASGeneralLedgerBal, I_AU_StRpWithholdingTaxItem, I_StRpTaxItemBoxCube) and exposes 60 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, WithholdingTaxType.

Data Sources (3)

SourceAliasJoin Type
I_AU_StRpBASGeneralLedgerBal I_AU_StRpBASGeneralLedgerBal union_all
I_AU_StRpWithholdingTaxItem I_AU_StRpWithholdingTaxItem from
I_StRpTaxItemBoxCube I_StRpTaxItemBoxCube union_all

Parameters (4)

NameTypeDefault
P_AU_WETIsRequired boolean
P_WithholdingTaxIsRequired boolean
P_LuxuryCarTxIsRequired boolean
P_FuelTaxIsRequired boolean

Annotations (10)

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

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
KEY WithholdingTaxType WithholdingTaxType WTax Type
TransactionTypeDetermination Transaction Key
DebitCreditCode Single-Character Flag
AccountingDocumentType Journal Entry Type
SupplierAccountGroup Account group
TaxBox Tax.Bs.Gp.No.
TaxDeclnAmountType
TaxItemGroupingVersion Tax Grping Ver.
ValidFrom Vers.Valid From
TaxBoxStructureType
TaxGroup Tax Group
TaxItemGrpgDebitCreditCode Single-Character Flag
TaxItemGrpgAcctgDocumentType Journal Entry Type
TaxItemGrpgSupplierAcctGroup Account group
TaxItemGrpgSpecialGLCode Special G/L Ind
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem TaxItem Posting View Item
WithholdingTaxType WTax Type
KEY TransactionTypeDetermination TransactionTypeDetermination Transaction Key
KEY DebitCreditCode DebitCreditCode Single-Character Flag
KEY AccountingDocumentType AccountingDocumentType Journal Entry Type
KEY SupplierAccountGroup SupplierAccountGroup Account group
KEY TaxBox TaxBox Tax.Bs.Gp.No.
KEY TaxDeclnAmountType TaxDeclnAmountType
KEY TaxItemGroupingVersion TaxItemGroupingVersion Tax Grping Ver.
KEY ValidFrom ValidFrom Vers.Valid From
KEY TaxBoxStructureType TaxBoxStructureType
KEY TaxGroup TaxGroup Tax Group
KEY TaxItemGrpgDebitCreditCode TaxItemGrpgDebitCreditCode Single-Character Flag
KEY TaxItemGrpgAcctgDocumentType TaxItemGrpgAcctgDocumentType Journal Entry Type
KEY TaxItemGrpgSupplierAcctGroup TaxItemGrpgSupplierAcctGroup Account group
KEY TaxItemGrpgSpecialGLCode TaxItemGrpgSpecialGLCode Special G/L Ind
P_AU_WETIsRequired
P_WithholdingTaxIsRequired
P_LuxuryCarTxIsRequired
P_FuelTaxIsRequiredkeyCompanyCode
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
WithholdingTaxType WTax Type
KEY TransactionTypeDetermination TransactionTypeDetermination Transaction Key
KEY DebitCreditCode DebitCreditCode Single-Character Flag
KEY AccountingDocumentType AccountingDocumentType Journal Entry Type
KEY SupplierAccountGroup Account group
KEY TaxBox Tax.Bs.Gp.No.
KEY TaxDeclnAmountType
KEY TaxItemGroupingVersion Tax Grping Ver.
KEY ValidFrom Vers.Valid From
KEY TaxBoxStructureType
KEY TaxGroup Tax Group
KEY TaxItemGrpgDebitCreditCode Single-Character Flag
KEY TaxItemGrpgAcctgDocumentType Journal Entry Type
KEY TaxItemGrpgSupplierAcctGroup Account group
KEY TaxItemGrpgSpecialGLCode Special G/L Ind
TaxReportingDate PostingDate Posting Date for GR

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_AU_StRpBASItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PAUSTRPBASITEM
-- Parameters: P_AU_WETIsRequired : boolean, P_WithholdingTaxIsRequired : boolean, P_LuxuryCarTxIsRequired : boolean, P_FuelTaxIsRequired : boolean

CREATE VIEW P_AU_StRpBASItem AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  WithholdingTaxType,
  '' AS TransactionTypeDetermination,
  '' AS DebitCreditCode,
  '' AS AccountingDocumentType,
  '' AS SupplierAccountGroup,
  '' AS TaxBox,
  '' AS TaxDeclnAmountType,
  '' AS TaxItemGroupingVersion,
  '' AS ValidFrom,
  '' AS TaxBoxStructureType,
  '' AS TaxGroup,
  '' AS TaxItemGrpgDebitCreditCode,
  '' AS TaxItemGrpgAcctgDocumentType,
  '' AS TaxItemGrpgSupplierAcctGroup,
  '' AS TaxItemGrpgSpecialGLCode,
  ReportingDate as TaxReportingDate AS P_AU_WETIsRequired,
  P_WithholdingTaxIsRequired: $parameters.P_WithholdingTaxIsRequired AS P_WithholdingTaxIsRequired,
  P_LuxuryCarTxIsRequired:$parameters.P_LuxuryCarTxIsRequired AS P_LuxuryCarTxIsRequired,
  PostingDate AS TaxReportingDate
FROM I_AU_StRpWithholdingTaxItem
-- UNION ALL with additional select branch(es): I_StRpTaxItemBoxCube, I_AU_StRpBASGeneralLedgerBal
;

Learn More