C_US_TaxPartnerTaxDocument

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_TaxPartnerTaxDocument.
-- 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: CUSTXPARTTXDOC

CREATE VIEW C_US_TaxPartnerTaxDocument AS
SELECT
  US_TaxPartnerTaxDocument,
  US_TaxPartnerTaxDocumentItem,
  US_TaxState,
  CompanyCode,
  ReferenceDocument,
  ReferenceDocumentContext,
  US_TxPartnerTxDocumentSentDate,
  US_TaxPartnerTaxTransaction,
  ReferenceDocumentType,
  TaxCalculationDate,
  AccountingDocument,
  FiscalYear,
  TransactionCurrency,
  CompanyCodeCurrency,
  PostingDate,
  DocumentDate,
  TaxCode,
  TaxType,
  UserInputTaxRate,
  TaxBaseAmountInTransCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInTransCrcy,
  TaxAmountInCoCodeCrcy,
  TaxRate,
  TaxCalculationProcedure,
  TaxDepartureCountry,
  US_TaxPartTaxDocUpdateType,
  SlsTaxLiabilityAmtInCoCodeCrcy,
  PurchaseTxLbltyAmtInCoCodeCrcy,
  US_TxPartnerTxDocSentByUsr,
  TxPartTxDocTxAmtInCoCodeCrcy,
  TxPartTxDocTxAmtInTransCrcy,
  DefaultTaxDate,
  US_TaxPartnerReceivedTaxDate,
  _TaxType._Text[1:Language = $session.system_language].TaxTypeName AS TaxTypeName,
  _TaxCode._Text[1:Language = $session.system_language].TaxCodeName AS TaxCodeName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  US_TaxPartTxDocUpdtTypeName,
  _State._Text[1:Language = $session.system_language].US_TaxStateName AS US_TaxStateName,
  _User.UserDescription AS UserDescription,
  _ReferenceDocumentType._Text[1:Language = $session.system_language].ReferenceDocumentTypeName AS ReferenceDocumentTypeName
FROM R_US_TaxPartnerTaxDocument
LEFT OUTER JOIN C_US_TaxPartnerTaxDocumentItem AS _TaxItemPage ON US_TaxPartnerTaxDocument = _TaxItemPage.US_TaxPartnerTaxDocument  -- association [1..*]
LEFT OUTER JOIN I_CompanyCodeStdVH AS _CompanyCodeVH ON CompanyCode = _CompanyCodeVH.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_TaxCodeStdVH AS _TaxCodeStdVH ON TaxCode = _TaxCodeStdVH.TaxCode AND TaxCalculationProcedure = _TaxCodeStdVH.TaxCalculationProcedure  -- association [0..1]
LEFT OUTER JOIN I_US_TaxStateVH AS _TaxStateVH ON US_TaxState = _TaxStateVH.US_TaxState  -- association [0..1]
LEFT OUTER JOIN I_US_TxPartTxDocUpdateTypeText AS _DocUpdateTypeText ON US_TaxPartTaxDocUpdateType = _DocUpdateTypeText.US_TaxPartTaxDocUpdateType  -- association [0..*]
LEFT OUTER JOIN I_ReferenceDocumentTypeVH AS _ReferenceDocumentTypeVH ON ReferenceDocumentType = _ReferenceDocumentTypeVH.ReferenceDocumentType  -- association [0..1]
;