What is C_US_TaxPartnerTaxDocumentItem in SAP S/4HANA?

C_US_TaxPartnerTaxDocumentItem is a consumption CDS view in SAP S/4HANA. US Tax Partner Tax Document Item It contains 113 fields.

Which tables does C_US_TaxPartnerTaxDocumentItem read from?

C_US_TaxPartnerTaxDocumentItem reads data from: R_US_TaxPartnerTaxDocumentItem.

What VDM layer is C_US_TaxPartnerTaxDocumentItem?

C_US_TaxPartnerTaxDocumentItem is classified as a Consumption view optimized for specific business scenarios and reporting.

C_US_TaxPartnerTaxDocumentItem

DDL: C_US_TAXPARTNERTAXDOCUMENTITEM SQL: CUSTXPARTDOCITM Type: view_entity CONSUMPTION Package: ODATA_TAX_DOCUMENT_DISPLAY

113 Fields 1 Data Sources 5 Associations 3 OData Services

US Tax Partner Tax Document Item

C_US_TaxPartnerTaxDocumentItem is a Consumption CDS View that provides data about "US Tax Partner Tax Document Item" in SAP S/4HANA. It reads from 1 data source (R_US_TaxPartnerTaxDocumentItem) and exposes 113 fields with key fields US_TaxPartnerTaxDocument, US_TaxPartnerTaxDocumentItem, US_TaxState. It has 5 associations to related views. It is exposed through 3 OData services (ASQL_F4782, FAC_ETXDOCUMENT_DISPLAY_SRV, FAC_F4782_SRV). Part of development package ODATA_TAX_DOCUMENT_DISPLAY.

Data Sources (1)

Source	Alias	Join Type
R_US_TaxPartnerTaxDocumentItem	R_US_TaxPartnerTaxDocumentItem	projection

Associations (5)

Cardinality	Target	Alias	Condition
[1..1]	C_US_TaxPartnerTaxDocument	_TaxOverview	`$projection.US_TaxPartnerTaxDocument = _TaxOverview.US_TaxPartnerTaxDocument and $projection.US_TaxPartnerTaxDocumentItem = _TaxOverview.US_TaxPartnerTaxDocumentItem and $projection.US_TaxState = _TaxOverview.US_TaxState`
[1..*]	C_US_TxPartTxJurisdictionLevel	_Jurisdiction	`$projection.US_TaxPartnerTaxDocument = _Jurisdiction.US_TaxPartnerTaxDocument and $projection.US_TaxPartnerTaxDocumentItem = _Jurisdiction.US_TaxPartnerTaxDocumentItem`
[0..1]	I_CompanyCode	_CompanyCode	`$projection.CompanyCode = _CompanyCode.CompanyCode`
[1..1]	I_DebitCreditCode	_DebitCreditCode	`$projection.DebitCreditCode = _DebitCreditCode.DebitCreditCode`
[0..1]	I_US_TaxState	_State	`$projection.US_TaxState = _State.US_TaxState`

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	US Tax Partner Tax Document Item	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	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 (3)

Service	Binding	Version	Contract	Release
ASQL_F4782	ASQL_F4782		C2	NOT_RELEASED
FAC_ETXDOCUMENT_DISPLAY_SRV
FAC_F4782_SRV	F4782_SERVICE_BINDING	V2	C1	NOT_TO_BE_RELEASED_STABLE

Fields (113)

