I_SuplrActivitySupplierAPI01

DDL: I_SUPLRACTIVITYSUPPLIERAPI01 SQL: ISUPACTSUPAPI01 Type: view COMPOSITE Package: VDM_SLC_ACT

Supplier for Supplier Activity

I_SuplrActivitySupplierAPI01 (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_SuplrActivitySupplierAPI01 is a Composite CDS View that provides data about "Supplier for Supplier Activity" in SAP S/4HANA. It reads from 1 data source (I_SupplierActivitySuplrParty) and exposes 16 fields with key field SuplrActyPartyUUID. Part of development package VDM_SLC_ACT.

SAP Help Documentation

CategoryProcurement-Related Activity
StatusReleased
Purpose
This CDS view displays the assignment of suppliers to procurement-related activities. It provides the prerequisites for answering the following business questions: Which procurement-related activity is a supplier assigned to? Which suppliers are assigned to a specific procurement-related activity?

Prerequisites
You are authorized to access the following business objects: Procurement-Related Activity Supplier

Structure
Object types This view relates to the following SAP object type: Procurement-Related Activity Attributes Some important attributes are: Supplier ID ID of the business partner that is assigned to the supplier GUID of the business partner that is assigned to the supplier Authorization group that the supplier is assigned to Note The attribute values for supplier ID and authorization group are determined from the supplier master data.

View on SAP Help Portal →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessSourcing & Procurement
Application ComponentSLC-ACT
CapabilitiesData Source in SQL Select,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities
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 This CDS view displays the assignment of suppliers to procurement-related activities. It provides the prerequisites for answering the following business questions:<ul> <li> <p>Which procurement-related activity is a supplier assigned to?</p> </li> <li> <p>Which suppliers are assigned to a specific procurement-related activity?</p> </li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_SupplierActivitySuplrParty I_SupplierActivitySuplrParty from

Annotations (12)

NameValueLevelField
EndUserText.label Supplier for Supplier Activity view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ISUPACTSUPAPI01 view
AbapCatalog.compiler.compareFilter true view
Metadata.ignorePropagatedAnnotations true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SuplrActyPartyUUID SuplrActyPartyUUID Activity Party UUID
SuplrActyUUID SuplrActyUUID Activity UUID
BusinessPartner BusinessPartner Business Partner Number
AuthorizationGroup AuthorizationGroup Authorization Group
Supplier Supplier Supplier
DataController1 DataController1 BP: Data Controller (Internal Use Only)
DataController2 DataController2 BP: Data Controller (Internal Use Only)
DataController3 DataController3 BP: Data Controller (Internal Use Only)
DataController4 DataController4 BP: Data Controller (Internal Use Only)
DataController5 DataController5 BP: Data Controller (Internal Use Only)
DataController6 DataController6 BP: Data Controller (Internal Use Only)
DataController7 DataController7 BP: Data Controller (Internal Use Only)
DataController8 DataController8 BP: Data Controller (Internal Use Only)
DataController9 DataController9 BP: Data Controller (Internal Use Only)
DataController10 DataController10 BP: Data Controller (Internal Use Only)
DataControllerSet DataControllerSet BP: Data Controller Set Flag

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_SuplrActivitySupplierAPI01.
-- 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: ISUPACTSUPAPI01

CREATE VIEW I_SuplrActivitySupplierAPI01 AS
SELECT
  SuplrActyPartyUUID,
  SuplrActyUUID,
  BusinessPartner,
  AuthorizationGroup,
  Supplier,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10,
  DataControllerSet
FROM I_SupplierActivitySuplrParty
;