I_DeletedSupplierInvcSuccessor

DDL: I_DELETEDSUPPLIERINVCSUCCESSOR SQL: ISUPLRINVDELREF Type: view BASIC
3 Fields 1 Data Sources

Maps Reference of deleted invoices to succesor document

I_DeletedSupplierInvcSuccessor is a Basic CDS View that provides data about "Maps Reference of deleted invoices to succesor document" in SAP S/4HANA. It reads from 1 data source (rbkp) and exposes 3 fields with key field SupplierInvoiceIDByInvcgParty.

Data Sources (1)

SourceAliasJoin Type
rbkp rbkp from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISUPLRINVDELREF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Maps Reference of deleted invoices to succesor document view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY SupplierInvoiceIDByInvcgParty
SupplierInvoice rbkp belnr SD Document
FiscalYear rbkp gjahr Settlement Year

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 I_DeletedSupplierInvcSuccessor.
-- 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: ISUPLRINVDELREF

CREATE VIEW I_DeletedSupplierInvcSuccessor AS
SELECT
  cast(concat(concat('&&', belnr), gjahr) as xblnr) AS SupplierInvoiceIDByInvcgParty,
  rbkp.belnr AS SupplierInvoice,
  rbkp.gjahr AS FiscalYear
FROM rbkp
;

Learn More