Key	Field	Source Field	Description
KEY	US_TaxPartnerTaxDocument	US_TaxPartnerTaxDocument	Tax Document Number
KEY	US_TaxPartnerTaxDocumentItem	US_TaxPartnerTaxDocumentItem	Item Number
KEY	US_TaxState	US_TaxState
	ShipToParty	ShipToParty	Ship-To Party (obsolete)
	SoldToParty	SoldToParty	Sold-to Party
	MaterialGroup	MaterialGroup	Product Group
	TaxCalculationDate	TaxCalculationDate	Tax Date as Returned by Partner
	US_TaxPartnerReceivedTaxDate	US_TaxPartnerReceivedTaxDate	Tax Date as Sent to Partner
	PostingDate	PostingDate	Posting Date as Sent to Partner
	DocumentDate	DocumentDate	Document Date as Sent to Partner
	ServicesRenderedDate	ServicesRenderedDate	Serv. Render Date as Sent to Partner
	TaxCode	TaxCode	Tax Code
	CostCenter	CostCenter	Cost Center
	TaxBaseAmountInTransCrcy	TaxBaseAmountInTransCrcy	Tax Base Amount
	TaxBaseAmountInCoCodeCrcy	TaxBaseAmountInCoCodeCrcy	Tax Base Amt in CoCode Crcy
	DebitCreditCode	DebitCreditCode	Single-Character Flag
	ShipFromAddressTaxJurisdiction	ShipFromAddressTaxJurisdiction	Jurisdiction Code "Ship-from"
	ShipToAddressTaxJurisdiction	ShipToAddressTaxJurisdiction	Jurisdiction Code "Ship-to"
	PointOfOrderAcceptanceTxJx	PointOfOrderAcceptanceTxJx	Jur. Code "Point of Order Acceptance"
	PointOfOrderOriginTxJx	PointOfOrderOriginTxJx	Jur. Code "Point of Order Origin"
	BillToParty	BillToParty	Inv. Recipient
	TaxDepartureCountry	TaxDepartureCountry	Tx Dep Ctry/Reg
	WBSElementExternalID	WBSElementExternalID	WBS Element External ID
	PurchasingDocument	PurchasingDocument	Purchasing Document
	SDDocumentCategory	SDDocumentCategory	Sales Document Category
	SDDocument	SDDocument	Sales Document
	SalesMeasureUnit	SalesMeasureUnit	Sales unit
	MainItemPricingRefMaterial	MainItemPricingRefMaterial
	TaxType	TaxType	Tax Type
	FreightAmount	FreightAmount
	TaxAmountInCoCodeCrcy	TaxAmountInCoCodeCrcy	G/L Tax Amount
	UserInputTaxRate	UserInputTaxRate	G/L Tax Rate%
	TaxAmountInTransCrcy	TaxAmountInTransCrcy	Tax Amount
	TaxRate	TaxRate	Tax Rate%
	CompanyCodeCurrency	CompanyCodeCurrency	Local Currency
	TransactionCurrency	TransactionCurrency	Transaction Currency
	TaxCalculationProcedure	TaxCalculationProcedure	Tax Procedure
	CompanyCode	CompanyCode	Receiver Company Code
	US_TaxProduct	US_TaxProduct
	Supplier	Supplier	Supplier
	CompanyCodeName	CompanyCodeName	Company Name
	DebitCreditCodeName	DebitCreditCodeName
	TaxCodeName	TaxCodeName	Tax Code Name
	ProductName	ProductName	Description
	US_TaxStateName	US_TaxStateName	Tax State Name
	BillToPartyName	BillToPartyName	Bill-to Party Name
	SoldToPartyFullName	SoldToPartyFullName	Sold-to Party Name
	ShipToPartyFullName	ShipToPartyFullName	Ship-to Party Name
	SupplierFullName	SupplierFullName	Supplier Name
	WBSDescription	WBSDescription	WBS Element Name
	US_TaxFreeDefinedValue1	US_TaxFreeDefinedValue1
	US_TaxFreeDefinedValue2	US_TaxFreeDefinedValue2
	US_TaxFreeDefinedValue3	US_TaxFreeDefinedValue3
	US_TaxFreeDefinedValue4	US_TaxFreeDefinedValue4
	US_TaxFreeDefinedValue5	US_TaxFreeDefinedValue5
	US_TaxFreeDefinedValue6	US_TaxFreeDefinedValue6
	US_TaxFreeDefinedValue7	US_TaxFreeDefinedValue7
	US_TaxFreeDefinedValue8	US_TaxFreeDefinedValue8
	US_TaxFreeDefinedValue9	US_TaxFreeDefinedValue9
	US_TaxFreeDefinedValue10	US_TaxFreeDefinedValue10
	US_TaxFreeDefinedValue11	US_TaxFreeDefinedValue11
	US_TaxFreeDefinedValue12	US_TaxFreeDefinedValue12
	US_TaxFreeDefinedValue13	US_TaxFreeDefinedValue13
	US_TaxFreeDefinedValue14	US_TaxFreeDefinedValue14
	US_TaxFreeDefinedValue15	US_TaxFreeDefinedValue15
	US_TaxFreeDefinedValue16	US_TaxFreeDefinedValue16
	US_TaxFreeDefinedValue17	US_TaxFreeDefinedValue17
	US_TaxFreeDefinedValue18	US_TaxFreeDefinedValue18
	US_TaxFreeDefinedValue19	US_TaxFreeDefinedValue19
	US_TaxFreeDefinedValue20	US_TaxFreeDefinedValue20
	US_TaxFreeDefinedValue21	US_TaxFreeDefinedValue21
	US_TaxFreeDefinedValue22	US_TaxFreeDefinedValue22
	US_TaxFreeDefinedValue23	US_TaxFreeDefinedValue23
	US_TaxFreeDefinedValue24	US_TaxFreeDefinedValue24
	US_TaxFreeDefinedValue25	US_TaxFreeDefinedValue25
	US_TaxFreeDefinedValue26	US_TaxFreeDefinedValue26
	US_TaxFreeDefinedValue27	US_TaxFreeDefinedValue27
	US_TaxFreeDefinedValue28	US_TaxFreeDefinedValue28
	US_TaxFreeDefinedValue29	US_TaxFreeDefinedValue29
	US_TaxFreeDefinedValue30	US_TaxFreeDefinedValue30
	US_TaxFreeDefinedValue31	US_TaxFreeDefinedValue31
	US_TaxFreeDefinedValue32	US_TaxFreeDefinedValue32
	US_TaxFreeDefinedValue33	US_TaxFreeDefinedValue33
	US_TaxFreeDefinedValue34	US_TaxFreeDefinedValue34
	US_TaxFreeDefinedValue35	US_TaxFreeDefinedValue35
	US_TaxFreeDefinedValue36	US_TaxFreeDefinedValue36
	US_TaxFreeDefinedValue37	US_TaxFreeDefinedValue37
	US_TaxFreeDefinedValue38	US_TaxFreeDefinedValue38
	US_TaxFreeDefinedValue39	US_TaxFreeDefinedValue39
	US_TaxFreeDefinedValue40	US_TaxFreeDefinedValue40
	US_TaxFreeDefinedValue41	US_TaxFreeDefinedValue41
	US_TaxFreeDefinedValue42	US_TaxFreeDefinedValue42
	US_TaxFreeDefinedValue43	US_TaxFreeDefinedValue43
	US_TaxFreeDefinedValue44	US_TaxFreeDefinedValue44
	US_TaxFreeDefinedValue45	US_TaxFreeDefinedValue45
	US_TaxFreeDefinedValue46	US_TaxFreeDefinedValue46
	US_TaxFreeDefinedValue47	US_TaxFreeDefinedValue47
	US_TaxFreeDefinedValue48	US_TaxFreeDefinedValue48
	US_TaxFreeDefinedValue49	US_TaxFreeDefinedValue49
	US_TaxFreeDefinedValue50	US_TaxFreeDefinedValue50
	_TaxType	_TaxType
	_TaxDoc	_TaxDoc
	_TaxCode	_TaxCode
	_CompanyCode	_CompanyCode
	_DebitCreditCode	_DebitCreditCode
	_Product	_Product
	_State	_State
	_BusinessPartner	_BusinessPartner
	_BusinessPartner1	_BusinessPartner1
	_BusinessPartner2	_BusinessPartner2
	_BusinessPartner3	_BusinessPartner3
	_Jurisdiction	_Jurisdiction
	_TaxOverview	_TaxOverview

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_TaxPartnerTaxDocumentItem.
-- 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: CUSTXPARTDOCITM

