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
40 Fields 3 Data Sources

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 StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, AccountingDocument.

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 StatryRptgEntity StatryRptgEntity Reporting Entity
KEY StatryRptCategory StatryRptCategory Report ID
KEY StatryRptRunID StatryRptRunID Report Run ID
TaxType TaxType Tax Type
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
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
CountryCurrency CountryCurrency Currency
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.
GLBusinessTransactionType GLBusinessTransactionType Transact. Type
ResponsibleType I_Customer ResponsibleType Tax Type
Customer I_Customer Customer Sold-to Party
CustomerCountry I_Customer Country Venue: Ctry/Reg
Supplier I_Supplier Supplier Supplier
SupplierCountry I_Supplier Country Venue: Ctry/Reg
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
TaxReportingDate TaxItem TaxReportingDate Tax Reporting Date
GLAccount TaxItem GLAccount General Ledger
PostingDate TaxItem PostingDate Posting Date for GR
CompanyCodeCurrency TaxItem CompanyCodeCurrency Local Currency
DocumentCurrency TaxItem DocumentCurrency Document Currency
TaxCalculationProcedure TaxItem TaxCalculationProcedure Tax Procedure
BusinessPartner TaxItem BusinessPartner Issuing Authority

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
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  TaxType,
  ReportingDate,
  DebitCreditCode,
  Ledger,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxReturnCountry,
  TaxAmountInCountryCrcy,
  TaxBaseAmountInCountryCrcy,
  CompanyCodeCountry,
  CountryCurrency,
  StRpTaxClassification,
  AddressRegion,
  CustomerCounty,
  MunicipalJurisdiction,
  ZeroVATRsn,
  TaxIsProRated,
  GLBusinessTransactionType,
  I_Customer.ResponsibleType AS ResponsibleType,
  I_Customer.Customer AS Customer,
  I_Customer.Country AS CustomerCountry,
  I_Supplier.Supplier AS Supplier,
  I_Supplier.Country AS SupplierCountry,
  TaxItem.CompanyCode AS CompanyCode,
  TaxItem.AccountingDocument AS AccountingDocument,
  TaxItem.FiscalYear AS FiscalYear,
  TaxItem.TaxItem AS TaxItem,
  TaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  TaxItem.TaxCode AS TaxCode,
  TaxItem.TaxReportingDate AS TaxReportingDate,
  TaxItem.GLAccount AS GLAccount,
  TaxItem.PostingDate AS PostingDate,
  TaxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  TaxItem.DocumentCurrency AS DocumentCurrency,
  TaxItem.TaxCalculationProcedure AS TaxCalculationProcedure,
  TaxItem.BusinessPartner AS BusinessPartner
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 */
;

Learn More