R_IN_GSTPurchaseRegisterDocTP

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_GSTPurchaseRegisterDocTP.
-- 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_GSTPurchaseRegisterDocTP AS
SELECT
  I_IN_EDocGSTPurRegJrnlEntrDoc.ElectronicDocUUID AS ElectronicDocUUID,
  I_IN_EDocGSTPurRegJrnlEntrDoc.ElectronicDocCompanyCode AS CompanyCode,
  I_IN_EDocGSTPurRegJrnlEntrDoc.ElectronicDocType AS ElectronicDocType,
  cast( I_IN_EDocGSTPurRegJrnlEntrDoc.ElectronicDocCountry as glo_in_country ) AS ReportingCountry,
  I_IN_EDocGSTPurRegJrnlEntrDoc.IN_EDocGSTRetsBusinessPlace AS IN_EDocGSTRetsBusinessPlace,
  cast( I_IN_EDocGSTPurRegJrnlEntrDoc.IN_EDocGSTRetsTaxReportingDate as glo_in_vatdate) AS ReportingDate,
  cast( I_IN_EDocGSTPurRegJrnlEntrDoc.IN_EDocGSTRetsExtNmbr as gl_in_einvno) AS IN_EDocEInvcExtNmbr,
  cast( I_IN_EDocGSTPurRegJrnlEntrDoc.AccountingDocument as glo_in_account_doc) AS AccountingDocument,
  cast( I_IN_EDocGSTPurRegJrnlEntrDoc.DocumentDate as glo_in_invoice_date ) AS DocumentDate,
  I_IN_EDocGSTPurRegJrnlEntrDoc.IN_DocumentSectionCode AS IN_DocumentSectionCode,
  I_IN_EDocGSTPurRegJrnlEntrDoc.ElectronicDocProcessStatus AS ElectronicDocProcessStatus,
  cast( _ElectronicDocText.ElectronicDocProcStatusText as glo_in_invoice_status ) AS ElectronicDocProcStatusText,
  cast( I_IN_GSTRetsSlsRegStateCode.IN_GSTPlaceOfSupplyName as glo_in_placeofsupply) AS IN_GSTPlaceOfSupplyName,
  cast( I_IN_EDocGSTPurRegJrnlEntrDoc.IN_EDocFiscalYear as fis_gjahr_no_conv) AS FiscalYear,
  cast(I_IN_EDocGSTPurRegJrnlEntrDoc.IN_NoteType as glo_in_notetype) AS IN_NoteType,
  cast( I_IN_EDocGSTPurRegJrnlEntrDoc.IN_IsGSTReverseCharged as glo_in_reversecharge ) AS IN_IsGSTReverseCharged,
  cast(I_IN_EDocGSTPurRegJrnlEntrDoc.IN_GSTIdentificationNumber as glo_in_taxpayergstin) AS IN_GSTIdentificationNumber,
  I_IN_EDocGSTPurRegJrnlEntrDoc.IN_EDocInptTaxCrdtAccptdPeriod AS IN_EDocInptTaxCrdtAccptdPeriod,
  I_IN_EDocGSTPurRegJrnlEntrDoc.PostingDate AS PostingDate,
  cast(I_IN_EDocGSTPurRegJrnlEntrDoc._Supplier.SupplierFullName as glo_in_businesspartnername) AS BusinessPartnerFullName,
  cast(I_IN_EDocGSTPurRegJrnlEntrDoc._Supplier.TaxNumber3 as glo_in_partnergstin ) AS IN_PrtnGSTIdentificationNmbr,
  I_IN_GSTPurInvoiceGrossAmount.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast( I_IN_GSTPurInvoiceGrossAmount.InvoiceGrossAmount as glo_in_totalamount) AS InvoiceGrossAmount
FROM I_IN_EDocGSTPurRegJrnlEntrDoc
LEFT OUTER JOIN I_ElectronicDocProcStatusText AS _ElectronicDocText ON _ElectronicDocText.ElectronicDocProcessStatus = I_IN_EDocGSTPurRegJrnlEntrDoc.ElectronicDocProcessStatus AND _ElectronicDocText.ElectronicDocProcess = I_IN_EDocGSTPurRegJrnlEntrDoc.ElectronicDocProcess  -- association [0..*]
LEFT OUTER JOIN R_IN_GSTPurchaseRegisterItemTP AS _PurchaseRegisterItemDet ON /* condition not available in parsed metadata */  -- association [0..*]
;