C_AR_StRpVATForm731ItemLogC

DDL: C_AR_STRPVATFORM731ITEMLOGC SQL: CARFORM731LGC Type: view CONSUMPTION Package: GLO_FIN_FI_AR_DEPREC
37 Fields 5 Data Sources

Argentina VAT Form 731 with Rptd item log data

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

Data Sources (5)

SourceAliasJoin Type
I_Withholdingtaxitem _Withholdingtaxitem left_outer
I_AR_TaxClassIdentification I_AR_TaxClassIdentification left_outer
I_Customer I_Customer left_outer
I_GLAccountLineItem I_GLAccountLineItem left_outer
I_Supplier I_Supplier left_outer

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CARFORM731LGC 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 with Rptd item log data 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

Fields (37)

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
TaxReportingDate TaxItem TaxReportingDate Tax Reporting Date
GLAccount TaxItem GLAccount General Ledger
TaxType TaxType Tax Type
PostingDate TaxItem PostingDate Posting Date for GR
ReportingDate ReportingDate
AmountInCompanyCodeCurrency I_GLAccountLineItem AmountInCompanyCodeCurrency Local Crcy Amt
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
FinancialAccountType _DebtorCreditorRblsPyblsItem FinancialAccountType Fin. Account Type
GLBusinessTransactionType I_AR_TaxClassIdentification GLBusinessTransactionType Transact. Type
StatryRptCategory
StatryRptgEntity
StatryRptRunID

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_StRpVATForm731ItemLogC.
-- 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: CARFORM731LGC

CREATE VIEW C_AR_StRpVATForm731ItemLogC 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,
  TaxItem.TaxReportingDate AS TaxReportingDate,
  TaxItem.GLAccount AS GLAccount,
  TaxType,
  TaxItem.PostingDate AS PostingDate,
  ReportingDate,
  I_GLAccountLineItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  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,
  _DebtorCreditorRblsPyblsItem.FinancialAccountType AS FinancialAccountType,
  I_AR_TaxClassIdentification.GLBusinessTransactionType AS GLBusinessTransactionType,
  TaxItem._ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  TaxItem._ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  TaxItem._ReportedItemsLog.StatryRptRunID AS StatryRptRunID
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 */
LEFT OUTER JOIN I_Withholdingtaxitem AS _Withholdingtaxitem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GLAccountLineItem ON /* join condition not captured in parsed metadata */
;

Learn More