R_IN_GSTRetsSlsRegDocumentTP

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_IN_GSTRetsSlsRegDocumentTP.
-- 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 R_IN_GSTRetsSlsRegDocumentTP AS
SELECT
  I_IN_GSTRetsSlsRegDocument.ElectronicDocUUID AS ElectronicDocUUID,
  I_IN_GSTRetsSlsRegDocument.CompanyCode AS CompanyCode,
  I_IN_GSTRetsSlsRegDocument.BusinessPlace AS BusinessPlace,
  cast( I_IN_GSTRetsSlsRegDocument.IN_EDocEInvcExtNmbr as gl_in_einvno ) AS IN_EDocEInvcExtNmbr,
  cast( I_IN_GSTRetsSlsRegDocument.ReportingDate as glo_in_vatdate ) AS ReportingDate,
  cast( I_IN_GSTRetsSlsRegDocument.ReportingDate as glo_in_invoice_date ) AS IN_InvoiceDate,
  cast( I_IN_GSTRetsSlsRegDocument.IN_InvoiceType as glo_in_invoice_type) AS IN_InvoiceType,
  cast( I_ElectronicDocProcStatusText.ElectronicDocProcStatusText as glo_in_invoice_status ) AS ElectronicDocProcStatusText,
  cast( I_IN_GSTRetsSlsRegStateCode.IN_GSTPlaceOfSupplyName as glo_in_placeofsupply ) AS IN_GSTPlaceOfSupplyName,
  cast( I_IN_GSTRetsSlsRegDocument.IN_PrtnGSTIdentificationNmbr as glo_in_partnergstin ) AS IN_PrtnGSTIdentificationNmbr,
  cast( I_IN_GSTRetsSlsRegDocument.GrossAmount as glo_in_totalamount ) AS InvoiceGrossAmount,
  I_IN_GSTRetsSlsRegDocument.FiscalYear AS FiscalYear,
  cast( I_IN_GSTRetsSlsRegDocument.IN_GSTIdentificationNumber as glo_in_taxpayergstin ) AS IN_GSTIdentificationNumber,
  cast( I_IN_GSTRetsSlsRegDocument.BusinessPartnerFullName as glo_in_businesspartnername ) AS BusinessPartnerFullName,
  cast( I_IN_GSTRetsSlsRegDocument.IN_IsGSTReverseCharged as glo_in_reversecharge ) AS IN_IsGSTReverseCharged,
  cast( I_IN_GSTRetsSlsRegDocument.ReportingCountry as glo_in_country ) AS ReportingCountry,
  cast( I_IN_GSTRetsSlsRegDocument.IN_NoteType as glo_in_notetype ) AS IN_NoteType,
  cast( I_IN_GSTRetsSlsRegDocument.AccountingDocument as glo_in_account_doc ) AS AccountingDocument,
  I_IN_GSTRetsSlsRegDocument.BillingDocument AS BillingDocument,
  I_IN_GSTRetsSlsRegDocument.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_EDCRelation.EDCRecordUUID AS EDCRecordUUID,
  I_EDCResult.EDCResultProcess AS EDCResultProcess,
  I_EDCResult.EDCResultSqncNmbr AS EDCResultSqncNmbr,
  I_EDCResult.EDCResultUUID AS EDCResultUUID,
  R_IN_EDCLastConsistencyCheckTP.IN_EDCCheckValue AS IN_EDCCheckValue,
  cast( I_IN_GSTRetsSlsRegDocument._IN_ElectronicDocInvoice.IN_ElectronicDocInvcRefNmbr as glo_in_einv_irn ) AS IN_ElectronicDocInvcRefNmbr,
  cast( I_IN_GSTRetsSlsRegDocument._IN_ElectronicDocInvoice.IN_ElectronicDocAcknDate as glo_in_einv_ack_date ) AS IN_ElectronicDocAcknDate,
  cast( I_IN_GSTRetsSlsRegDocument._IN_ElectronicDocInvoice.IN_EDocEInvcEWbillNmbr as glo_in_einv_ewbno ) AS IN_EDocEInvcEWbillNmbr,
  cast( I_IN_GSTRetsSlsRegDocument._IN_ElectronicDocInvoice.IN_EDocEInvcEWbillCreateDate as glo_in_einv_ewb_date ) AS IN_EDocEInvcEWbillCreateDate,
  cast( I_IN_GSTRetsSlsRegDocument._IN_ElectronicDocInvoice.IN_EDocEInvcEWbillValidityDate as glo_in_einv_validto ) AS IN_EDocEInvcEWbillValidityDate,
  _IN_EDocGSTRetsSalesRegister.IN_EDocAmendmentDte AS IN_EDocAmendmentDte,
  _InvoiceTaxAttribute.IN_ShippingBillDate AS IN_ShippingBillDate,
  _InvoiceTaxAttribute.IN_ShippingBillNumber AS IN_ShippingBillNumber,
  _InvoiceTaxAttribute.IN_ShippingBillPortNumber AS IN_ShippingBillPortNumber
FROM I_IN_GSTRetsSlsRegDocument
LEFT OUTER JOIN R_SalesRegisterSummaryTP AS _SalesRegSummaryTP ON EDCRecordUUID = I_IN_GSTRetsSlsRegDocument.ElectronicDocUUID  -- association [0..*]
LEFT OUTER JOIN I_IN_OutgInvcTxAttrib AS _InvoiceTaxAttribute ON _InvoiceTaxAttribute.BillingDocument = I_IN_GSTRetsSlsRegDocument.BillingDocument  -- association [0..1]
LEFT OUTER JOIN R_IN_EDocGSTRetsSalesRegister AS _IN_EDocGSTRetsSalesRegister ON _IN_EDocGSTRetsSalesRegister.ElectronicDocUUID = I_IN_GSTRetsSlsRegDocument.ElectronicDocUUID  -- association [0..1]
LEFT OUTER JOIN R_IN_GSTRetsSlsRegTaxItemTP AS _TaxItemDetails ON /* condition not available in parsed metadata */  -- association [0..*]
;