C_ID_StRpVATExportCube

DDL: C_ID_STRPVATEXPORTCUBE SQL: CIDSTRVATEXPCUBE Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_ID
26 Fields 2 Data Sources 2 Associations

Cube View for ID Exports VAT Report

C_ID_StRpVATExportCube is a Consumption CDS View (Cube) that provides data about "Cube View for ID Exports VAT Report" in SAP S/4HANA. It reads from 2 data sources (I_AcctDocCustomer, I_AccountingDocument) and exposes 26 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxBoxStrucValidityStartDate, UnifiedTaxBoxStructureType. It has 2 associations to related views. Part of development package GLO_FIN_IS_VAT_ID.

Data Sources (2)

SourceAliasJoin Type
I_AcctDocCustomer _AccDocCust inner
I_AccountingDocument I_AccountingDocument from

Parameters (7)

NameTypeDefault
P_CompanyCode fis_bukrs
P_FiscalYear gjahr
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

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CIDSTRVATEXPCUBE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Analytics.dataCategory #CUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #CONSUMPTION view
EndUserText.label Cube View for ID Exports VAT Report view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_AccountingDocument CompanyCode Receiver Company Code
KEY AccountingDocument I_AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear I_AccountingDocument FiscalYear G/L Fiscal Year
KEY TaxBoxStrucValidityStartDate _TaxItem TaxBoxStrucValidityStartDate
KEY UnifiedTaxBoxStructureType _TaxItem UnifiedTaxBoxStructureType
TaxBoxStructureType
FiscalPeriod FiscalPeriod Tax period
PostingDate PostingDate Posting Date for GR
TaxCode _TaxItem TaxCode Tax Code
TaxRateValidityStartDate _TaxItem TaxRateValidityStartDate Tax Rate Validity Start Date
TaxBoxStrucValidityEndDate _TaxItem TaxBoxStrucValidityEndDate
TaxRate
BusinessPlace I_AcctDocCustomer BusinessPlace Business place
SupplierendasCustomerSupplierAccount
Supplier I_AcctDocCustomer Supplier Supplier
Customer I_AcctDocCustomer Customer Sold-to Party
CompanyCodeCurrency I_AccountingDocument CompanyCodeCurrency Local Currency
AccountingDocumentHeaderText I_AccountingDocument AccountingDocumentHeaderText Doc.Header Text
Reference1InDocumentHeader I_AccountingDocument Reference1InDocumentHeader Reference 1
Reference2InDocumentHeader I_AccountingDocument Reference2InDocumentHeader Reference 2
OriginalReferenceDocument I_AccountingDocument OriginalReferenceDocument Reference Key
TaxAmountendasTaxAmount
LuxuryTaxAmtendasLuxuryTaxAmt
BPSupplierNameasCustomerName
Country1asCompleteAddress
endendasTaxNumber1

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 C_ID_StRpVATExportCube.
-- 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: CIDSTRVATEXPCUBE
-- Parameters: P_CompanyCode : fis_bukrs, P_FiscalYear : gjahr, 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

