C_US_TxPartTxJurisdictionLevel

DDL: C_US_TXPARTTXJURISDICTIONLEVEL SQL: CUSTXPRTTXJXLVL Type: view_entity CONSUMPTION
30 Fields 1 Data Sources 1 Associations 2 OData Services

US Tax Partner Tax Jurisdiction Level

C_US_TxPartTxJurisdictionLevel is a Consumption CDS View that provides data about "US Tax Partner Tax Jurisdiction Level" in SAP S/4HANA. It reads from 1 data source (R_US_TxPartTxJurisdictionLevel) and exposes 30 fields with key fields US_TaxPartnerTaxDocument, US_TaxPartnerTaxDocumentItem, TaxJurisdictionLevel. It has 1 association to related views. It is exposed through 2 OData services (FAC_ETXDOCUMENT_DISPLAY_SRV, FAC_F4782_SRV).

Data Sources (1)

SourceAliasJoin Type
R_US_TxPartTxJurisdictionLevel R_US_TxPartTxJurisdictionLevel projection

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label US Tax Partner Tax Jurisdiction Level view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

OData Services (2)

ServiceBindingVersionContractRelease
FAC_ETXDOCUMENT_DISPLAY_SRV
FAC_F4782_SRV F4782_SERVICE_BINDING V2 C1 NOT_RELEASED

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY US_TaxPartnerTaxDocument US_TaxPartnerTaxDocument Tax Document Number
KEY US_TaxPartnerTaxDocumentItem US_TaxPartnerTaxDocumentItem Item Number
KEY TaxJurisdictionLevel TaxJurisdictionLevel Jurisdiction Level
US_TaxState US_TaxState
UnitedStatesTaxSourcing UnitedStatesTaxSourcing
DebitCreditCode DebitCreditCode Single-Character Flag
TaxJurisdictionText TaxJurisdictionText
UserInputTaxRate UserInputTaxRate G/L Tax Rate%
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy G/L Tax Amount
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy G/L Tax Base Amount
TaxAmountInTransCrcy TaxAmountInTransCrcy Tax Amount
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy Tax Base Amount
TaxExemptionAmount TaxExemptionAmount Exempt Amount
TaxRate TaxRate Tax Rate%
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
GLAccount GLAccount General Ledger
CompanyCodeCurrency CompanyCodeCurrency Local Currency
TransactionCurrency TransactionCurrency Transaction Currency
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName CompanyCodeName Company Name
DebitCreditCodeName DebitCreditCodeName
GLAccountName GLAccountName Short Text
US_TaxStateName US_TaxStateName Tax State Name
UnitedStatesTaxSourcingName UnitedStatesTaxSourcingName Tax Sourcing Name
_TaxDoc _TaxDoc
_GLAccount _GLAccount
_CompanyCode _CompanyCode
_DebitCreditCode _DebitCreditCode
_State _State
_Sourcing _Sourcing

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_US_TxPartTxJurisdictionLevel.
-- 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: CUSTXPRTTXJXLVL

CREATE VIEW C_US_TxPartTxJurisdictionLevel AS
SELECT
  US_TaxPartnerTaxDocument,
  US_TaxPartnerTaxDocumentItem,
  TaxJurisdictionLevel,
  US_TaxState,
  UnitedStatesTaxSourcing,
  DebitCreditCode,
  TaxJurisdictionText,
  UserInputTaxRate,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInTransCrcy,
  TaxBaseAmountInTransCrcy,
  TaxExemptionAmount,
  TaxRate,
  TaxJurisdiction,
  GLAccount,
  CompanyCodeCurrency,
  TransactionCurrency,
  CompanyCode,
  CompanyCodeName,
  DebitCreditCodeName,
  GLAccountName,
  US_TaxStateName,
  UnitedStatesTaxSourcingName
FROM R_US_TxPartTxJurisdictionLevel
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;

Learn More