Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

C_AR_StRpVATForm731ItemC

DDL: C_AR_STRPVATFORM731ITEMC SQL: CARFORM731 Type: view CONSUMPTION Package: GLO_FIN_FI_AR_DEPREC

Argentina VAT Form 731

C_AR_StRpVATForm731ItemC is a Consumption CDS View (Cube) that provides data about "Argentina VAT Form 731" in SAP S/4HANA. It reads from 3 data sources (I_AR_TaxClassIdentification, I_Customer, I_Supplier) and exposes 40 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TransactionTypeDetermination. Part of development package GLO_FIN_FI_AR_DEPREC.

Data Sources (3)

SourceAliasJoin Type
I_AR_TaxClassIdentification I_AR_TaxClassIdentification left_outer
I_Customer I_Customer left_outer
I_Supplier I_Supplier left_outer

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CARFORM731 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Argentina VAT Form 731 view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #CUBE view
Metadata.allowExtensions true view
VDM.lifecycle.status #DEPRECATED view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode TaxItem CompanyCode Receiver Company Code
KEY AccountingDocument TaxItem AccountingDocument Journal Entry
KEY FiscalYear TaxItem FiscalYear G/L Fiscal Year
KEY TaxItem TaxItem TaxItem Tax Item
KEY TransactionTypeDetermination TaxItem TransactionTypeDetermination Transaction Key
KEY TaxCode TaxItem TaxCode Tax Code
KEY StatryRptgEntity StatryRptgEntity Reporting Entity
KEY StatryRptCategory StatryRptCategory Report ID
KEY StatryRptRunID StatryRptRunID Report Run ID
TaxReportingDate TaxItem TaxReportingDate Tax Reporting Date
GLAccount TaxItem GLAccount General Ledger
TaxType TaxType Tax Type
PostingDate TaxItem PostingDate Posting Date for GR
ReportingDate ReportingDate
DebitCreditCode DebitCreditCode Single-Character Flag
Ledger Ledger Ledger
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy Value-Added Tax
TaxReturnCountry TaxReturnCountry Reporting C/R
TaxAmountInCountryCrcy TaxAmountInCountryCrcy Tax Rept. Crcy
TaxBaseAmountInCountryCrcy TaxBaseAmountInCountryCrcy Base Amount
CompanyCodeCurrency TaxItem CompanyCodeCurrency Local Currency
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
DocumentCurrency TaxItem DocumentCurrency Document Currency
CountryCurrency CountryCurrency Currency
TaxCalculationProcedure TaxItem TaxCalculationProcedure Tax Procedure
StRpTaxClassification StRpTaxClassification Tax class
AddressRegion AddressRegion Region
CustomerCounty CustomerCounty County Code
MunicipalJurisdiction MunicipalJurisdiction Munic. Jurisd. Code
ZeroVATRsn ZeroVATRsn Reason for Zero VAT
TaxIsProRated TaxIsProRated ProRated Ind.
ResponsibleType I_Customer ResponsibleType Tax Type
Customer I_Customer Customer Sold-to Party
Supplier I_Supplier Supplier Supplier
GLBusinessTransactionType GLBusinessTransactionType Transact. Type
BusinessPartner TaxItem BusinessPartner Issuing Authority
SupplierCountry I_Supplier Country Venue: Ctry/Reg
CustomerCountry I_Customer Country Venue: Ctry/Reg

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_StRpVATForm731ItemC.
-- 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: CARFORM731

CREATE VIEW C_AR_StRpVATForm731ItemC AS
SELECT
  TaxItem.CompanyCode AS CompanyCode,
  TaxItem.AccountingDocument AS AccountingDocument,
  TaxItem.FiscalYear AS FiscalYear,
  TaxItem.TaxItem AS TaxItem,
  TaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  TaxItem.TaxCode AS TaxCode,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  TaxItem.TaxReportingDate AS TaxReportingDate,
  TaxItem.GLAccount AS GLAccount,
  TaxType,
  TaxItem.PostingDate AS PostingDate,
  ReportingDate,
  DebitCreditCode,
  Ledger,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxReturnCountry,
  TaxAmountInCountryCrcy,
  TaxBaseAmountInCountryCrcy,
  TaxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  CompanyCodeCountry,
  TaxItem.DocumentCurrency AS DocumentCurrency,
  CountryCurrency,
  TaxItem.TaxCalculationProcedure AS TaxCalculationProcedure,
  StRpTaxClassification,
  AddressRegion,
  CustomerCounty,
  MunicipalJurisdiction,
  ZeroVATRsn,
  TaxIsProRated,
  I_Customer.ResponsibleType AS ResponsibleType,
  I_Customer.Customer AS Customer,
  I_Supplier.Supplier AS Supplier,
  GLBusinessTransactionType,
  TaxItem.BusinessPartner AS BusinessPartner,
  I_Supplier.Country AS SupplierCountry,
  I_Customer.Country AS CustomerCountry
LEFT OUTER JOIN I_AR_TaxClassIdentification ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Customer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Supplier ON /* join condition not captured in parsed metadata */
;