I_CN_GoldenTaxDocumentBasic

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 I_CN_GoldenTaxDocumentBasic.
-- 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.

CREATE VIEW I_CN_GoldenTaxDocumentBasic AS
SELECT
  gtd_header_uuid AS CN_GoldenTaxUUID,
  gtd_nmbr AS CN_GoldenTaxDocument,
  gtd_status AS CN_GoldenTaxDocumentStatus,
  invc_cat AS CN_TaxInvoiceCategory,
  invc_type AS CN_TaxInvcType,
  invc_medium AS CN_GoldenTaxInvoiceMedium,
  pos_gtvbeln AS CN_GoldenTaxPositiveInvcNumber,
  pos_typcode AS CN_GoldenTaxPositiveInvcCode,
  send_type AS CN_GoldenTaxSendType,
  is_cancel_ind AS CN_GoldenTaxDocumentIsCanceled,
  is_goods_list AS CN_GoldenTaxIsGoodsList,
  ref_gtd_nmbr AS CN_ReferenceGoldenTaxDocument,
  net_value AS CN_TaxInvcNetAmtInLocalCrcy,
  tax_amount AS CN_TaxInvcTaxAmtInLocalCrcy,
  disc_amount AS CN_TaxInvcDiscNetAmtInLoclCrcy,
  disc_tax_amount AS CN_TaxInvcDiscTaxAmtInLoclCrcy,
  currency AS LocalCurrency,
  tax_rate AS TaxRate,
  buyer_nmbr AS PayerParty,
  buyer_name AS PayerPartyName,
  cast(buyer_tax_reg_nmbr as ficntax_buyr_reg_nmbr) AS CN_TaxBuyerRegnNmbr,
  buyer_addr_tel AS CN_GoldenTaxPyrPtyAddrTelText,
  buyer_bank AS CN_GoldenTaxPyrPtyBankText,
  buyer_bustyp AS CN_GoldenTaxPyrPtyBusinessType,
  buyer_phone AS CN_GoldenTaxPayerPartyPhone,
  buyer_mobile AS CN_GoldenTaxPyrPtyMobilePhone,
  buyer_province AS CN_GoldenTaxPyrPartyProvince,
  buyer_email AS CN_GoldenTaxPayerPartyEmail,
  seller_name AS CN_GoldenTaxSellerName,
  seller_bank AS CN_GoldenTaxSellerBankText,
  seller_addr_tel AS CN_GoldenTaxSellerAddrTelText,
  seller_phone AS CN_GoldenTaxSellerPhone,
  note AS CN_GoldenTaxNote,
  note2 AS CN_GoldenTaxAdditionalNote,
  red_note_nmbr AS CN_GoldenTaxRedNoteNumber,
  red_note_ind AS CN_GoldenTaxIsWithRedNoteNmbr,
  issuer AS CN_GoldenTaxIssuer,
  reviewer AS CN_GoldenTaxReviewer,
  receiver AS CN_GoldenTaxReceiver,
  doc_date AS CN_GoldenTaxSourceDocumentDate,
  sent_date AS CN_GoldenTaxSentDate,
  print_times AS CN_GoldenTaxNumberOfPrinting,
  last_print_date AS CN_GoldenTaxLastPrintDate,
  cast( exch_rate as fis_exchange_rate preserving type ) AS ExchangeRate,
  frgn_amount AS CN_TaxInvcNetAmtInInvcCrcy,
  frgn_crcy AS CN_TaxInvcCrcy,
  create_user AS CreatedByUser,
  create_time AS CreationDateTime,
  change_user AS LastChangedByUser,
  change_time AS ChangedDateTime
FROM eiv_gtd_hdr
LEFT OUTER JOIN I_CN_GoldenTaxDocumentItmBasic AS _GTDItem ON CN_GoldenTaxUUID = _GTDItem.CN_GoldenTaxUUID  -- association [0..*]
LEFT OUTER JOIN I_CN_GoldenTaxDocumentMapping AS _GTDMapping ON CN_GoldenTaxDocument = _GTDMapping.CN_GoldenTaxDocument  -- association [1..*]
;