P_RU_TraceabilityOpsDocs2

DDL: P_RU_TRACEABILITYOPSDOCS2 SQL: PRUTRCBLYOPDOCS2 Type: view CONSUMPTION
28 Fields 1 Data Sources

Traceability operations invoice documents

P_RU_TraceabilityOpsDocs2 is a Consumption CDS View that provides data about "Traceability operations invoice documents" in SAP S/4HANA. It reads from 1 data source (P_RU_TraceabilityOpsDocs) and exposes 28 fields with key fields RU_RNPTRegistrationNumber, RU_RNPTRegistrationYear, RU_RNPTRegistrationItem, CompanyCode.

Data Sources (1)

SourceAliasJoin Type
P_RU_TraceabilityOpsDocs rnptDoc from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PRUTRCBLYOPDOCS2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Traceability operations invoice documents view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY RU_RNPTRegistrationNumber P_RU_TraceabilityOpsDocs RU_RNPTRegistrationNumber
KEY RU_RNPTRegistrationYear P_RU_TraceabilityOpsDocs RU_RNPTRegistrationYear
KEY RU_RNPTRegistrationItem P_RU_TraceabilityOpsDocs RU_RNPTRegistrationItem
KEY CompanyCode P_RU_TraceabilityOpsDocs CompanyCode Receiver Company Code
RU_RNPTRegnExternalNumber P_RU_TraceabilityOpsDocs RU_RNPTRegnExternalNumber
RU_RNPTSourceOperationType P_RU_TraceabilityOpsDocs RU_RNPTSourceOperationType
RU_RNPTPrimaryDocumentType P_RU_TraceabilityOpsDocs RU_RNPTPrimaryDocumentType
RU_RNPTPrimaryDocumentNumber P_RU_TraceabilityOpsDocs RU_RNPTPrimaryDocumentNumber
RU_RNPTPrimaryDocumentItem P_RU_TraceabilityOpsDocs RU_RNPTPrimaryDocumentItem
RU_RNPTPrimaryDocumentYear P_RU_TraceabilityOpsDocs RU_RNPTPrimaryDocumentYear
RU_RNPTPrimaryDocumentDate P_RU_TraceabilityOpsDocs RU_RNPTPrimaryDocumentDate
SupplierInvoice P_RU_TraceabilityOpsDocs SupplierInvoice
SupplierInvoiceFiscalYear P_RU_TraceabilityOpsDocs SupplierInvoiceFiscalYear
SupplierInvoiceItem P_RU_TraceabilityOpsDocs SupplierInvoiceItem
AccountingDocument P_RU_TraceabilityOpsDocs AccountingDocument Journal Entry
FiscalYear P_RU_TraceabilityOpsDocs FiscalYear G/L Fiscal Year
Quantity P_RU_TraceabilityOpsDocs Quantity Value
BaseUnitofMeasure P_RU_TraceabilityOpsDocs BaseUnitofMeasure Base Unit
TotalAmountInLocalCurrency P_RU_TraceabilityOpsDocs TotalAmountInLocalCurrency RNPT Item Amount
Currency P_RU_TraceabilityOpsDocs Currency Valuation Crcy
RU_RNPTOperationDate P_RU_TraceabilityOpsDocs RU_RNPTOperationDate
GoodsMovementType P_RU_TraceabilityOpsDocs GoodsMovementType Movement Type
GoodsMovementReasonCode P_RU_TraceabilityOpsDocs GoodsMovementReasonCode Reason for Mvmt
AssetTransactionType P_RU_TraceabilityOpsDocs AssetTransactionType Trans.Type
Invoice
InvoiceYear
SupplierInvoicethenSelseendasPartnerType
TaxCodeelseendasTaxCode

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_TraceabilityOpsDocs2.
-- 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: PRUTRCBLYOPDOCS2

CREATE VIEW P_RU_TraceabilityOpsDocs2 AS
SELECT
  rnptDoc.RU_RNPTRegistrationNumber AS RU_RNPTRegistrationNumber,
  rnptDoc.RU_RNPTRegistrationYear AS RU_RNPTRegistrationYear,
  rnptDoc.RU_RNPTRegistrationItem AS RU_RNPTRegistrationItem,
  rnptDoc.CompanyCode AS CompanyCode,
  rnptDoc.RU_RNPTRegnExternalNumber AS RU_RNPTRegnExternalNumber,
  rnptDoc.RU_RNPTSourceOperationType AS RU_RNPTSourceOperationType,
  rnptDoc.RU_RNPTPrimaryDocumentType AS RU_RNPTPrimaryDocumentType,
  rnptDoc.RU_RNPTPrimaryDocumentNumber AS RU_RNPTPrimaryDocumentNumber,
  rnptDoc.RU_RNPTPrimaryDocumentItem AS RU_RNPTPrimaryDocumentItem,
  rnptDoc.RU_RNPTPrimaryDocumentYear AS RU_RNPTPrimaryDocumentYear,
  rnptDoc.RU_RNPTPrimaryDocumentDate AS RU_RNPTPrimaryDocumentDate,
  rnptDoc.SupplierInvoice AS SupplierInvoice,
  rnptDoc.SupplierInvoiceFiscalYear AS SupplierInvoiceFiscalYear,
  rnptDoc.SupplierInvoiceItem AS SupplierInvoiceItem,
  rnptDoc.AccountingDocument AS AccountingDocument,
  rnptDoc.FiscalYear AS FiscalYear,
  rnptDoc.Quantity AS Quantity,
  rnptDoc.BaseUnitofMeasure AS BaseUnitofMeasure,
  rnptDoc.TotalAmountInLocalCurrency AS TotalAmountInLocalCurrency,
  rnptDoc.Currency AS Currency,
  rnptDoc.RU_RNPTOperationDate AS RU_RNPTOperationDate,
  rnptDoc.GoodsMovementType AS GoodsMovementType,
  rnptDoc.GoodsMovementReasonCode AS GoodsMovementReasonCode,
  rnptDoc.AssetTransactionType AS AssetTransactionType,
  coalesce( AccDoc.AccountingDocument, '' ) AS Invoice,
  coalesce( AccDoc.FiscalYear, '0000' ) AS InvoiceYear,
  case when rnptDoc.RU_RNPTPrimaryDocumentType = '02' or rnptDoc.RU_RNPTPrimaryDocumentType = '06' and rnptDoc.AccountingDocument <> '' then 'C' when rnptDoc.RU_RNPTPrimaryDocumentType = '01' or rnptDoc.RU_RNPTPrimaryDocumentType = '06' and rnptDoc.SupplierInvoice <> '' then 'S' else '' end as PartnerType AS SupplierInvoicethenSelseendasPartnerType,
  case when rnptDoc.RU_RNPTPrimaryDocumentType = '01' and rnptDoc.SupplierInvoice <> '' or rnptDoc.RU_RNPTPrimaryDocumentType = '06' and rnptDoc.SupplierInvoice <> '' and rnptDoc.AccountingDocument = '' then coalesce( MiroDocItem.TaxCode, '' ) when rnptDoc.RU_RNPTPrimaryDocumentType = '02' then coalesce( BillDocItem.TaxCode, '' ) when rnptDoc.RU_RNPTPrimaryDocumentType = '06' and rnptDoc.SupplierInvoice = '' and rnptDoc.AccountingDocument <> '' then coalesce( AccDocItem.TaxCode, '' ) else '' end as TaxCode AS TaxCodeelseendasTaxCode
FROM P_RU_TraceabilityOpsDocs AS rnptDoc
;

Learn More