I_CAStRpTaxReturnItemBox

DDL: I_CASTRPTAXRETURNITEMBOX Type: view_entity COMPOSITE
85 Fields 1 Data Sources

FICA Tax item and TaxBox

I_CAStRpTaxReturnItemBox is a Composite CDS View that provides data about "FICA Tax item and TaxBox" in SAP S/4HANA. It reads from 1 data source (I_CAStRpTaxReturnItem) and exposes 85 fields with key fields CompanyCode, CADocumentNumber, CompanyCodeCountry, TaxItemGroupingVersion, TaxCode.

Data Sources (1)

SourceAliasJoin Type
I_CAStRpTaxReturnItem I_CAStRpTaxReturnItem from

Parameters (8)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id
P_ReportingCountry land1
P_TaxBoxConfiguration figen_tdt_taxbox_config
P_LogicalSystem logsystem
P_CompanyCode bukrs
P_CARptgProcgBatchID fkkid_prbid

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label FICA Tax item and TaxBox view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (85)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode _ReturnItem CompanyCode Receiver Company Code
KEY CADocumentNumber _ReturnItem CADocumentNumber Document Number
KEY CompanyCodeCountry _ReturnItem CompanyCodeCountry Reporting Ctry/Reg.
KEY TaxItemGroupingVersion _TaxBox TaxItemGroupingVersion Tax Grping Ver.
KEY TaxCode _ReturnItem TaxCode Tax Code
KEY TransactionTypeDetermination _TaxBox TransactionTypeDetermination Transaction Key
KEY DebitCreditCode _TaxBox DebitCreditCode Single-Character Flag
KEY TaxBox _TaxBox TaxBox Tax.Bs.Gp.No.
KEY TaxDeclnAmountType _TaxBox TaxDeclnAmountType
KEY TaxBoxStrucValidityStartDate _TaxBox TaxBoxStrucValidityStartDate
KEY UnifiedTaxBoxStructureType _TaxBox UnifiedTaxBoxStructureType
KEY TaxBoxStructureType _TaxBox TaxBoxStructureType
KEY TaxGroup _TaxBox TaxGroup Tax Group
KEY SpecialGLCode _TaxBox SpecialGLCode Special G/L Ind
KEY SupplierAccountGroup _TaxBox SupplierAccountGroup Account group
KEY TaxRateValidityStartDate _TaxBox TaxRateValidityStartDate Tax Rate Validity Start Date
KEY TaxRateValidityEndDate _TaxBox TaxRateValidityEndDate
CARptgTaxItemOriginType _ReturnItem CARptgTaxItemOriginType
CARepetitionItemNumber _ReturnItem CARepetitionItemNumber Repetition Item
CAGLItemNumber _ReturnItem CAGLItemNumber Item
CASubItemNumber _ReturnItem CASubItemNumber Subitem
CAClearingDocumentNumber _ReturnItem CAClearingDocumentNumber Clearing Doc.
CARptgSrceRefType _ReturnItem CARptgSrceRefType
CARptgSrceReference _ReturnItem CARptgSrceReference
ReferenceDocumentType _ReturnItem ReferenceDocumentType Reference Document Type
TaxReportingDate _ReturnItem TaxReportingDate Tax Reporting Date
DocumentDate _ReturnItem DocumentDate Journal Entry Date
CAPostingDate _ReturnItem CAPostingDate Posting Date
CreationDate _ReturnItem CreationDate Time Stamp
TaxFulfillmentDate _ReturnItem TaxFulfillmentDate Tax Settlement Date
BusinessPartner _ReturnItem BusinessPartner Issuing Authority
ContractAccount _ReturnItem ContractAccount Contract Acct
CAOfficialDocumentNumber _ReturnItem CAOfficialDocumentNumber Offic. Doc. No.
LogicalSystem _ReturnItem LogicalSystem Logical System
CADocumentTypeForGLTransfer _ReturnItem CADocumentTypeForGLTransfer Tfr Doc. Type
CADocumentOriginCode _ReturnItem CADocumentOriginCode Document Origin
CAInvoicingDocument _ReturnItem CAInvoicingDocument Invoic. Doc.
CAApplicationArea _ReturnItem CAApplicationArea ApplicationArea
IsReversal _ReturnItem IsReversal Reversal doc.
IsReversed _ReturnItem IsReversed Reversed?
CAReconciliationKey _ReturnItem CAReconciliationKey Reconcil. Key
OriginalReferenceDocument _ReturnItem OriginalReferenceDocument Reference Key
CATransactionKeyAccountDetn _ReturnItem CATransactionKeyAccountDetn Autom. Posting
CATaxRate _ReturnItem CATaxRate Tax rate
GLAccount _ReturnItem GLAccount General Ledger
BusinessPlace _ReturnItem BusinessPlace Business place
TaxJurisdiction _ReturnItem TaxJurisdiction Tax Jurisdiction
CADocumentType _ReturnItem CADocumentType Document Type
CAReversedDocumentNumber _ReturnItem CAReversedDocumentNumber Rev. Doc. For
CAReversalDocumentNumber _ReturnItem CAReversalDocumentNumber Revers.document
CAReferenceDocument _ReturnItem CAReferenceDocument Reference
LedgerGroup _ReturnItem LedgerGroup Ledger Group
CATaxDate _ReturnItem CATaxDate Tax Date
CAExchangeRate _ReturnItem CAExchangeRate Absolute Exchange Rate
ChartOfAccounts _ReturnItem ChartOfAccounts Node Class
ConditionType _ReturnItem ConditionType Condition type
CompanyCodeCurrency _ReturnItem CompanyCodeCurrency Local Currency
CATaxBaseAmountInLocalCurrency _ReturnItem CATaxBaseAmountInLocalCurrency Tax base in LC
CATaxAmountInLocalCurrency _ReturnItem CATaxAmountInLocalCurrency LC Tax
TransactionCurrency _ReturnItem TransactionCurrency Transaction Currency
TaxBaseAmountInTransCrcy _ReturnItem TaxBaseAmountInTransCrcy Value-Added Tax
CATaxAmountInTransCurrency _ReturnItem CATaxAmountInTransCurrency Tax Amount
Segment _ReturnItem Segment Segment number
TaxCountry _ReturnItem TaxCountry Tax Ctry/Reg.
TransToTaxCntryCrcyCnvrsnFctr _ReturnItem TransToTaxCntryCrcyCnvrsnFctr Tax Factor C/R
TaxCalculationProcedure _ReturnItem TaxCalculationProcedure Tax Procedure
ReportingCountry _ReturnItem ReportingCountry
ReportingCurrency _ReturnItem ReportingCurrency Currency
TaxBaseAmountInRptgCrcy _ReturnItem TaxBaseAmountInRptgCrcy Base Amount
TaxAmountInRptgCrcy _ReturnItem TaxAmountInRptgCrcy Tax Rept. Crcy
CA1stCountrySpecificReference _ReturnItem CA1stCountrySpecificReference Reference
CAFirstCountrySpecificDate _ReturnItem CAFirstCountrySpecificDate Date
TaxType _ReturnItem TaxType Tax Type
TaxBoxStrucValidityEndDate _TaxBox TaxBoxStrucValidityEndDate
TaxBoxStructure _TaxBox TaxBoxStructure
TaxBoxStructureName _TaxBox TaxBoxStructureName
_BillingDocumentBasic _ReturnItem _BillingDocumentBasic
_BPLine _ReturnItem _BPLine
_BusinessPartner _ReturnItem _BusinessPartner
_CADoc _ReturnItem _CADoc
_CAInvcgDocHeader _ReturnItem _CAInvcgDocHeader
_CompanyCode _ReturnItem _CompanyCode
_GLLine _ReturnItem _GLLine
_TaxCode _ReturnItem _TaxCode
_CompanyCodeCountry _ReturnItem _CompanyCodeCountry

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_CAStRpTaxReturnItemBox.
-- 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, P_ReportingCountry : land1, P_TaxBoxConfiguration : figen_tdt_taxbox_config, P_LogicalSystem : logsystem, P_CompanyCode : bukrs, P_CARptgProcgBatchID : fkkid_prbid

