I_IN_EDCTaxAuthEInvcHdr

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_IN_EDCTaxAuthEInvcHdr.
-- 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_IN_EDCTaxAuthEInvcHdr AS
SELECT
  record_guid AS EDCTaxAuthRecordUUID,
  tp_gstin AS IN_EDCTaxAuthTaxPayerGSTIN,
  cast(ret_period as abap.numc( 6 )) AS IN_EDCTaxAuthReportingPeriod,
  doc_section AS IN_EDCTaxAuthDocSectionCode,
  doc_no AS IN_EDCTaxAuthEDocInvcNmbr,
  cp_gstin AS IN_EDCTaxAuthBusinessPrtnGSTIN,
  cp_name AS IN_EDCTaxAuthBusinessPrtnName,
  doc_date AS IN_EDCTaxAuthDocumentDate,
  pos AS IN_EDCTaxAuthGSTPlaceOfSupply,
  inv_type AS IN_EDCTaxAuthInvoiceType,
  is_reverse_charge AS IN_EDCTaxAuthIsReverseCharged,
  doc_amount AS IN_EDCTaxAuthDocumentAmount,
  currency_code AS Currency,
  irn_src_type AS IN_EDCTaxAuthEInvcSrceType,
  irn AS IN_EDCTaxAuthInvcRefNmbr,
  irn_gendate AS IN_EDCTaxAuthEInvcGnrtnDate,
  einv_status AS IN_EDCTaxAuthEInvcStatus,
  auto_draft_status AS IN_EDCTaxAuthAutoDraftStatus,
  auto_draft_date AS IN_EDCTaxAuthAutoDraftDate,
  note_type AS IN_EDCTaxAuthNoteType,
  ship_bill_number AS IN_EDCTaxAuthShipgBillNumber,
  ship_bill_date AS IN_EDCTaxAuthShipgBillDate,
  ship_port_code AS IN_EDCTaxAuthShipgPortCode,
  ecom_gstin AS IN_EDCTaxAuthEcommerceGSTIN,
  error_code AS IN_EDCTaxAuthErrorCode,
  error_desciption AS IN_EDCTaxAuthErrorDescription
FROM edcineinvh
LEFT OUTER JOIN I_IN_EDCTaxAuthEInvcItem AS _EDCTaxAuthEInvcItem ON EDCTaxAuthRecordUUID = _EDCTaxAuthEInvcItem.EDCTaxAuthRecordUUID  -- association [1..*]
;