CREATE VIEW C_ID_StRpVATExportCube AS
SELECT
  I_AccountingDocument.CompanyCode AS CompanyCode,
  I_AccountingDocument.AccountingDocument AS AccountingDocument,
  I_AccountingDocument.FiscalYear AS FiscalYear,
  _TaxItem.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  _TaxItem.UnifiedTaxBoxStructureType AS UnifiedTaxBoxStructureType,
  cast('' as fot_atr_tax_box_struct_type ) AS TaxBoxStructureType,
  FiscalPeriod,
  PostingDate,
  _TaxItem.TaxCode AS TaxCode,
  _TaxItem.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  _TaxItem.TaxBoxStrucValidityEndDate AS TaxBoxStrucValidityEndDate,
  _TaxItem._StRpBPTaxItem.TaxRate AS TaxRate,
  _AccDocCust.BusinessPlace AS BusinessPlace,
  case when _AccDocCust.Customer != '' then _AccDocCust.Customer else _AccDocCust.Supplier end as CustomerSupplierAccount AS SupplierendasCustomerSupplierAccount,
  _AccDocCust.Supplier AS Supplier,
  _AccDocCust.Customer AS Customer,
  I_AccountingDocument.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_AccountingDocument.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  I_AccountingDocument.Reference1InDocumentHeader AS Reference1InDocumentHeader,
  I_AccountingDocument.Reference2InDocumentHeader AS Reference2InDocumentHeader,
  I_AccountingDocument.OriginalReferenceDocument AS OriginalReferenceDocument,
  case when _AccDocCust.IsNegativePosting = 'X' then _TaxItem.TaxAmount else -(_TaxItem.TaxAmount) end as TaxAmount AS TaxAmountendasTaxAmount,
  case when _AccDocCust.IsNegativePosting = 'X' then _TaxItem.LuxuryTaxAmt else -(_TaxItem.LuxuryTaxAmt) end as LuxuryTaxAmt AS LuxuryTaxAmtendasLuxuryTaxAmt,
  replace(coalesce(concat(concat(concat( _TaxItem._OneTimeAccountBP.BusinessPartnerName1, _TaxItem._OneTimeAccountBP.BusinessPartnerName2), _TaxItem._OneTimeAccountBP.BusinessPartnerName3), _TaxItem._OneTimeAccountBP.BusinessPartnerName4), coalesce(_Customer.BPCustomerName, _Supplier.BPSupplierName)), ',', ' ' ) as CustomerName AS BPSupplierNameasCustomerName,
  coalesce(_TaxItem.AddressLine2, coalesce(concat_with_space(concat_with_space(concat_with_space(concat_with_space(concat_with_space(concat( concat(_Customer._AddressDefaultRepresentation.StreetPrefixName1, ','), _Customer._AddressDefaultRepresentation.StreetPrefixName2), concat_with_space(_Customer._AddressDefaultRepresentation.StreetName, _Customer._AddressDefaultRepresentation.HouseNumber, 1), 1), concat(concat(_Customer._AddressDefaultRepresentation.StreetSuffixName1, ','), _Customer._AddressDefaultRepresentation.StreetSuffixName2), 1), concat(concat(_Customer._AddressDefaultRepresentation.VillageName, ','), _Customer._AddressDefaultRepresentation.DistrictName), 1), concat(concat(_Customer._AddressDefaultRepresentation.CityName, ','), _Customer._AddressDefaultRepresentation.PostalCode), 1), _Customer._AddressDefaultRepresentation.Country, 1), concat_with_space(concat_with_space(concat_with_space(concat_with_space(concat_with_space(concat( concat(_Supplier._AddressDefaultRepresentation.StreetPrefixName1, ','), _Supplier._AddressDefaultRepresentation.StreetPrefixName2), concat_with_space(_Supplier._AddressDefaultRepresentation.StreetName, _Supplier._AddressDefaultRepresentation.HouseNumber, 1), 1), concat(concat(_Supplier._AddressDefaultRepresentation.StreetSuffixName1, ','), _Supplier._AddressDefaultRepresentation.StreetSuffixName2), 1), concat(concat(_Supplier._AddressDefaultRepresentation.VillageName, ','), _Supplier._AddressDefaultRepresentation.DistrictName), 1), concat(concat(_Supplier._AddressDefaultRepresentation.CityName, ','), _Supplier._AddressDefaultRepresentation.PostalCode), 1), _Supplier._AddressDefaultRepresentation.Country, 1))) as CompleteAddress AS Country1asCompleteAddress,
  case when _TaxItem._OneTimeAccountBP.TaxID1!='' then replace(replace( _TaxItem._OneTimeAccountBP.TaxID1, '.', '' ),'-','') else case when _AccDocCust.Customer != '' then replace(replace(_Customer.TaxNumber1, '.', '' ),'-','') else replace(replace(_Supplier.TaxNumber1, '.', '' ),'-','') end end as TaxNumber1 AS endendasTaxNumber1
FROM I_AccountingDocument
INNER JOIN I_AcctDocCustomer AS _AccDocCust ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
;

Learn More