CREATE VIEW I_CAStRpTaxReturnItemBox AS
SELECT
  _ReturnItem.CompanyCode AS CompanyCode,
  _ReturnItem.CADocumentNumber AS CADocumentNumber,
  _ReturnItem.CompanyCodeCountry AS CompanyCodeCountry,
  _TaxBox.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  _ReturnItem.TaxCode AS TaxCode,
  _TaxBox.TransactionTypeDetermination AS TransactionTypeDetermination,
  _TaxBox.DebitCreditCode AS DebitCreditCode,
  _TaxBox.TaxBox AS TaxBox,
  _TaxBox.TaxDeclnAmountType AS TaxDeclnAmountType,
  _TaxBox.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  _TaxBox.UnifiedTaxBoxStructureType AS UnifiedTaxBoxStructureType,
  _TaxBox.TaxBoxStructureType AS TaxBoxStructureType,
  _TaxBox.TaxGroup AS TaxGroup,
  _TaxBox.SpecialGLCode AS SpecialGLCode,
  _TaxBox.SupplierAccountGroup AS SupplierAccountGroup,
  _TaxBox.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  _TaxBox.TaxRateValidityEndDate AS TaxRateValidityEndDate,
  _ReturnItem.CARptgTaxItemOriginType AS CARptgTaxItemOriginType,
  _ReturnItem.CARepetitionItemNumber AS CARepetitionItemNumber,
  _ReturnItem.CAGLItemNumber AS CAGLItemNumber,
  _ReturnItem.CASubItemNumber AS CASubItemNumber,
  _ReturnItem.CAClearingDocumentNumber AS CAClearingDocumentNumber,
  _ReturnItem.CARptgSrceRefType AS CARptgSrceRefType,
  _ReturnItem.CARptgSrceReference AS CARptgSrceReference,
  _ReturnItem.ReferenceDocumentType AS ReferenceDocumentType,
  _ReturnItem.TaxReportingDate AS TaxReportingDate,
  _ReturnItem.DocumentDate AS DocumentDate,
  _ReturnItem.CAPostingDate AS CAPostingDate,
  _ReturnItem.CreationDate AS CreationDate,
  _ReturnItem.TaxFulfillmentDate AS TaxFulfillmentDate,
  _ReturnItem.BusinessPartner AS BusinessPartner,
  _ReturnItem.ContractAccount AS ContractAccount,
  _ReturnItem.CAOfficialDocumentNumber AS CAOfficialDocumentNumber,
  _ReturnItem.LogicalSystem AS LogicalSystem,
  _ReturnItem.CADocumentTypeForGLTransfer AS CADocumentTypeForGLTransfer,
  _ReturnItem.CADocumentOriginCode AS CADocumentOriginCode,
  _ReturnItem.CAInvoicingDocument AS CAInvoicingDocument,
  _ReturnItem.CAApplicationArea AS CAApplicationArea,
  _ReturnItem.IsReversal AS IsReversal,
  _ReturnItem.IsReversed AS IsReversed,
  _ReturnItem.CAReconciliationKey AS CAReconciliationKey,
  _ReturnItem.OriginalReferenceDocument AS OriginalReferenceDocument,
  _ReturnItem.CATransactionKeyAccountDetn AS CATransactionKeyAccountDetn,
  _ReturnItem.CATaxRate AS CATaxRate,
  _ReturnItem.GLAccount AS GLAccount,
  _ReturnItem.BusinessPlace AS BusinessPlace,
  _ReturnItem.TaxJurisdiction AS TaxJurisdiction,
  _ReturnItem.CADocumentType AS CADocumentType,
  _ReturnItem.CAReversedDocumentNumber AS CAReversedDocumentNumber,
  _ReturnItem.CAReversalDocumentNumber AS CAReversalDocumentNumber,
  _ReturnItem.CAReferenceDocument AS CAReferenceDocument,
  _ReturnItem.LedgerGroup AS LedgerGroup,
  _ReturnItem.CATaxDate AS CATaxDate,
  _ReturnItem.CAExchangeRate AS CAExchangeRate,
  _ReturnItem.ChartOfAccounts AS ChartOfAccounts,
  _ReturnItem.ConditionType AS ConditionType,
  _ReturnItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  _ReturnItem.CATaxBaseAmountInLocalCurrency AS CATaxBaseAmountInLocalCurrency,
  _ReturnItem.CATaxAmountInLocalCurrency AS CATaxAmountInLocalCurrency,
  _ReturnItem.TransactionCurrency AS TransactionCurrency,
  _ReturnItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  _ReturnItem.CATaxAmountInTransCurrency AS CATaxAmountInTransCurrency,
  _ReturnItem.Segment AS Segment,
  _ReturnItem.TaxCountry AS TaxCountry,
  _ReturnItem.TransToTaxCntryCrcyCnvrsnFctr AS TransToTaxCntryCrcyCnvrsnFctr,
  _ReturnItem.TaxCalculationProcedure AS TaxCalculationProcedure,
  _ReturnItem.ReportingCountry AS ReportingCountry,
  _ReturnItem.ReportingCurrency AS ReportingCurrency,
  _ReturnItem.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  _ReturnItem.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  _ReturnItem.CA1stCountrySpecificReference AS CA1stCountrySpecificReference,
  _ReturnItem.CAFirstCountrySpecificDate AS CAFirstCountrySpecificDate,
  _ReturnItem.TaxType AS TaxType,
  _TaxBox.TaxBoxStrucValidityEndDate AS TaxBoxStrucValidityEndDate,
  _TaxBox.TaxBoxStructure AS TaxBoxStructure,
  _TaxBox.TaxBoxStructureName AS TaxBoxStructureName,
  _ReturnItem._BillingDocumentBasic AS _BillingDocumentBasic,
  _ReturnItem._BPLine AS _BPLine,
  _ReturnItem._BusinessPartner AS _BusinessPartner,
  _ReturnItem._CADoc AS _CADoc,
  _ReturnItem._CAInvcgDocHeader AS _CAInvcgDocHeader,
  _ReturnItem._CompanyCode AS _CompanyCode,
  _ReturnItem._GLLine AS _GLLine,
  _ReturnItem._TaxCode AS _TaxCode,
  _ReturnItem._CompanyCodeCountry AS _CompanyCodeCountry
FROM I_CAStRpTaxReturnItem
;

Learn More