P_RU_CommissionTradeInvoice13

DDL: P_RU_COMMISSIONTRADEINVOICE13 Type: view_entity CONSUMPTION

P_RU_CommissionTradeInvoice13 is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_RU_CommissionTradeInvoice12) and exposes 24 fields.

Data Sources (1)

SourceAliasJoin Type
P_RU_CommissionTradeInvoice12 VatReporting from

Annotations (3)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (24)

KeyFieldSource TableSource FieldDescription
CompanyCode P_RU_CommissionTradeInvoice12 CompanyCode Receiver Company Code
AccountingDocument P_RU_CommissionTradeInvoice12 AccountingDocument Journal Entry
FiscalYear P_RU_CommissionTradeInvoice12 FiscalYear G/L Fiscal Year
PostingDate P_RU_CommissionTradeInvoice12 PostingDate Posting Date for GR
TaxReportingDate P_RU_CommissionTradeInvoice12 TaxReportingDate Tax Reporting Date
IsReversal P_RU_CommissionTradeInvoice12 IsReversal Reversal doc.
IsReversed P_RU_CommissionTradeInvoice12 IsReversed Reversed?
ReverseDocument P_RU_CommissionTradeInvoice12 ReverseDocument Reversed With
ReverseDocumentFiscalYear P_RU_CommissionTradeInvoice12 ReverseDocumentFiscalYear Year
TaxItem P_RU_CommissionTradeInvoice12 TaxItem Tax Item
TaxItemGroup P_RU_CommissionTradeInvoice12 TaxItemGroup Tax doc. item number
TaxCode P_RU_CommissionTradeInvoice12 TaxCode Tax Code
TaxCountry P_RU_CommissionTradeInvoice12 TaxCountry Tax Ctry/Reg.
TaxJurisdiction P_RU_CommissionTradeInvoice12 TaxJurisdiction Tax Jurisdiction
RU_VATReturnVersion P_RU_CommissionTradeInvoice12 RU_VATReturnVersion VAT Return Version
RU_VATReturnSectionType P_RU_CommissionTradeInvoice12 RU_VATReturnSectionType Section Type
RU_VATReturnLine P_RU_CommissionTradeInvoice12 RU_VATReturnLine Line
RU_VATSubScenario P_RU_CommissionTradeInvoice12 RU_VATSubScenario Subscenario
RU_VATScenario P_RU_CommissionTradeInvoice12 RU_VATScenario VAT Scenario
RU_SourceDocumentType P_RU_CommissionTradeInvoice12 RU_SourceDocumentType
IsCorrectionInvoice P_RU_CommissionTradeInvoice12 IsCorrectionInvoice
DebitCreditCode P_RU_CommissionTradeInvoice12 DebitCreditCode Single-Character Flag
DebitCreditCodeCust P_RU_CommissionTradeInvoice12 DebitCreditCodeCust Single-Character Flag
IsNegativePosting P_RU_CommissionTradeInvoice12 IsNegativePosting Negative Posting

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_CommissionTradeInvoice13.
-- 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_RU_CommissionTradeInvoice13 AS
SELECT
  VatReporting.CompanyCode AS CompanyCode,
  VatReporting.AccountingDocument AS AccountingDocument,
  VatReporting.FiscalYear AS FiscalYear,
  VatReporting.PostingDate AS PostingDate,
  VatReporting.TaxReportingDate AS TaxReportingDate,
  VatReporting.IsReversal AS IsReversal,
  VatReporting.IsReversed AS IsReversed,
  VatReporting.ReverseDocument AS ReverseDocument,
  VatReporting.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  VatReporting.TaxItem AS TaxItem,
  VatReporting.TaxItemGroup AS TaxItemGroup,
  VatReporting.TaxCode AS TaxCode,
  VatReporting.TaxCountry AS TaxCountry,
  VatReporting.TaxJurisdiction AS TaxJurisdiction,
  VatReporting.RU_VATReturnVersion AS RU_VATReturnVersion,
  VatReporting.RU_VATReturnSectionType AS RU_VATReturnSectionType,
  VatReporting.RU_VATReturnLine AS RU_VATReturnLine,
  VatReporting.RU_VATSubScenario AS RU_VATSubScenario,
  VatReporting.RU_VATScenario AS RU_VATScenario,
  VatReporting.RU_SourceDocumentType AS RU_SourceDocumentType,
  VatReporting.IsCorrectionInvoice AS IsCorrectionInvoice,
  VatReporting.DebitCreditCode AS DebitCreditCode,
  VatReporting.DebitCreditCodeCust AS DebitCreditCodeCust,
  VatReporting.IsNegativePosting AS IsNegativePosting
FROM P_RU_CommissionTradeInvoice12 AS VatReporting
;