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

C_ZA_StRpRevenueExpenseLineQry

DDL: C_ZA_STRPREVENUEEXPENSELINEQRY SQL: CSRZARVEXLINEQ Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_ZA
29 Fields

Analytical Query for Revenue Expense Lines

C_ZA_StRpRevenueExpenseLineQry is a Consumption CDS View that provides data about "Analytical Query for Revenue Expense Lines" in SAP S/4HANA. Part of development package GLO_FIN_IS_VAT_ZA.

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CSRZARVEXLINEQ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.query true view
VDM.lifecycle.status #DEPRECATED view
EndUserText.label Analytical Query for Revenue Expense Lines view
AccessControl.blocking #BLOCKED_DATA_INCLUDED view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY TaxCode TaxCode Tax Code
KEY TransactionTypeDetermination TransactionTypeDetermination Transaction Key
KEY TaxItem TaxItem Tax Item
KEY TaxBox TaxBox Tax.Bs.Gp.No.
KEY TaxDeclnAmountType TaxDeclnAmountType
KEY TaxItemGroupingVersion TaxItemGroupingVersion Tax Grping Ver.
KEY DebitCreditCode DebitCreditCode Single-Character Flag
VATRegistration VATRegistration VAT Registration No.
PostingDate PostingDate Posting Date for GR
ReportingDate ReportingDate
FinancialAccountType FinancialAccountType Fin. Account Type
TaxType TaxType Tax Type
TaxRate TaxRate Tax Rate
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency Local Crcy Amt
DocumentItemText DocumentItemText Text
MaterialName MaterialName Material Description
CashDiscountIsDeductible CashDiscountIsDeductible Cash Discount
Quantity Value
ReportingCountry ReportingCountry
BaseUnit BaseUnit Unit of Measure
RecordType RecordType Reservation Record Type
ClassGroup ClassGroup
BusinessPartnerName BusinessPartnerName Extracted Customer Name
Customer Customer Sold-to Party
Supplier Supplier Supplier

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_ZA_StRpRevenueExpenseLineQry.
-- 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: CSRZARVEXLINEQ

CREATE VIEW C_ZA_StRpRevenueExpenseLineQry AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxCode,
  TransactionTypeDetermination,
  TaxItem,
  TaxBox,
  TaxDeclnAmountType,
  TaxItemGroupingVersion,
  DebitCreditCode,
  VATRegistration,
  PostingDate,
  ReportingDate,
  FinancialAccountType,
  TaxType,
  TaxRate,
  CompanyCodeCurrency,
  cast (AmountInCompanyCodeCurrency as abap.dec(28,7)) AS AmountInCompanyCodeCurrency,
  DocumentItemText,
  MaterialName,
  CashDiscountIsDeductible,
  cast(Quantity as abap.dec(20,7)) AS Quantity,
  ReportingCountry,
  BaseUnit,
  RecordType,
  ClassGroup,
  BusinessPartnerName,
  Customer,
  Supplier
;

Learn More