Deprecated
This CDS view is deprecated in S/4HANA. Use <P_EG_StRpTaxItmWithTxCodeGrpg> instead. View all deprecated CDS views →

C_EG_StRpDocItmWthAdjustedGrpg

DDL: C_EG_STRPDOCITMWTHADJUSTEDGRPG SQL: CEGSRDOCITMAGRPG Type: view CONSUMPTION
101 Fields 1 Data Sources

Tax Item With Adjustment Grouping for Statutory Reporting

C_EG_StRpDocItmWthAdjustedGrpg is a Consumption CDS View that provides data about "Tax Item With Adjustment Grouping for Statutory Reporting" in SAP S/4HANA. It reads from 1 data source (C_StRpDocItemWthTxCodeGrouping) and exposes 101 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, FiscalYear.

Data Sources (1)

SourceAliasJoin Type
C_StRpDocItemWthTxCodeGrouping C_StRpDocItemWthTxCodeGrouping from

Parameters (5)

NameTypeDefault
P_TaxReportingFromDate vatdate
P_AdjustmentDocumentIsDerived glo_derive_adjustment
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id

Annotations (13)

NameValueLevelField
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor <P_EG_StRpTaxItmWithTxCodeGrpg> view
AbapCatalog.sqlViewName CEGSRDOCITMAGRPG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
AbapCatalog.preserveKey true view
EndUserText.label Tax Item With Adjustment Grouping for Statutory Reporting view

