P_IN_EDocSalesRegister

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 P_IN_EDocSalesRegister.
-- 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 P_IN_EDocSalesRegister AS
SELECT
  I_ElectronicDoc.ElectronicDocUUID AS ElectronicDocUUID,
  I_ElectronicDoc.ElectronicDocSequenceNmbr AS ElectronicDocSequenceNmbr,
  I_ElectronicDoc.ElectronicDocCompanyCode AS ElectronicDocCompanyCode,
  I_ElectronicDoc.ElectronicDocCountry AS ReportingCountry,
  I_ElectronicDoc.ElectronicDocSourceType AS ElectronicDocSourceType,
  I_ElectronicDoc.ElectronicDocSourceKey AS ElectronicDocSourceKey,
  I_ElectronicDoc.ElectronicDocType AS ElectronicDocType,
  I_ElectronicDoc.ElectronicDocProcessStatus AS ElectronicDocProcessStatus,
  I_ElectronicDoc.ElectronicDocLogicalSystem AS ElectronicDocLogicalSystem,
  I_ElectronicDoc.ElectronicDocLastChangedByUser AS ElectronicDocLastChangedByUser,
  I_ElectronicDoc.ElectronicDocLastChangeDate AS ElectronicDocLastChangeDate,
  I_ElectronicDoc.ElectronicDocLastChangeTime AS ElectronicDocLastChangeTime,
  I_ElectronicDoc.ElectronicDocCreatedByUser AS ElectronicDocCreatedByUser,
  I_ElectronicDoc.ElectronicDocCreationDate AS ElectronicDocCreationDate,
  I_ElectronicDoc.ElectronicDocCreationTime AS ElectronicDocCreationTime,
  I_ElectronicDoc.ElectronicDocSrceCreatedByUser AS ElectronicDocSrceCreatedByUser,
  I_ElectronicDoc.ElectronicDocProcess AS ElectronicDocProcess,
  I_ElectronicDoc.ElectronicDocLastProcStep AS ElectronicDocLastProcStep,
  I_ElectronicDoc.ElectronicDocLastProcStepVar AS ElectronicDocLastProcStepVar,
  I_ElectronicDoc.ElectronicDocHasError AS ElectronicDocHasError,
  I_ElectronicDoc.ElectronicDocProcessVersion AS ElectronicDocProcessVersion,
  I_ElectronicDoc.ElectronicDocRefSqncNmbr AS ElectronicDocRefSqncNmbr,
  I_ElectronicDoc.ElectronicDocStatus AS ElectronicDocStatus,
  I_ElectronicDoc.ElectronicDocPostingDate AS ElectronicDocPostingDate,
  I_ElectronicDoc.ElectronicDocIsContingency AS ElectronicDocIsContingency,
  I_ElectronicDoc.ElectronicDocReferenceProcess AS ElectronicDocReferenceProcess,
  I_ElectronicDoc.ElectronicDocClassName AS ElectronicDocClassName,
  I_ElectronicDoc.ElectronicDocIsArchPrprocgDone AS ElectronicDocIsArchPrprocgDone,
  I_ElectronicDoc.ElectronicDocInterfaceType AS ElectronicDocInterfaceType,
  I_ElectronicDoc.ElectronicDocApprovalIDValue AS ElectronicDocApprovalIDValue,
  I_ElectronicDoc.ElectronicDocInterfaceUUID AS ElectronicDocInterfaceUUID,
  I_ElectronicDoc.ElectronicDocFileUUID AS ElectronicDocFileUUID,
  I_ElectronicDoc.ElectronicDocResponseCodeValue AS ElectronicDocResponseCodeValue,
  I_ElectronicDoc.ElectronicDocInterfaceID AS ElectronicDocInterfaceID,
  I_ElectronicDoc.ElectronicDocInterfaceVersion AS ElectronicDocInterfaceVersion,
  I_ElectronicDoc.ElectronicDocIsCntdInArchive AS ElectronicDocIsCntdInArchive,
  I_ElectronicDoc.ElectronicDocMetaStatus AS ElectronicDocMetaStatus,
  I_ElectronicDoc.ElectronicDocProcessForStatus AS ElectronicDocProcessForStatus,
  '' AS IN_ElectronicDocInvcRefNmbr,
  I_IN_EDocGSTRetsSalesRegister.IN_DocumentSectionCode AS IN_DocumentSectionCode,
  I_IN_EDocGSTRetsSalesRegister.IN_EDocGSTRetsTaxReportingDate AS TaxReportingDate,
  I_IN_EDocGSTRetsSalesRegister.IN_EDocGSTRetsExtNmbr AS IN_EDocEInvcExtNmbr,
  I_IN_EDocGSTRetsSalesRegister.IN_GSTPartner AS BusinessPartner,
  I_IN_EDocGSTRetsSalesRegister.IN_EDocGSTRetsBPAddrId AS AddressNumber,
  _StateCodeMap.IN_GSTLegalStateCode AS IN_GSTPlaceOfSupplyName,
  I_IN_EDocGSTRetsSalesRegister.IN_GSTPlaceOfSupply AS IN_GSTPlaceOfSupply,
  I_IN_EDocGSTRetsSalesRegister.IN_DifferentialPercentageRate AS IN_DifferentialPercentageRate,
  I_IN_EDocGSTRetsSalesRegister.IN_EDocGSTRetsBusinessPlace AS IN_EDocEInvcBusinessPlace,
  I_IN_EDocGSTRetsSalesRegister.IN_InvoiceType AS IN_InvoiceType,
  I_IN_EDocGSTRetsSalesRegister.IN_NoteType AS IN_NoteType,
  coalesce(_BusPartAddrDepdntTaxNmbr.BPTaxNumber,_BpPartnerTaxNum.BPTaxNumber) AS IN_PrtnGSTIdentificationNmbr,
  _BpPartnerTaxNum._BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  I_IN_EDocGSTRetsSalesRegister.IN_HasNilType AS IN_HasNilType,
  I_IN_EDocGSTRetsSalesRegister.IN_EDocAmendmentDte AS IN_EDocAmendmentDte,
  _Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  I_IN_BusinessPlace.IN_GSTIdentificationNumber AS IN_GSTIdentificationNumber
