P_RU_CommissionTradeInvoice

DDL: P_RU_COMMISSIONTRADEINVOICE SQL: PRUCTINV Type: view CONSUMPTION
43 Fields 1 Data Sources

P_RU_CommissionTradeInvoice is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_RU_CommissionTradeInvoice2) and exposes 43 fields with key fields CompanyCode, AccountingDocument, FiscalYear, RevisionNumber, RU_VATReturnSectionType.

Data Sources (1)

SourceAliasJoin Type
P_RU_CommissionTradeInvoice2 P_RU_CommissionTradeInvoice2 from

Parameters (2)

NameTypeDefault
P_StartDate char8
P_EndDate char8

Annotations (5)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PRUCTINV view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CommissInv CompanyCode Receiver Company Code
KEY AccountingDocument CommissInv AccountingDocument Journal Entry
KEY FiscalYear CommissInv FiscalYear G/L Fiscal Year
KEY RevisionNumber CommissInv RevisionNumber Revision Number
KEY RU_VATReturnSectionType CommissInv RU_VATReturnSectionType Section Type
KEY Invoice
KEY InvoiceYear
PostingDate PostingDate Posting Date for GR
RU_RegistrationInvoiceDate Tax Reporting Date
ExternalInvoice
InvoiceDate Run On
DocumentDate Journal Entry Date
OriginalInvoiceRevisionNumber
OriginalInvoiceRevisionDate Rev.Date Orig.Inv.
CorrectionInvoice
ExternalCorrectionInvoice
CorrectionInvoiceDate Corr. VAT Inv. Date
CorrectionDocumentDate
CorrectionInvoiceYear
CorrectionInvoiceRevisionNmbr
CorrectionInvoiceRevisionDate Rev. Date of Corr.
AmountInTransactionCurrency
TaxAmount
TransactionCurrency TransactionCurrency Transaction Currency
TotalLinkedAmount
TotalUnLinkedAmount
TotalLinkedVAT
TotalUnLinkedVAT
LinkingCurr LinkingCurr
ContractNum ContractNum
Customer Customer Sold-to Party
Supplier Supplier Supplier
BusinessPartner
BusinessPartnerName
CustomerFinsAuthorizationGrp CustomerFinsAuthorizationGrp
CustomerCompanyAuthznGroup CustomerCompanyAuthznGroup Authorization
SupplierFinsAuthorizationGrp SupplierFinsAuthorizationGrp
SupplierCompanyAuthznGroup SupplierCompanyAuthznGroup
IsReversal CommissInv IsReversal Reversal doc.
IsReversed CommissInv IsReversed Reversed?
ReverseDocument
ReverseDocumentFiscalYear
RU_VATReturnVersion RU_VATReturnVersion VAT Return Version

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,
  CustomerCompanyAuthznGroup,
  SupplierFinsAuthorizationGrp,
  SupplierCompanyAuthznGroup,
  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
;

Learn More