Fields (101)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity StatryRptgEntity Reporting Entity
KEY StatryRptCategory StatryRptCategory Report ID
KEY StatryRptRunID StatryRptRunID Report Run ID
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
KEY DocumentItemNumber DocumentItemNumber Item
KEY TaxCode TaxCode Tax Code
KEY TransactionTypeDetermination TransactionTypeDetermination Transaction Key
KEY TaxItemGroupingVersion TaxItemGroupingVersion Tax Grping Ver.
EG_TaxType
EG_ScheduleTaxType
EG_DocumentItemNature
EG_DocumentItemType
TaxDeclnAmountType TaxDeclnAmountType
SupplierInvoice SupplierInvoice
SupplierInvoiceItem SupplierInvoiceItem
BillingDocument BillingDocument SD Document
BillingDocumentItem BillingDocumentItem Item
TaxTypeendasTaxType
TaxItemGroup TaxItemGroup Tax doc. item number
AccountingDocumentType AccountingDocumentType Journal Entry Type
AccountingDocumentItemType AccountingDocumentItemType Line Item ID
ReferenceDocumentType ReferenceDocumentType Reference Document Type
PostingKey PostingKey Posting Key
DebitCreditCode DebitCreditCode Single-Character Flag
GLAccount GLAccount General Ledger
FinancialAccountType FinancialAccountType Fin. Account Type
AccountType AccountType Accounting Type(dtl)
FiscalPeriod FiscalPeriod Tax period
ReportingDate ReportingDate
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
Material Material Vehicle Model
DocumentItemText DocumentItemText Text
QuantityInActlPostg QuantityInActlPostg
QuantityUnit QuantityUnit Unit of measure
UnitOfMeasureISOCode UnitOfMeasureISOCode
TaxRate TaxRate Tax Rate
OriginalReferenceDocument OriginalReferenceDocument Reference Key
BusinessArea BusinessArea Business Area
Supplier Supplier Supplier
Customer Customer Sold-to Party
BusinessPartnerName BusinessPartnerName Extracted Customer Name
TaxNumber1 TaxNumber1 VAT Reg. No.
TaxNumber2 TaxNumber2 Tax Number 2
TaxNumber3 TaxNumber3
MobileNumber MobileNumber Telephone
ProductDescription ProductDescription Description
CustomerSupplierAddress CustomerSupplierAddress
SupplierAccountGroup SupplierAccountGroup Account group
ReportingCountry ReportingCountry
BusinessPartnerCountry C_StRpDocItemWthTxCodeGrouping BusinessPartnerCountry BP Ctry/Reg.
BusinessPartner C_StRpDocItemWthTxCodeGrouping BusinessPartner Issuing Authority
LegalEntityOfOrganization C_StRpDocItemWthTxCodeGrouping LegalEntityOfOrganization Legal entity
IsNaturalPerson C_StRpDocItemWthTxCodeGrouping IsNaturalPerson Natural person
IsPrivate C_StRpDocItemWthTxCodeGrouping IsPrivate Private Hierarchy
TaxGroupFreeClassification C_StRpDocItemWthTxCodeGrouping TaxGroupFreeClassification
IsTimeDependent C_StRpDocItemWthTxCodeGrouping IsTimeDependent
TaxBoxConfiguration C_StRpDocItemWthTxCodeGrouping TaxBoxConfiguration
VATRegistration TaxNum1 BPTaxNumber Tax Number
NationalIDNumber
ReverseDocument ReverseDocument Reversed With
ReverseDocumentFiscalYear ReverseDocumentFiscalYear Year
InvoiceReference InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
ReferenceDocumentNumber ReferenceDocumentNumber
ReferenceDocumentFiscalYear ReferenceDocumentFiscalYear Year Cur.Period
RefAccountingDocument RefAccountingDocument Document Number
RefAccountingDocumentPostgDate RefAccountingDocumentPostgDate
DocumentCurrency DocumentCurrency Document Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
ReportingCurrency ReportingCurrency Currency
CountryCurrency CountryCurrency Currency
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
DistributedTaxAmountInCCrcy DistributedTaxAmountInCCrcy
DistrdTaxBaseAmountInCCrcy DistrdTaxBaseAmountInCCrcy
DistributedTaxAmountInTC DistributedTaxAmountInTC
DistrdTaxBaseAmountInTransCrcy DistrdTaxBaseAmountInTransCrcy
DistributedTaxAmtInCountryCrcy DistributedTaxAmtInCountryCrcy
DistrdTaxBaseAmountInCntryCrcy DistrdTaxBaseAmountInCntryCrcy
AmountInReportingCurrency AmountInReportingCurrency
TaxBaseAmountInRptgCrcy TaxBaseAmountInRptgCrcy Base Amount
TaxAmountInRptgCrcy TaxAmountInRptgCrcy Tax Rept. Crcy
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy Value-Added Tax
TaxAmount TaxAmount Tax Amt in Rptg Crcy
TaxBaseAmountInCountryCrcy TaxBaseAmountInCountryCrcy Base Amount
TaxAmountInCountryCrcy TaxAmountInCountryCrcy Tax Rept. Crcy
TaxBaseAmtInAdditionalCrcy1 TaxBaseAmtInAdditionalCrcy1 LC 2 Base
TaxAmountInAdditionalCurrency1 TaxAmountInAdditionalCurrency1 LC 2 Tax
TaxBaseAmtInAdditionalCrcy2 TaxBaseAmtInAdditionalCrcy2 LC 3 Base
TaxAmountInAdditionalCurrency2 TaxAmountInAdditionalCurrency2 LC 3 Tax
ItemIsReportingRelevant ItemIsReportingRelevant Item Reporting Relv
CashDiscountAmount CashDiscountAmount CD Amount
TaxRateValidityStartDate C_StRpDocItemWthTxCodeGrouping TaxRateValidityStartDate Tax Rate Validity Start Date
TaxBoxStrucValidityStartDate C_StRpDocItemWthTxCodeGrouping TaxBoxStrucValidityStartDate
TaxBoxStrucValidityEndDate C_StRpDocItemWthTxCodeGrouping TaxBoxStrucValidityEndDate

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_EG_StRpDocItmWthAdjustedGrpg.
-- 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: CEGSRDOCITMAGRPG
-- Parameters: P_TaxReportingFromDate : vatdate, P_AdjustmentDocumentIsDerived : glo_derive_adjustment, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW C_EG_StRpDocItmWthAdjustedGrpg AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentItem,
  DocumentItemNumber,
  TaxCode,
  TransactionTypeDetermination,
  TaxItemGroupingVersion,
  cast( substring( TaxGroupFreeClassification, 1, 1 ) as fieg_tax_type ) AS EG_TaxType,
  cast( substring( TaxGroupFreeClassification, 2, 1 ) as fieg_schedule_tax_type ) AS EG_ScheduleTaxType,
  cast( substring( TaxGroupFreeClassification, 3, 1 ) as fieg_doc_item_nature ) AS EG_DocumentItemNature,
  cast( substring( TaxGroupFreeClassification, 4, 2 ) as fieg_doc_item_type ) AS EG_DocumentItemType,
  TaxDeclnAmountType,
  SupplierInvoice,
  SupplierInvoiceItem,
  BillingDocument,
  BillingDocumentItem,
  case when TransactionTypeDetermination = 'ESA' then 'A' when TransactionTypeDetermination = 'ESE' then 'V' else C_StRpDocItemWthTxCodeGrouping.TaxType end as TaxType AS TaxTypeendasTaxType,
  TaxItemGroup,
  AccountingDocumentType,
  AccountingDocumentItemType,
  ReferenceDocumentType,
  PostingKey,
  DebitCreditCode,
  GLAccount,
  FinancialAccountType,
  AccountType,
  FiscalPeriod,
  ReportingDate,
  PostingDate,
  DocumentDate,
  Material,
  DocumentItemText,
  QuantityInActlPostg,
  QuantityUnit,
  UnitOfMeasureISOCode,
  TaxRate,
  OriginalReferenceDocument,
  BusinessArea,
  Supplier,
  Customer,
  BusinessPartnerName,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  MobileNumber,
  ProductDescription,
  CustomerSupplierAddress,
  SupplierAccountGroup,
  ReportingCountry,
  C_StRpDocItemWthTxCodeGrouping.BusinessPartnerCountry AS BusinessPartnerCountry,
  C_StRpDocItemWthTxCodeGrouping.BusinessPartner AS BusinessPartner,
  C_StRpDocItemWthTxCodeGrouping.LegalEntityOfOrganization AS LegalEntityOfOrganization,
  C_StRpDocItemWthTxCodeGrouping.IsNaturalPerson AS IsNaturalPerson,
  C_StRpDocItemWthTxCodeGrouping.IsPrivate AS IsPrivate,
  C_StRpDocItemWthTxCodeGrouping.TaxGroupFreeClassification AS TaxGroupFreeClassification,
  C_StRpDocItemWthTxCodeGrouping.IsTimeDependent AS IsTimeDependent,
  C_StRpDocItemWthTxCodeGrouping.TaxBoxConfiguration AS TaxBoxConfiguration,
  TaxNum1.BPTaxNumber AS VATRegistration,
  cast( coalesce( TaxNum2.BPTaxNumber, TaxNum3.BPIdentificationNumber) as figlo_national_id ) AS NationalIDNumber,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  ReferenceDocumentNumber,
  ReferenceDocumentFiscalYear,
  RefAccountingDocument,
  RefAccountingDocumentPostgDate,
  DocumentCurrency,
  CompanyCodeCurrency,
  ReportingCurrency,
  CountryCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  DistributedTaxAmountInCCrcy,
  DistrdTaxBaseAmountInCCrcy,
  DistributedTaxAmountInTC,
  DistrdTaxBaseAmountInTransCrcy,
  DistributedTaxAmtInCountryCrcy,
  DistrdTaxBaseAmountInCntryCrcy,
  AmountInReportingCurrency,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmount,
  TaxBaseAmountInCountryCrcy,
  TaxAmountInCountryCrcy,
  TaxBaseAmtInAdditionalCrcy1,
  TaxAmountInAdditionalCurrency1,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency2,
  ItemIsReportingRelevant,
  CashDiscountAmount,
  C_StRpDocItemWthTxCodeGrouping.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  C_StRpDocItemWthTxCodeGrouping.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  C_StRpDocItemWthTxCodeGrouping.TaxBoxStrucValidityEndDate AS TaxBoxStrucValidityEndDate
FROM C_StRpDocItemWthTxCodeGrouping
;

Learn More