I_CAStRpTaxReturnItemCube

DDL: I_CASTRPTAXRETURNITEMCUBE Type: view_entity COMPOSITE
60 Fields 1 Data Sources

FICA tax return item - Cube

I_CAStRpTaxReturnItemCube is a Composite CDS View (Cube) that provides data about "FICA tax return item - Cube" in SAP S/4HANA. It reads from 1 data source (P_CAStRpTaxReturnItemCube) and exposes 60 fields with key fields CompanyCode, CADocumentNumber, CARptgTaxItemOriginType, CARepetitionItemNumber, CAGLItemNumber.

Data Sources (1)

SourceAliasJoin Type
P_CAStRpTaxReturnItemCube P_CAStRpTaxReturnItemCube from

Parameters (3)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label FICA tax return item - Cube view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
Analytics.internalName #LOCAL view

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY CADocumentNumber CADocumentNumber Document Number
KEY CARptgTaxItemOriginType CARptgTaxItemOriginType
KEY CARepetitionItemNumber CARepetitionItemNumber Repetition Item
KEY CAGLItemNumber CAGLItemNumber Item
KEY CASubItemNumber CASubItemNumber Subitem
KEY CAClearingDocumentNumber CAClearingDocumentNumber Clearing Doc.
ReferenceDocumentType ReferenceDocumentType Reference Document Type
TaxReportingDate TaxReportingDate Tax Reporting Date
DocumentDate DocumentDate Journal Entry Date
CAPostingDate CAPostingDate Posting Date
CreationDate CreationDate Time Stamp
TaxFulfillmentDate TaxFulfillmentDate Tax Settlement Date
BusinessPartner BusinessPartner Issuing Authority
ContractAccount ContractAccount Contract Acct
CAOfficialDocumentNumber CAOfficialDocumentNumber Offic. Doc. No.
LogicalSystem LogicalSystem Logical System
CADocumentTypeForGLTransfer CADocumentTypeForGLTransfer Tfr Doc. Type
CADocumentOriginCode CADocumentOriginCode Document Origin
CAInvoicingDocument CAInvoicingDocument Invoic. Doc.
CAApplicationArea CAApplicationArea ApplicationArea
CARptgSrceRefType CARptgSrceRefType
CARptgSrceReference CARptgSrceReference
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
CAReconciliationKey CAReconciliationKey Reconcil. Key
OriginalReferenceDocument OriginalReferenceDocument Reference Key
TaxCode TaxCode Tax Code
CATransactionKeyAccountDetn CATransactionKeyAccountDetn Autom. Posting
int8end10006asstrpz_kk_newasCATaxRate Tax rate
GLAccount GLAccount General Ledger
BusinessPlace BusinessPlace Business place
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
CADocumentType CADocumentType Document Type
CAReversedDocumentNumber CAReversedDocumentNumber Rev. Doc. For
CAReversalDocumentNumber CAReversalDocumentNumber Revers.document
CAReferenceDocument CAReferenceDocument Reference
LedgerGroup LedgerGroup Ledger Group
CATaxDate CATaxDate Tax Date
CAExchangeRate CAExchangeRate Absolute Exchange Rate
ChartOfAccounts ChartOfAccounts Node Class
ConditionType ConditionType Condition type
CompanyCodeCurrency CompanyCodeCurrency Local Currency
CATaxBaseAmountInLocalCurrency CATaxBaseAmountInLocalCurrency Tax base in LC
CATaxAmountInLocalCurrency CATaxAmountInLocalCurrency LC Tax
TransactionCurrency TransactionCurrency Transaction Currency
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy Value-Added Tax
CATaxAmountInTransCurrency CATaxAmountInTransCurrency Tax Amount
Segment Segment Segment number
TaxCountry TaxCountry Tax Ctry/Reg.
TransToTaxCntryCrcyCnvrsnFctr TransToTaxCntryCrcyCnvrsnFctr Tax Factor C/R
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
TaxCalculationProcedure TaxCalculationProcedure Tax Procedure
ReportingCountry ReportingCountry
ReportingCurrency ReportingCurrency Currency
TaxBaseAmountInRptgCrcy TaxBaseAmountInRptgCrcy Base Amount
TaxAmountInRptgCrcy TaxAmountInRptgCrcy Tax Rept. Crcy
CA1stCountrySpecificReference CA1stCountrySpecificReference Reference
CAFirstCountrySpecificDate CAFirstCountrySpecificDate Date
TaxType TaxType Tax Type

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 I_CAStRpTaxReturnItemCube.
-- 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.
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW I_CAStRpTaxReturnItemCube AS
SELECT
  CompanyCode,
  CADocumentNumber,
  CARptgTaxItemOriginType,
  CARepetitionItemNumber,
  CAGLItemNumber,
  CASubItemNumber,
  CAClearingDocumentNumber,
  ReferenceDocumentType,
  TaxReportingDate,
  DocumentDate,
  CAPostingDate,
  CreationDate,
  TaxFulfillmentDate,
  BusinessPartner,
  ContractAccount,
  CAOfficialDocumentNumber,
  LogicalSystem,
  CADocumentTypeForGLTransfer,
  CADocumentOriginCode,
  CAInvoicingDocument,
  CAApplicationArea,
  CARptgSrceRefType,
  CARptgSrceReference,
  IsReversal,
  IsReversed,
  CAReconciliationKey,
  OriginalReferenceDocument,
  TaxCode,
  CATransactionKeyAccountDetn,
  cast ( division(case when CATaxRate <> cast('' as abap.numc(6)) then case when cast( CATaxRate as abap.int8) > 500000 then (cast(CATaxRate as abap.int8)-500000)*-1 else cast(CATaxRate as abap.int8) end else cast(0 as abap.int8) end,1000,6) as strpz_kk_new) as CATaxRate AS int8end10006asstrpz_kk_newasCATaxRate,
  GLAccount,
  BusinessPlace,
  TaxJurisdiction,
  CADocumentType,
  CAReversedDocumentNumber,
  CAReversalDocumentNumber,
  CAReferenceDocument,
  LedgerGroup,
  CATaxDate,
  CAExchangeRate,
  ChartOfAccounts,
  ConditionType,
  CompanyCodeCurrency,
  CATaxBaseAmountInLocalCurrency,
  CATaxAmountInLocalCurrency,
  TransactionCurrency,
  TaxBaseAmountInTransCrcy,
  CATaxAmountInTransCurrency,
  Segment,
  TaxCountry,
  TransToTaxCntryCrcyCnvrsnFctr,
  CompanyCodeCountry,
  TaxCalculationProcedure,
  ReportingCountry,
  ReportingCurrency,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  CA1stCountrySpecificReference,
  CAFirstCountrySpecificDate,
  TaxType
FROM P_CAStRpTaxReturnItemCube
;

Learn More