CREATE VIEW C_US_TaxPartnerTaxDocumentItem AS
SELECT
  US_TaxPartnerTaxDocument,
  US_TaxPartnerTaxDocumentItem,
  US_TaxState,
  ShipToParty,
  SoldToParty,
  MaterialGroup,
  TaxCalculationDate,
  US_TaxPartnerReceivedTaxDate,
  PostingDate,
  DocumentDate,
  ServicesRenderedDate,
  TaxCode,
  CostCenter,
  TaxBaseAmountInTransCrcy,
  TaxBaseAmountInCoCodeCrcy,
  DebitCreditCode,
  ShipFromAddressTaxJurisdiction,
  ShipToAddressTaxJurisdiction,
  PointOfOrderAcceptanceTxJx,
  PointOfOrderOriginTxJx,
  BillToParty,
  TaxDepartureCountry,
  WBSElementExternalID,
  PurchasingDocument,
  SDDocumentCategory,
  SDDocument,
  SalesMeasureUnit,
  MainItemPricingRefMaterial,
  TaxType,
  FreightAmount,
  TaxAmountInCoCodeCrcy,
  UserInputTaxRate,
  TaxAmountInTransCrcy,
  TaxRate,
  CompanyCodeCurrency,
  TransactionCurrency,
  TaxCalculationProcedure,
  CompanyCode,
  US_TaxProduct,
  Supplier,
  CompanyCodeName,
  DebitCreditCodeName,
  TaxCodeName,
  ProductName,
  US_TaxStateName,
  BillToPartyName,
  SoldToPartyFullName,
  ShipToPartyFullName,
  SupplierFullName,
  WBSDescription,
  US_TaxFreeDefinedValue1,
  US_TaxFreeDefinedValue2,
  US_TaxFreeDefinedValue3,
  US_TaxFreeDefinedValue4,
  US_TaxFreeDefinedValue5,
  US_TaxFreeDefinedValue6,
  US_TaxFreeDefinedValue7,
  US_TaxFreeDefinedValue8,
  US_TaxFreeDefinedValue9,
  US_TaxFreeDefinedValue10,
  US_TaxFreeDefinedValue11,
  US_TaxFreeDefinedValue12,
  US_TaxFreeDefinedValue13,
  US_TaxFreeDefinedValue14,
  US_TaxFreeDefinedValue15,
  US_TaxFreeDefinedValue16,
  US_TaxFreeDefinedValue17,
  US_TaxFreeDefinedValue18,
  US_TaxFreeDefinedValue19,
  US_TaxFreeDefinedValue20,
  US_TaxFreeDefinedValue21,
  US_TaxFreeDefinedValue22,
  US_TaxFreeDefinedValue23,
  US_TaxFreeDefinedValue24,
  US_TaxFreeDefinedValue25,
  US_TaxFreeDefinedValue26,
  US_TaxFreeDefinedValue27,
  US_TaxFreeDefinedValue28,
  US_TaxFreeDefinedValue29,
  US_TaxFreeDefinedValue30,
  US_TaxFreeDefinedValue31,
  US_TaxFreeDefinedValue32,
  US_TaxFreeDefinedValue33,
  US_TaxFreeDefinedValue34,
  US_TaxFreeDefinedValue35,
  US_TaxFreeDefinedValue36,
  US_TaxFreeDefinedValue37,
  US_TaxFreeDefinedValue38,
  US_TaxFreeDefinedValue39,
  US_TaxFreeDefinedValue40,
  US_TaxFreeDefinedValue41,
  US_TaxFreeDefinedValue42,
  US_TaxFreeDefinedValue43,
  US_TaxFreeDefinedValue44,
  US_TaxFreeDefinedValue45,
  US_TaxFreeDefinedValue46,
  US_TaxFreeDefinedValue47,
  US_TaxFreeDefinedValue48,
  US_TaxFreeDefinedValue49,
  US_TaxFreeDefinedValue50
FROM R_US_TaxPartnerTaxDocumentItem
LEFT OUTER JOIN C_US_TaxPartnerTaxDocument AS _TaxOverview ON US_TaxPartnerTaxDocument = _TaxOverview.US_TaxPartnerTaxDocument AND US_TaxPartnerTaxDocumentItem = _TaxOverview.US_TaxPartnerTaxDocumentItem AND US_TaxState = _TaxOverview.US_TaxState  -- association [1..1]
LEFT OUTER JOIN C_US_TxPartTxJurisdictionLevel AS _Jurisdiction ON US_TaxPartnerTaxDocument = _Jurisdiction.US_TaxPartnerTaxDocument AND US_TaxPartnerTaxDocumentItem = _Jurisdiction.US_TaxPartnerTaxDocumentItem  -- association [1..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [1..1]
LEFT OUTER JOIN I_US_TaxState AS _State ON US_TaxState = _State.US_TaxState  -- association [0..1]
;

Depth:

C_US_TaxPartnerTaxDocumentItem view_entity

R_US_TaxPartnerTaxDocumentItem view