P_RU_CommissionTradeInvoice1

DDL: P_RU_COMMISSIONTRADEINVOICE1 SQL: PRUCTINV1 Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_RU
43 Fields

Commision Trade Invoices for Linking - Preparing 1

P_RU_CommissionTradeInvoice1 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 (7)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PRUCTINV1 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode JournalData CompanyCode Receiver Company Code
KEY AccountingDocument JournalData AccountingDocument Journal Entry
KEY FiscalYear JournalData FiscalYear G/L Fiscal Year
KEY RevisionNumber
KEY RU_VATReturnSectionType JournalData RU_VATReturnSectionType Section Type
KEY Invoice JournalData Invoice Orig.Inv.Number
KEY InvoiceYear JournalData InvoiceYear Orig.Inv.Year
PostingDate JournalData PostingDate Posting Date for GR
TaxReportingDate JournalData TaxReportingDate Tax Reporting Date
ExternalInvoice JournalData ExternalInvoice External Number
InvoiceDate JournalData InvoiceDate Run On
DocumentDate JournalData DocumentDate Journal Entry Date
OriginalInvoiceRevisionNumber
OriginalInvoiceRevisionDate JournalData OriginalInvoiceRevisionDate Rev.Date Orig.Inv.
RevisionInvoiceDate JournalData RevisionInvoiceDate
CorrectionInvoice
ExternalCorrectionInvoice JournalData ExternalCorrectionInvoice Corr. VAT Inv. Ext.
CorrectionInvoiceDate JournalData CorrectionInvoiceDate Corr. VAT Inv. Date
CorrectionDocumentDate JournalData CorrectionDate
CorrectionInvoiceYear
AmountInTransactionCurrency JournalData AmountInTransactionCurrency Pt Crcy Amt
TaxAmount JournalData TaxAmount Tax Amt in Rptg Crcy
TransactionCurrency PartnerAccDocItem TransactionCurrency Transaction Currency
ContractNum PartnerAccDocItem AssignmentReference Assignment Reference
Customer PartnerAccDocItem Customer Sold-to Party
Supplier PartnerAccDocItem Supplier Supplier
BusinessPartner
BusinessPartnerName
CustomerFinsAuthorizationGrp CustomerData CustomerFinsAuthorizationGrp
CustomerAccountGroup CustomerData CustomerAccountGroup Account group
CustomerIsBusPrpsCmpltd CustomerData CustomerIsBusPrpsCmpltd
CustomerCompanyAuthznGroup CustomerData CustomerCompanyAuthznGroup Authorization
CustCoIsBusPrpsCmpltd CustomerData CustCoIsBusPrpsCmpltd
SupplierFinsAuthorizationGrp SupplierData SupplierFinsAuthorizationGrp
SupplierAccountGroup SupplierData SupplierAccountGroup Account group
SupplierIsBusPrpsCmpltd SupplierData SupplierIsBusPrpsCmpltd
SupplierCompanyAuthznGroup SupplierData SupplierCompanyAuthznGroup
SuplrCoIsBusPrpsCmpltd SupplierData SuplrCoIsBusPrpsCmpltd Purpose Completed
IsReversal JournalData IsReversal Reversal doc.
IsReversed JournalData IsReversed Reversed?
ReverseDocument JournalData ReverseDocument Reversed With
ReverseDocumentFiscalYear JournalData ReverseDocumentFiscalYear Year
RU_VATReturnVersion JournalData 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_CommissionTradeInvoice1.
-- 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: PRUCTINV1
-- Parameters: P_StartDate : char8, P_EndDate : char8

CREATE VIEW P_RU_CommissionTradeInvoice1 AS
SELECT
  JournalData.CompanyCode AS CompanyCode,
  JournalData.AccountingDocument AS AccountingDocument,
  JournalData.FiscalYear AS FiscalYear,
  coalesce(JournalData.RevisionNumber, '000') AS RevisionNumber,
  JournalData.RU_VATReturnSectionType AS RU_VATReturnSectionType,
  JournalData.Invoice AS Invoice,
  JournalData.InvoiceYear AS InvoiceYear,
  JournalData.PostingDate AS PostingDate,
  JournalData.TaxReportingDate AS TaxReportingDate,
  JournalData.ExternalInvoice AS ExternalInvoice,
  JournalData.InvoiceDate AS InvoiceDate,
  JournalData.DocumentDate AS DocumentDate,
  coalesce(JournalData.OriginalInvoiceRevisionNumber, '000') AS OriginalInvoiceRevisionNumber,
  JournalData.OriginalInvoiceRevisionDate AS OriginalInvoiceRevisionDate,
  JournalData.RevisionInvoiceDate AS RevisionInvoiceDate,
  coalesce(JournalData.CorrectionInvoice, '') AS CorrectionInvoice,
  JournalData.ExternalCorrectionInvoice AS ExternalCorrectionInvoice,
  JournalData.CorrectionInvoiceDate AS CorrectionInvoiceDate,
  JournalData.CorrectionDate AS CorrectionDocumentDate,
  coalesce(JournalData.CorrectionInvoiceYear, '0000') AS CorrectionInvoiceYear,
  JournalData.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  JournalData.TaxAmount AS TaxAmount,
  PartnerAccDocItem.TransactionCurrency AS TransactionCurrency,
  PartnerAccDocItem.AssignmentReference AS ContractNum,
  PartnerAccDocItem.Customer AS Customer,
  PartnerAccDocItem.Supplier AS Supplier,
  coalesce(CustomerData.BusinessPartner, SupplierData.BusinessPartner) AS BusinessPartner,
  coalesce(CustomerData.CustomerName, SupplierData.SupplierName) AS BusinessPartnerName,
  CustomerData.CustomerFinsAuthorizationGrp AS CustomerFinsAuthorizationGrp,
  CustomerData.CustomerAccountGroup AS CustomerAccountGroup,
  CustomerData.CustomerIsBusPrpsCmpltd AS CustomerIsBusPrpsCmpltd,
  CustomerData.CustomerCompanyAuthznGroup AS CustomerCompanyAuthznGroup,
  CustomerData.CustCoIsBusPrpsCmpltd AS CustCoIsBusPrpsCmpltd,
  SupplierData.SupplierFinsAuthorizationGrp AS SupplierFinsAuthorizationGrp,
  SupplierData.SupplierAccountGroup AS SupplierAccountGroup,
  SupplierData.SupplierIsBusPrpsCmpltd AS SupplierIsBusPrpsCmpltd,
  SupplierData.SupplierCompanyAuthznGroup AS SupplierCompanyAuthznGroup,
  SupplierData.SuplrCoIsBusPrpsCmpltd AS SuplrCoIsBusPrpsCmpltd,
  JournalData.IsReversal AS IsReversal,
  JournalData.IsReversed AS IsReversed,
  JournalData.ReverseDocument AS ReverseDocument,
  JournalData.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  JournalData.RU_VATReturnVersion AS RU_VATReturnVersion
;

Learn More