P_RU_CommissionTradeInvoice

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_RU_CommissionTradeInvoice.
-- 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.
-- SQL view name: PRUCTINV
-- Parameters: P_StartDate : char8, P_EndDate : char8

CREATE VIEW P_RU_CommissionTradeInvoice AS
SELECT
  CommissInv.CompanyCode AS CompanyCode,
  CommissInv.AccountingDocument AS AccountingDocument,
  CommissInv.FiscalYear AS FiscalYear,
  CommissInv.RevisionNumber AS RevisionNumber,
  CommissInv.RU_VATReturnSectionType AS RU_VATReturnSectionType,
  cast(CommissInv.Invoice as j_3rfinv_origs) AS Invoice,
  cast(CommissInv.InvoiceYear as j_3rfinv_origy) AS InvoiceYear,
  PostingDate,
  cast(TaxReportingDate as vatdate) AS RU_RegistrationInvoiceDate,
  cast(CommissInv.ExternalInvoice as j_3rfinv_orige) AS ExternalInvoice,
  cast(InvoiceDate as j_3rfinv_origd) AS InvoiceDate,
  cast(DocumentDate as j_3rfinv_origd) AS DocumentDate,
  cast(CommissInv.OriginalInvoiceRevisionNumber as j_3rfinv_revno_orig) AS OriginalInvoiceRevisionNumber,
  cast(OriginalInvoiceRevisionDate as j_3rfinv_orig_revd) AS OriginalInvoiceRevisionDate,
  cast(CommissInv.CorrectionInvoice as j_3rfinv_corrs) AS CorrectionInvoice,
  cast(CommissInv.ExternalCorrectionInvoice as j_3rfinv_corre) AS ExternalCorrectionInvoice,
  cast(CorrectionInvoiceDate as j_3rfinv_corrd) AS CorrectionInvoiceDate,
  cast(CorrectionDocumentDate as j_3rfinv_corrd) AS CorrectionDocumentDate,
  cast(CommissInv.CorrectionInvoiceYear as j_3rfinv_corry) AS CorrectionInvoiceYear,
  cast(CommissInv.CorrectionInvoiceRevisionNmbr as j_3rfinv_revno_corr) AS CorrectionInvoiceRevisionNmbr,
  cast(CorrectionInvoiceRevisionDate as j_3rfinv_corr_revd) AS CorrectionInvoiceRevisionDate,
  cast(CommissInv.AmountInTransactionCurrency as fis_wsl) AS AmountInTransactionCurrency,
  cast(CommissInv.TaxAmount as wmwst_shl) AS TaxAmount,
  TransactionCurrency,
  cast(TotalLinkedAmount as firu_invj_linked_amount) AS TotalLinkedAmount,
  cast(TotalUnLinkedAmount as firu_invj_unlinked_amount) AS TotalUnLinkedAmount,
  cast(TotalLinkedVAT as firu_invj_linked_vat) AS TotalLinkedVAT,
  cast(TotalUnLinkedVAT as firu_invj_unlinked_vat) AS TotalUnLinkedVAT,
  LinkingCurr,
  ContractNum,
  Customer,
  Supplier,
  cast(CommissInv.BusinessPartner as bu_partner) AS BusinessPartner,
  cast(CommissInv.BusinessPartnerName as businesspartnername) AS BusinessPartnerName,
  CustomerFinsAuthorizationGrp,
  CustomerAccountGroup,
  CustomerIsBusPrpsCmpltd,
  CustomerCompanyAuthznGroup,
  CustCoIsBusPrpsCmpltd,
  SupplierFinsAuthorizationGrp,
  SupplierAccountGroup,
  SupplierIsBusPrpsCmpltd,
  SupplierCompanyAuthznGroup,
  SuplrCoIsBusPrpsCmpltd,
  CommissInv.IsReversal AS IsReversal,
  CommissInv.IsReversed AS IsReversed,
  cast(CommissInv.ReverseDocument as stblg) AS ReverseDocument,
  cast(CommissInv.ReverseDocumentFiscalYear as stjah) AS ReverseDocumentFiscalYear,
  RU_VATReturnVersion
FROM P_RU_CommissionTradeInvoice2
;