P_RU_CommissionTradeInvoice2

DDL: P_RU_COMMISSIONTRADEINVOICE2 SQL: PRUCTINV2 Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_RU
44 Fields

Commision Trade Invoices for Linking - Preparing 1

P_RU_CommissionTradeInvoice2 is a Consumption CDS View that provides data about "Commision Trade Invoices for Linking - Preparing 1" in SAP S/4HANA. Part of development package GLO_FIN_IS_VAT_RU.

Parameters (2)

NameTypeDefault
P_StartDate char8
P_EndDate char8

Annotations (5)

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

Fields (44)

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 CommissInv Invoice Orig.Inv.Number
KEY InvoiceYear CommissInv InvoiceYear Orig.Inv.Year
PostingDate CommissInv PostingDate Posting Date for GR
TaxReportingDate CommissInv TaxReportingDate Tax Reporting Date
ExternalInvoice CommissInv ExternalInvoice External Number
InvoiceDate CommissInv InvoiceDate Run On
DocumentDate CommissInv DocumentDate Journal Entry Date
CorrectionInvoice CommissInv CorrectionInvoice Corr.Inv.Number
ExternalCorrectionInvoice CommissInv ExternalCorrectionInvoice Corr. VAT Inv. Ext.
CorrectionInvoiceDate CommissInv CorrectionInvoiceDate Corr. VAT Inv. Date
CorrectionDocumentDate CommissInv CorrectionDocumentDate
CorrectionInvoiceYear CommissInv CorrectionInvoiceYear Corr.Inv.Year
AmountInTransactionCurrency CommissInv AmountInTransactionCurrency Pt Crcy Amt
TaxAmount CommissInv TaxAmount Tax Amt in Rptg Crcy
TransactionCurrency CommissInv TransactionCurrency Transaction Currency
TotalLinkedAmount LinkedData TotalLinkedAmount
TotalLinkedVAT LinkedData TotalLinkedVAT
TaxAmountendasTotalUnLinkedVAT
LinkingCurr LinkedData LinkingCurr
ContractNum CommissInv ContractNum
Customer CommissInv Customer Sold-to Party
Supplier CommissInv Supplier Supplier
BusinessPartner CommissInv BusinessPartner Issuing Authority
BusinessPartnerName CommissInv BusinessPartnerName Extracted Customer Name
CustomerFinsAuthorizationGrp CommissInv CustomerFinsAuthorizationGrp
CustomerAccountGroup CommissInv CustomerAccountGroup Account group
CustomerIsBusPrpsCmpltd CommissInv CustomerIsBusPrpsCmpltd
CustomerCompanyAuthznGroup CommissInv CustomerCompanyAuthznGroup Authorization
CustCoIsBusPrpsCmpltd CommissInv CustCoIsBusPrpsCmpltd
SupplierFinsAuthorizationGrp CommissInv SupplierFinsAuthorizationGrp
SupplierAccountGroup CommissInv SupplierAccountGroup Account group
SupplierIsBusPrpsCmpltd CommissInv SupplierIsBusPrpsCmpltd
SupplierCompanyAuthznGroup CommissInv SupplierCompanyAuthznGroup
SuplrCoIsBusPrpsCmpltd CommissInv SuplrCoIsBusPrpsCmpltd Purpose Completed
IsReversal CommissInv IsReversal Reversal doc.
IsReversed CommissInv IsReversed Reversed?
ReverseDocument CommissInv ReverseDocument Reversed With
ReverseDocumentFiscalYear CommissInv ReverseDocumentFiscalYear Year
RU_VATReturnVersion CommissInv 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_CommissionTradeInvoice2.
-- 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: PRUCTINV2
-- Parameters: P_StartDate : char8, P_EndDate : char8

CREATE VIEW P_RU_CommissionTradeInvoice2 AS
SELECT
  CommissInv.CompanyCode AS CompanyCode,
  CommissInv.AccountingDocument AS AccountingDocument,
  CommissInv.FiscalYear AS FiscalYear,
  CommissInv.RevisionNumber AS RevisionNumber,
  CommissInv.RU_VATReturnSectionType AS RU_VATReturnSectionType,
  CommissInv.Invoice AS Invoice,
  CommissInv.InvoiceYear AS InvoiceYear,
  CommissInv.PostingDate AS PostingDate,
  CommissInv.TaxReportingDate AS TaxReportingDate,
  CommissInv.ExternalInvoice AS ExternalInvoice,
  CommissInv.InvoiceDate AS InvoiceDate,
  CommissInv.DocumentDate AS DocumentDate,
  CommissInv.CorrectionInvoice AS CorrectionInvoice,
  CommissInv.ExternalCorrectionInvoice AS ExternalCorrectionInvoice,
  CommissInv.CorrectionInvoiceDate AS CorrectionInvoiceDate,
  CommissInv.CorrectionDocumentDate AS CorrectionDocumentDate,
  CommissInv.CorrectionInvoiceYear AS CorrectionInvoiceYear,
  CommissInv.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  CommissInv.TaxAmount AS TaxAmount,
  CommissInv.TransactionCurrency AS TransactionCurrency,
  LinkedData.TotalLinkedAmount AS TotalLinkedAmount,
  LinkedData.TotalLinkedVAT AS TotalLinkedVAT,
  case when LinkedData.TotalLinkedVAT is not null then abs(CommissInv.TaxAmount) - LinkedData.TotalLinkedVAT else abs(CommissInv.TaxAmount) end as TotalUnLinkedVAT AS TaxAmountendasTotalUnLinkedVAT,
  LinkedData.LinkingCurr AS LinkingCurr,
  CommissInv.ContractNum AS ContractNum,
  CommissInv.Customer AS Customer,
  CommissInv.Supplier AS Supplier,
  CommissInv.BusinessPartner AS BusinessPartner,
  CommissInv.BusinessPartnerName AS BusinessPartnerName,
  CommissInv.CustomerFinsAuthorizationGrp AS CustomerFinsAuthorizationGrp,
  CommissInv.CustomerAccountGroup AS CustomerAccountGroup,
  CommissInv.CustomerIsBusPrpsCmpltd AS CustomerIsBusPrpsCmpltd,
  CommissInv.CustomerCompanyAuthznGroup AS CustomerCompanyAuthznGroup,
  CommissInv.CustCoIsBusPrpsCmpltd AS CustCoIsBusPrpsCmpltd,
  CommissInv.SupplierFinsAuthorizationGrp AS SupplierFinsAuthorizationGrp,
  CommissInv.SupplierAccountGroup AS SupplierAccountGroup,
  CommissInv.SupplierIsBusPrpsCmpltd AS SupplierIsBusPrpsCmpltd,
  CommissInv.SupplierCompanyAuthznGroup AS SupplierCompanyAuthznGroup,
  CommissInv.SuplrCoIsBusPrpsCmpltd AS SuplrCoIsBusPrpsCmpltd,
  CommissInv.IsReversal AS IsReversal,
  CommissInv.IsReversed AS IsReversed,
  CommissInv.ReverseDocument AS ReverseDocument,
  CommissInv.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  CommissInv.RU_VATReturnVersion AS RU_VATReturnVersion
;

Learn More