R_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 R_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: RUSTXPARTTXDOC

CREATE VIEW R_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,
  GLTaxAmountOnDoc AS TxPartTxDocTxAmtInCoCodeCrcy,
  TaxAmountOnDoc AS TxPartTxDocTxAmtInTransCrcy,
  DefaultTaxDate,
  US_TaxPartnerReceivedTaxDate,
  _DocUpdateTypeText[1:Language = $session.system_language].US_TaxPartTxDocUpdtTypeName AS US_TaxPartTxDocUpdtTypeName
FROM P_US_TaxPartTaxDocOverView
LEFT OUTER JOIN I_US_TxPartTxDocUpdateTypeText AS _DocUpdateTypeText ON US_TaxPartTaxDocUpdateType = _DocUpdateTypeText.US_TaxPartTaxDocUpdateType  -- association [0..*]
LEFT OUTER JOIN I_US_TaxState AS _State ON US_TaxState = _State.US_TaxState  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON US_TxPartnerTxDocSentByUsr = _User.UserID  -- association [0..1]
LEFT OUTER JOIN I_ReferenceDocumentType AS _ReferenceDocumentType ON ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType  -- association [0..1]
;