C_StRpDocItmGrpgWithDocType

DDL: C_STRPDOCITMGRPGWITHDOCTYPE SQL: CSRDOCITMGRPGDT Type: view CONSUMPTION
99 Fields 2 Data Sources 1 Associations

Tax Item Grouping Based on Accounting Document Type

C_StRpDocItmGrpgWithDocType is a Consumption CDS View that provides data about "Tax Item Grouping Based on Accounting Document Type" in SAP S/4HANA. It reads from 2 data sources (C_StRpDocItemGrpgWthVndrAcct, I_StRpTaxItemGrouping) and exposes 99 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, FiscalYear. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
C_StRpDocItemGrpgWthVndrAcct C_StRpDocItemGrpgWthVndrAcct 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

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_UnitOfMeasure _UnitOfMeasure _UnitOfMeasure.UnitOfMeasure = $projection.QuantityUnit

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSRDOCITMGRPGDT 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 Accounting Document Type view

Fields (99)

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

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_StRpDocItmGrpgWithDocType.
-- 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: CSRDOCITMGRPGDT
-- 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_StRpDocItmGrpgWithDocType AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentItem,
  DocumentItemNumber,
  C_StRpDocItemGrpgWthVndrAcct.TaxCode AS TaxCode,
  C_StRpDocItemGrpgWthVndrAcct.TransactionTypeDetermination AS TransactionTypeDetermination,
  C_StRpDocItemGrpgWthVndrAcct.TaxBox AS TaxBox,
  C_StRpDocItemGrpgWthVndrAcct.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  C_StRpDocItemGrpgWthVndrAcct.TaxDeclnAmountType AS TaxDeclnAmountType,
  SupplierInvoice,
  SupplierInvoiceItem,
  BillingDocument,
  BillingDocumentItem,
  TaxItemGroup,
  C_StRpDocItemGrpgWthVndrAcct.TaxType AS TaxType,
  C_StRpDocItemGrpgWthVndrAcct.AccountingDocumentType AS AccountingDocumentType,
  AccountingDocumentItemType,
  ReferenceDocumentType,
  PostingKey,
  C_StRpDocItemGrpgWthVndrAcct.DebitCreditCode AS DebitCreditCode,
  GLAccount,
  FinancialAccountType,
  AccountType,
  FiscalPeriod,
  ReportingDate,
  PostingDate,
  DocumentDate,
  Material,
  DocumentItemText,
  QuantityInActlPostg,
  QuantityUnit,
  TaxRate,
  OriginalReferenceDocument,
  BusinessArea,
  Supplier,
  Customer,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  BusinessPartnerName,
  CustomerSupplierAddress,
  C_StRpDocItemGrpgWthVndrAcct.SupplierAccountGroup AS SupplierAccountGroup,
  ReportingCountry,
  C_StRpDocItemGrpgWthVndrAcct.BusinessPartnerCountry AS BusinessPartnerCountry,
  C_StRpDocItemGrpgWthVndrAcct.BusinessPartner AS BusinessPartner,
  C_StRpDocItemGrpgWthVndrAcct.LegalEntityOfOrganization AS LegalEntityOfOrganization,
  C_StRpDocItemGrpgWthVndrAcct.IsNaturalPerson AS IsNaturalPerson,
  C_StRpDocItemGrpgWthVndrAcct.IsPrivate AS IsPrivate,
  C_StRpDocItemGrpgWthVndrAcct.TaxGroupFreeClassification AS TaxGroupFreeClassification,
  C_StRpDocItemGrpgWthVndrAcct.IsTimeDependent AS IsTimeDependent,
  C_StRpDocItemGrpgWthVndrAcct.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,
  C_StRpDocItemGrpgWthVndrAcct.CashDiscountBaseAmount AS CashDiscountBaseAmount,
  C_StRpDocItemGrpgWthVndrAcct.CashDiscountAmount AS CashDiscountAmount,
  C_StRpDocItemGrpgWthVndrAcct.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  C_StRpDocItemGrpgWthVndrAcct.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  C_StRpDocItemGrpgWthVndrAcct.TaxBoxStrucValidityEndDate AS TaxBoxStrucValidityEndDate,
  C_StRpDocItemGrpgWthVndrAcct.DocumentReferenceID AS DocumentReferenceID
FROM C_StRpDocItemGrpgWthVndrAcct
LEFT OUTER JOIN I_StRpTaxItemGrouping ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = QuantityUnit  -- association [1..1]
;

Learn More