FROM I_IN_EDocGSTRetsSalesRegister
INNER JOIN I_ElectronicDoc ON /* join condition not captured in parsed metadata */
INNER JOIN I_IN_BusinessPlace ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_IN_ElectronicDocInvoice AS _IN_ElectronicDocInvoice ON _IN_ElectronicDocInvoice.ElectronicDocSourceKey = I_ElectronicDoc.ElectronicDocSourceKey  -- association [0..1]
LEFT OUTER JOIN I_ElectronicDoc AS _ElectronicDocEInvc ON _ElectronicDocEInvc.ElectronicDocSourceKey = I_ElectronicDoc.ElectronicDocSourceKey AND _ElectronicDocEInvc.ElectronicDocType = 'IN_EINV'  -- association [0..1]
LEFT OUTER JOIN I_ElectronicDoc AS _ElectronicDocEWbill ON _ElectronicDocEWbill.ElectronicDocSourceKey = I_ElectronicDoc.ElectronicDocSourceKey AND _ElectronicDocEWbill.ElectronicDocType = 'IN_EWB'  -- association [0..1]
LEFT OUTER JOIN I_BusPartAddrDepdntTaxNmbr AS _BusPartAddrDepdntTaxNmbr ON _BusPartAddrDepdntTaxNmbr.BusinessPartner = I_IN_EDocGSTRetsSalesRegister.IN_GSTPartner AND _BusPartAddrDepdntTaxNmbr.BusinessPartnerAddressID = I_IN_EDocGSTRetsSalesRegister.IN_EDocGSTRetsBPAddrId  -- association [0..1]
LEFT OUTER JOIN I_Businesspartnertaxnumber AS _BpPartnerTaxNum ON _BpPartnerTaxNum.BusinessPartner = I_IN_EDocGSTRetsSalesRegister.IN_GSTPartner AND _BpPartnerTaxNum.BPTaxType = 'IN3'  -- association [0..1]
LEFT OUTER JOIN I_IN_GSTStateCodeMap AS _StateCodeMap ON _StateCodeMap.Country = I_ElectronicDoc.ElectronicDocCountry AND _StateCodeMap.Region = I_IN_EDocGSTRetsSalesRegister.IN_GSTPlaceOfSupply  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON _JournalEntry.CompanyCode = ElectronicDocCompanyCode AND _JournalEntry.AccountingDocument = AccountingDocument AND _JournalEntry.FiscalYear = FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON ElectronicDocCompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON _Country.Country = 'IN'  -- association [0..1]
;