I_SuplrInvcChgDocAPI01

DDL: I_SUPLRINVCCHGDOCAPI01 SQL: ISINVCHGDOCAPI01 Type: view COMPOSITE Package: VDM_MM_IV_SI_API

Change Documents for Supplier Invoices

I_SuplrInvcChgDocAPI01 (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Sourcing & Procurement

I_SuplrInvcChgDocAPI01 is a Composite CDS View that provides data about "Change Documents for Supplier Invoices" in SAP S/4HANA. It reads from 1 data source (I_SupplierInvoiceChangeDoc) and exposes 10 fields with key fields ChangeDocObject, ChangeDocObjectClass, ChangeDocument. It has 1 association to related views. Part of development package VDM_MM_IV_SI_API.

SAP Help Documentation

CategoryCDS Views for Invoice Processing
Purpose
This CDS view is used to read the administration data of change documents if a business object is changed. The change document contains, for example, the user name of the person who made the change. This CDS view provides the data to answer the following business questions: Who changed the business object? When was the change made? Which invoices were changed at a certain point in time? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Note You need privileged access for this CDS view, which means, that you must develop your own implementation with your own authorization concept.

Structure
Parameters The parameters of the CDS view are as follows: CreatedByUser used to specify the user who created the object. FullName used to specify the full name. FirstName used to specify the first name. LastName used to specify the last name. CreationDate used to specify the creation date. CreationTime used to specify the creation time.

View on SAP Help Portal →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessSourcing & Procurement
Application ComponentMM-IV-LIV-2CL
CapabilitiesData Source for Defining CDS Entities,Data Source in SQL Select
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageSourcing and Procurement for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view is used to read the administration data of change documents if a business object is changed. The change document contains, for example, the user name of the person who made the change.</p> This CDS view provides the data to answer the following business questions:<ul> <li> <p>Who changed the business object? </p> </li> <li> <p>When was the change made?</p> </li> <li> <p>Which invoices were changed at a certain point in time?</p> </li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_SupplierInvoiceChangeDoc I_SupplierInvoiceChangeDoc from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_SuplrInvcChgDocItmAPI01 _SuplrInvcChgDocItmAPI01 $projection.ChangeDocument = _SuplrInvcChgDocItmAPI01.ChangeDocument and $projection.ChangeDocObject = _SuplrInvcChgDocItmAPI01.ChangeDocObject and $projection.ChangeDocObjectClass = _SuplrInvcChgDocItmAPI01.ChangeDocObjectClass

Annotations (14)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISINVCHGDOCAPI01 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Change Documents for Supplier Invoices view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #NONE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.preserveKey true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject ChangeDocObject Object Value
KEY ChangeDocObjectClass ChangeDocObjectClass Change Doc. Object
KEY ChangeDocument ChangeDocument Change Number of Document
CreatedByUser CreatedByUser User Name of Person Making Change in Change Document
FullName FullName Full Name of Person
FirstName FirstName First Name
LastName LastName Last Name
CreationDate CreationDate Creation Date of Change Document
CreationTime CreationTime Time of Change
_SuplrInvcChgDocItmAPI01 _SuplrInvcChgDocItmAPI01

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_SuplrInvcChgDocAPI01.
-- 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: ISINVCHGDOCAPI01

CREATE VIEW I_SuplrInvcChgDocAPI01 AS
SELECT
  ChangeDocObject,
  ChangeDocObjectClass,
  ChangeDocument,
  CreatedByUser,
  FullName,
  FirstName,
  LastName,
  CreationDate,
  CreationTime
FROM I_SupplierInvoiceChangeDoc
LEFT OUTER JOIN I_SuplrInvcChgDocItmAPI01 AS _SuplrInvcChgDocItmAPI01 ON ChangeDocument = _SuplrInvcChgDocItmAPI01.ChangeDocument AND ChangeDocObject = _SuplrInvcChgDocItmAPI01.ChangeDocObject AND ChangeDocObjectClass = _SuplrInvcChgDocItmAPI01.ChangeDocObjectClass  -- association [1..*]
;