C_US_TaxPartnerTaxDocItemQuery

Purpose
This CDS view is an analytical query view and contains tax items for the US for parameter P_Language . This CDS view provides the data to answer the following business questions: Which tax items can be used to calculate the tax amount in transaction currency, the tax amount in company code currency, and the tax exemption amount in the US tax partner cube? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Any user who wants to use this CDS view needs to have the same minimum authorizations as the SAP_BR_GL_ACCOUNTANT_US business role template. Users must be assigned the SAP_FIN_BC_GL_TX_DCL_US_PC business catalog, which is predelivered with this role template. This business catalog contains the predeivered restrictions and permissions needed to use this CDS view. Your Administrator can see more information about this busness role template, this business catalog, and these restrictions in the Maintain Business Roles app.

Structure
Parameters The parameters of the CDS view are as follows: P_language : The default value of this parameter is your system language. Fields used for filtering The main filters are as follows. Except where noted, all filters are optinal. AccountingDocument CompanyCode (mandatory) DocumentDate FiscalYear GLAccount MaterialGroup PostingDate PurchasingDocument SDDocument ServicesRenderedDate TaxCalculationDate TaxCode UnitedStatesTaxCategory UnitedStatesTaxSourcing US_TaxPartnerTaxDocument US_TaxPartnerTaxDocumentItem US_TaxState Further important fields Important fields in this view include the following: Field Name Description Measure or Attribute Comment ACCOUNTINGDOCUMENT Accounting document number Attribute COMPANYCODE Company code Attribute COMPANYCODECURRENCY Company code currency Attribute DOCUMENTDATE Document date Attribute FISCALYEAR Fiscal year Attribute US_TAXFREEDEFINEDVALUE1 ~ US_TAXFREEDEFINEDVALUE50 Freely defined fields Attribute GLACCOUNT GL account Attribute MATERIALGROUP Material group Attribute POSTINGDATE Posting date Attribute PRODUCT Product number Attribute PURCHASINGDOCUMENT Purchase document number Attribute SDDOCUMENT Sales order document numbe Attribute SERVICESRENDEREDDATE Service rendered date Attribute TAXAMOUNTINCOCODECRCY Tax amount in company code currency Measure Default calculation formula: SUM TAXAMOUNTINTRANSCRCY Tax amount in transaction currency Measure Default calculation formula: SUM TAXBASEAMOUNTINCOCODECRCY Tax base amount in company code currency Measure Default calculation formula: MAX TAXBASEAMOUNTINTRANSCRCY Tax base amount in transaction currency Measure Default calculation formula: MAX TAXCALCULATIONPROCEDURE Tax calculation procedure Attribute TAXCODE Tax code Attribute TAXEXEMPTIONAMOUNT Tax exemption amount Measure Default calculation formula: MAX TAXJURISDICTION Tax jurisdiction code Attribute TAXJURISDICTIONTEXT Tax jurisdiction code description Attribute TRANSACTIONCURRENCY Transaction currency Attribute UNITEDSTATESTAXCATEGORY US tax category Attribute US_TAXPARTNERTAXDOCUMENTITEM US tax document item number Attribute US_TAXPARTNERTAXDOCUMENT US tax document number Attribute TAXJURISDICTIONLEVEL US tax jurisdiction level number Attribute US_TAXPARTNERRECEIVEDTAXDATE US tax partner received tax date Attribute UNITEDSTATESTAXSOURCING US tax sourcing Attribute US_TAXSTATE US tax state Attribute