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

C_StRpDocItemWthTxCodeGrouping

DDL: C_STRPDOCITEMWTHTXCODEGROUPING SQL: CSRDOCITMTCGRPG Type: view CONSUMPTION
102 Fields 2 Data Sources

Tax Item Grouping Based on Tax Code

C_StRpDocItemWthTxCodeGrouping is a Consumption CDS View that provides data about "Tax Item Grouping Based on Tax Code" in SAP S/4HANA. It reads from 2 data sources (C_StRpDocItmGrpgWithDocType, I_StRpTaxItemGrouping) and exposes 102 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, FiscalYear.

Data Sources (2)

SourceAliasJoin Type
C_StRpDocItmGrpgWithDocType C_StRpDocItmGrpgWithDocType from
I_StRpTaxItemGrouping I_StRpTaxItemGrouping left_outer

Parameters (4)

NameTypeDefault
P_Country land1_gp
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_StRpTaxItemGrpgWithDocType> view
AbapCatalog.sqlViewName CSRDOCITMTCGRPG 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 Grouping Based on Tax Code view

Fields (102)

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 C_StRpDocItmGrpgWithDocType TaxCode Tax Code
KEY TransactionTypeDetermination C_StRpDocItmGrpgWithDocType TransactionTypeDetermination Transaction Key
KEY TaxBox C_StRpDocItmGrpgWithDocType TaxBox Tax.Bs.Gp.No.
KEY TaxItemGroupingVersion C_StRpDocItmGrpgWithDocType TaxItemGroupingVersion Tax Grping Ver.
TaxDeclnAmountType C_StRpDocItmGrpgWithDocType TaxDeclnAmountType
SupplierInvoice SupplierInvoice
SupplierInvoiceItem SupplierInvoiceItem
BillingDocument BillingDocument SD Document
BillingDocumentItem BillingDocumentItem Item
TaxItemGroup TaxItemGroup Tax doc. item number
TaxType C_StRpDocItmGrpgWithDocType TaxType Tax Type
AccountingDocumentType C_StRpDocItmGrpgWithDocType AccountingDocumentType Journal Entry Type
AccountingDocumentItemType AccountingDocumentItemType Line Item ID
ReferenceDocumentType ReferenceDocumentType Reference Document Type
PostingKey PostingKey Posting Key
DebitCreditCode C_StRpDocItmGrpgWithDocType 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 _UnitOfMeasure UnitOfMeasure_E
TaxRate TaxRate Tax Rate
OriginalReferenceDocument OriginalReferenceDocument Reference Key
BusinessArea BusinessArea Business Area
Supplier Supplier Supplier
Customer Customer Sold-to Party
TaxNumber1 TaxNumber1 VAT Reg. No.
TaxNumber2 TaxNumber2 Tax Number 2
TaxNumber3 TaxNumber3
MobileNumber
ProductDescription
BusinessPartnerName BusinessPartnerName Extracted Customer Name
CustomerSupplierAddress CustomerSupplierAddress
SupplierAccountGroup C_StRpDocItmGrpgWithDocType SupplierAccountGroup Account group
ReportingCountry ReportingCountry
BusinessPartnerCountry C_StRpDocItmGrpgWithDocType BusinessPartnerCountry BP Ctry/Reg.
BusinessPartner C_StRpDocItmGrpgWithDocType BusinessPartner Issuing Authority
LegalEntityOfOrganization C_StRpDocItmGrpgWithDocType LegalEntityOfOrganization Legal entity
IsNaturalPerson C_StRpDocItmGrpgWithDocType IsNaturalPerson Natural person
IsPrivate C_StRpDocItmGrpgWithDocType IsPrivate Private Hierarchy
TaxGroupFreeClassification C_StRpDocItmGrpgWithDocType TaxGroupFreeClassification
IsTimeDependent C_StRpDocItmGrpgWithDocType IsTimeDependent
TaxBoxConfiguration C_StRpDocItmGrpgWithDocType TaxBoxConfiguration
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
Country I_StRpTaxItemGrouping Country Venue: Ctry/Reg
CashDiscountBaseAmount C_StRpDocItmGrpgWithDocType CashDiscountBaseAmount Cash Dscnt Base Amt
CashDiscountAmount C_StRpDocItmGrpgWithDocType CashDiscountAmount CD Amount
TaxRateValidityStartDate C_StRpDocItmGrpgWithDocType TaxRateValidityStartDate Tax Rate Validity Start Date
TaxBoxStrucValidityStartDate C_StRpDocItmGrpgWithDocType TaxBoxStrucValidityStartDate Vers.Valid From
TaxBoxStrucValidityEndDate C_StRpDocItmGrpgWithDocType TaxBoxStrucValidityEndDate Vers.Valid To
DocumentReferenceID C_StRpDocItmGrpgWithDocType DocumentReferenceID Reference
_Supplier _Supplier
_Customer _Customer
_Product _Product
_ProductText _ProductText

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_StRpDocItemWthTxCodeGrouping.
-- 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: CSRDOCITMTCGRPG
-- Parameters: P_Country : land1_gp, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW C_StRpDocItemWthTxCodeGrouping AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentItem,
  DocumentItemNumber,
  C_StRpDocItmGrpgWithDocType.TaxCode AS TaxCode,
  C_StRpDocItmGrpgWithDocType.TransactionTypeDetermination AS TransactionTypeDetermination,
  C_StRpDocItmGrpgWithDocType.TaxBox AS TaxBox,
  C_StRpDocItmGrpgWithDocType.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  C_StRpDocItmGrpgWithDocType.TaxDeclnAmountType AS TaxDeclnAmountType,
  SupplierInvoice,
  SupplierInvoiceItem,
  BillingDocument,
  BillingDocumentItem,
  TaxItemGroup,
  C_StRpDocItmGrpgWithDocType.TaxType AS TaxType,
  C_StRpDocItmGrpgWithDocType.AccountingDocumentType AS AccountingDocumentType,
  AccountingDocumentItemType,
  ReferenceDocumentType,
  PostingKey,
  C_StRpDocItmGrpgWithDocType.DebitCreditCode AS DebitCreditCode,
  GLAccount,
  FinancialAccountType,
  AccountType,
  FiscalPeriod,
  ReportingDate,
  PostingDate,
  DocumentDate,
  Material,
  DocumentItemText,
  QuantityInActlPostg,
  QuantityUnit,
  _UnitOfMeasure.UnitOfMeasure_E AS UnitOfMeasureISOCode,
  TaxRate,
  OriginalReferenceDocument,
  BusinessArea,
  Supplier,
  Customer,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  coalesce(_Supplier._AddressRepresentation._PhoneNumber.PhoneAreaCodeSubscriberNumber, _Customer._AddressRepresentation._PhoneNumber.PhoneAreaCodeSubscriberNumber) AS MobileNumber,
  coalesce(_ProductText[1:Language = $session.system_language].ProductDescription,DocumentItemText) AS ProductDescription,
  BusinessPartnerName,
  CustomerSupplierAddress,
  C_StRpDocItmGrpgWithDocType.SupplierAccountGroup AS SupplierAccountGroup,
  ReportingCountry,
  C_StRpDocItmGrpgWithDocType.BusinessPartnerCountry AS BusinessPartnerCountry,
  C_StRpDocItmGrpgWithDocType.BusinessPartner AS BusinessPartner,
  C_StRpDocItmGrpgWithDocType.LegalEntityOfOrganization AS LegalEntityOfOrganization,
  C_StRpDocItmGrpgWithDocType.IsNaturalPerson AS IsNaturalPerson,
  C_StRpDocItmGrpgWithDocType.IsPrivate AS IsPrivate,
  C_StRpDocItmGrpgWithDocType.TaxGroupFreeClassification AS TaxGroupFreeClassification,
  C_StRpDocItmGrpgWithDocType.IsTimeDependent AS IsTimeDependent,
  C_StRpDocItmGrpgWithDocType.TaxBoxConfiguration AS TaxBoxConfiguration,
  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,
  I_StRpTaxItemGrouping.Country AS Country,
  C_StRpDocItmGrpgWithDocType.CashDiscountBaseAmount AS CashDiscountBaseAmount,
  C_StRpDocItmGrpgWithDocType.CashDiscountAmount AS CashDiscountAmount,
  C_StRpDocItmGrpgWithDocType.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  C_StRpDocItmGrpgWithDocType.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  C_StRpDocItmGrpgWithDocType.TaxBoxStrucValidityEndDate AS TaxBoxStrucValidityEndDate,
  C_StRpDocItmGrpgWithDocType.DocumentReferenceID AS DocumentReferenceID
FROM C_StRpDocItmGrpgWithDocType
LEFT OUTER JOIN I_StRpTaxItemGrouping ON /* join condition not captured in parsed metadata */
;

Learn More