C_AR_StRpPurFrgnSrvcCube

DDL: C_AR_STRPPURFRGNSRVCCUBE SQL: CARPURFRGNSRITMC Type: view CONSUMPTION
49 Fields 3 Data Sources

Cube View For Argentina Foreign Service

C_AR_StRpPurFrgnSrvcCube is a Consumption CDS View (Cube) that provides data about "Cube View For Argentina Foreign Service" in SAP S/4HANA. It reads from 3 data sources (I_Housebank, I_GLAccountInCompanyCode, I_AR_StRpPurFrgnSrvcItem) and exposes 49 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, TaxCode.

Data Sources (3)

SourceAliasJoin Type
I_Housebank BankCuitDet inner
I_GLAccountInCompanyCode BankGlDet left_outer
I_AR_StRpPurFrgnSrvcItem I_AR_StRpPurFrgnSrvcItem from

Parameters (1)

NameTypeDefault
P_AccrualCalculationMethod fiar_vat_compcredit

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CARPURFRGNSRITMC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Cube View For Argentina Foreign Service view
Metadata.allowExtensions true view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_AR_StRpPurFrgnSrvcItem CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
KEY TaxCode TaxCode Tax Code
KEY TransactionTypeDetermination TransactionTypeDetermination Transaction Key
PostingDate PostingDate Posting Date for GR
ReportingDate ReportingDate
StRpTaxClassification StRpTaxClassification
DocumentDate DocumentDate Journal Entry Date
AR_OfficialDocumentNumber AR_OfficialDocumentNumber
DocumentReferenceID DocumentReferenceID Reference
ExchangeRate ExchangeRate Exchange rate
TaxNumber1 TaxNumber1 VAT Reg. No.
IsRespForImportDeclaration IsRespForImportDeclaration
TaxNumberType TaxNumberType Tax number type
AlternativeCurrencyKey AlternativeCurrencyKey
BusinessPartnerCountry BusinessPartnerCountry BP Ctry/Reg.
CountryFreeText CountryFreeText
NmbrOfVATRates NmbrOfVATRates
AR_OfficialDocumentType AR_OfficialDocumentType
DocumentCurrency DocumentCurrency Document Currency
AR_CUIT AR_CUIT
HierarchyNodeText HierarchyNodeText
AR_VATRateCode AR_VATRateCode
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy Value-Added Tax
TaxBaseAmountInCountryCrcy TaxBaseAmountInCountryCrcy Base Amount
IsValid IsValid Truth Value
ItemIsActivated ItemIsActivated Items Active
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
BusinessPartnerName BusinessPartnerName Extracted Customer Name
PurchaseImportForm PurchaseImportForm
ClearingAccountingDocument ClearingAccountingDocument Clearing Journal Entry
TaxReportingDate TaxReportingDate Tax Reporting Date
GLAccount I_AR_StRpPurFrgnSrvcItem GLAccount General Ledger
DocumentTypeCategory DocumentTypeCategory
AccountingDocumentTypeName AccountingDocumentTypeName
BankIdentification I_Housebank TaxID1 Tax Number 1
CompanyCodeCurrency CompanyCodeCurrency Local Currency
TaxAmount TaxAmount Tax Amt in Rptg Crcy
TaxAmountInRptgCrcy TaxAmountInRptgCrcy Tax Rept. Crcy
StatryRptCategory _ReportedItemsLog StatryRptCategory Report ID
StatryRptgEntity _ReportedItemsLog StatryRptgEntity Reporting Entity
StatryRptRunID _ReportedItemsLog StatryRptRunID Report Run ID
_AccountingDocument _AccountingDocument
_ReceivablesPayablesItem _ReceivablesPayablesItem
_ReportedItemsLog _ReportedItemsLog
GLBusinessTransactionType GLBusinessTransactionType Transact. Type
ResponsibleType ResponsibleType 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 C_AR_StRpPurFrgnSrvcCube.
-- 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: CARPURFRGNSRITMC
-- Parameters: P_AccrualCalculationMethod : fiar_vat_compcredit

CREATE VIEW C_AR_StRpPurFrgnSrvcCube AS
SELECT
  I_AR_StRpPurFrgnSrvcItem.CompanyCode AS CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  TaxCode,
  TransactionTypeDetermination,
  PostingDate,
  ReportingDate,
  StRpTaxClassification,
  DocumentDate,
  AR_OfficialDocumentNumber,
  DocumentReferenceID,
  ExchangeRate,
  TaxNumber1,
  IsRespForImportDeclaration,
  TaxNumberType,
  AlternativeCurrencyKey,
  BusinessPartnerCountry,
  CountryFreeText,
  NmbrOfVATRates,
  AR_OfficialDocumentType,
  DocumentCurrency,
  AR_CUIT,
  HierarchyNodeText,
  AR_VATRateCode,
  TaxBaseAmountInTransCrcy,
  TaxBaseAmountInCountryCrcy,
  IsValid,
  ItemIsActivated,
  TaxBaseAmountInCoCodeCrcy,
  BusinessPartnerName,
  PurchaseImportForm,
  ClearingAccountingDocument,
  TaxReportingDate,
  I_AR_StRpPurFrgnSrvcItem.GLAccount AS GLAccount,
  DocumentTypeCategory,
  AccountingDocumentTypeName,
  BankCuitDet.TaxID1 AS BankIdentification,
  CompanyCodeCurrency,
  TaxAmount,
  TaxAmountInRptgCrcy,
  _ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  _ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  _ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  GLBusinessTransactionType,
  ResponsibleType
FROM I_AR_StRpPurFrgnSrvcItem
LEFT OUTER JOIN I_GLAccountInCompanyCode AS BankGlDet ON /* join condition not captured in parsed metadata */
INNER JOIN I_Housebank AS BankCuitDet ON /* join condition not captured in parsed metadata */
;

Learn More