P_ExternalTaxAggAmtWithBase

DDL: P_EXTERNALTAXAGGAMTWITHBASE SQL: PAGGAMTWITHBASE Type: view COMPOSITE
31 Fields 1 Data Sources

P_ExternalTaxAggAmtWithBase is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_EXTERNALTAX_AGGITEMANDSTATE) and exposes 31 fields with key fields US_TaxPartnerTaxDocument, US_TaxPartnerTaxDocumentItem.

Data Sources (1)

SourceAliasJoin Type
P_EXTERNALTAX_AGGITEMANDSTATE _Amt from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PAGGAMTWITHBASE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY US_TaxPartnerTaxDocument P_EXTERNALTAX_AGGITEMANDSTATE docnr Well doc.no.
KEY US_TaxPartnerTaxDocumentItem P_EXTERNALTAX_AGGITEMANDSTATE itemnr tax item number
TaxState P_EXTERNALTAX_AGGITEMANDSTATE tax_state Tax State
BillToParty _TaxDocItem BillToParty Inv. Recipient
CostCenter _TaxDocItem CostCenter Cost Center
DebitCreditCode _TaxDocItem DebitCreditCode Single-Character Flag
DocumentDate _TaxDocItem DocumentDate Journal Entry Date
FreightAmount _TaxDocItem FreightAmount
MainItemPricingRefMaterial _TaxDocItem MainItemPricingRefMaterial
MaterialGroup _TaxDocItem MaterialGroup Product Group
PointOfOrderAcceptanceTxJx _TaxDocItem PointOfOrderAcceptanceTxJx
PointOfOrderOriginTxJx _TaxDocItem PointOfOrderOriginTxJx
PurchasingDocument _TaxDocItem PurchasingDocument Purchasing Document
QuantityInBaseUnit _TaxDocItem QuantityInBaseUnit Quantity
SalesMeasureUnit _TaxDocItem SalesMeasureUnit Sales unit
SDDocument _TaxDocItem SDDocument SD Document
SDDocumentCategory _TaxDocItem SDDocumentCategory Document Cat.
ServicesRenderedDate _TaxDocItem ServicesRenderedDate Services Rendered Date
ShipFromAddressTaxJurisdiction _TaxDocItem ShipFromAddressTaxJurisdiction
ShipToParty _TaxDocItem ShipToParty Ship-To Party (obsolete)
ShipToAddressTaxJurisdiction _TaxDocItem ShipToAddressTaxJurisdiction
SoldToParty _TaxDocItem SoldToParty Sold-to Party
TaxCalculationDate _TaxDocItem TaxCalculationDate
TaxCode _TaxDocItem TaxCode Tax Code
TaxDepartureCountry _TaxDocItem TaxDepartureCountry Tx Dep Ctry/Reg
US_TaxProduct _TaxDocItem US_TaxProduct
TaxType _TaxDocItem TaxType Tax Type
UnitedStatesTaxCategory _TaxDocItem UnitedStatesTaxCategory
US_TaxPartnerReceivedTaxDate _TaxDocItem US_TaxPartnerReceivedTaxDate
GLTaxAmountOnDoc _Doc total_gl_taxamount
TaxAmountOnDoc _Doc total_taxamount_indc

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 P_ExternalTaxAggAmtWithBase.
-- 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: PAGGAMTWITHBASE

CREATE VIEW P_ExternalTaxAggAmtWithBase AS
SELECT
  _Amt.docnr AS US_TaxPartnerTaxDocument,
  _Amt.itemnr AS US_TaxPartnerTaxDocumentItem,
  _Amt.tax_state AS TaxState,
  _TaxDocItem.BillToParty AS BillToParty,
  _TaxDocItem.CostCenter AS CostCenter,
  _TaxDocItem.DebitCreditCode AS DebitCreditCode,
  _TaxDocItem.DocumentDate AS DocumentDate,
  _TaxDocItem.FreightAmount AS FreightAmount,
  _TaxDocItem.MainItemPricingRefMaterial AS MainItemPricingRefMaterial,
  _TaxDocItem.MaterialGroup AS MaterialGroup,
  _TaxDocItem.PointOfOrderAcceptanceTxJx AS PointOfOrderAcceptanceTxJx,
  _TaxDocItem.PointOfOrderOriginTxJx AS PointOfOrderOriginTxJx,
  _TaxDocItem.PurchasingDocument AS PurchasingDocument,
  _TaxDocItem.QuantityInBaseUnit AS QuantityInBaseUnit,
  _TaxDocItem.SalesMeasureUnit AS SalesMeasureUnit,
  _TaxDocItem.SDDocument AS SDDocument,
  _TaxDocItem.SDDocumentCategory AS SDDocumentCategory,
  _TaxDocItem.ServicesRenderedDate AS ServicesRenderedDate,
  _TaxDocItem.ShipFromAddressTaxJurisdiction AS ShipFromAddressTaxJurisdiction,
  _TaxDocItem.ShipToParty AS ShipToParty,
  _TaxDocItem.ShipToAddressTaxJurisdiction AS ShipToAddressTaxJurisdiction,
  _TaxDocItem.SoldToParty AS SoldToParty,
  _TaxDocItem.TaxCalculationDate AS TaxCalculationDate,
  _TaxDocItem.TaxCode AS TaxCode,
  _TaxDocItem.TaxDepartureCountry AS TaxDepartureCountry,
  _TaxDocItem.US_TaxProduct AS US_TaxProduct,
  _TaxDocItem.TaxType AS TaxType,
  _TaxDocItem.UnitedStatesTaxCategory AS UnitedStatesTaxCategory,
  _TaxDocItem.US_TaxPartnerReceivedTaxDate AS US_TaxPartnerReceivedTaxDate,
  _Doc.total_gl_taxamount AS GLTaxAmountOnDoc,
  _Doc.total_taxamount_indc AS TaxAmountOnDoc
FROM P_EXTERNALTAX_AGGITEMANDSTATE AS _Amt
;

Learn More