C_SumzdJITCallEmailDataPrvdr

DDL: C_SUMZDJITCALLEMAILDATAPRVDR SQL: CSUMJITCALLEMAIL Type: view CONSUMPTION

Summarized JIT Call Email Data Provider

C_SumzdJITCallEmailDataPrvdr (Consumption)

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

Manufacturing

C_SumzdJITCallEmailDataPrvdr is a Consumption CDS View that provides data about "Summarized JIT Call Email Data Provider" in SAP S/4HANA. It reads from 1 data source (I_SummarizedJITCall) and exposes 10 fields with key field JITCallNumber. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Kanban Summarized JIT Call
Purpose
This CDS view forms the basis for the predelivered Output Management email template for summarized JIT calls (PP_SUM_JIT_CALL_EMAIL). This CDS view provides the fields that can be used in the template for the email message body, specifically focusing on the output partner and plant information. This CDS view provides the data to answer the following business questions: Which fields are included in the email template for Output Management for Summarized JIT Calls? 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 Users who want to use this CDS view must have a role with the following restriction types set to read access: WERKS (Plant) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Important Fields Important fields in this view include the following: Field Name Description JITCallNumber JIT Call Number Supplier Supplier OutputPartnerForSumzdJITCall Output Partner JITCallProfile JIT Call Profile Plant Plant PlantName Plant Name

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentPP-KAB
CapabilitiesOutput: Email Data Provider
PackageManufacturing for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_SummarizedJITCall I_SummarizedJITCall from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Plant _Plant $projection.Plant = _Plant.Plant

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSUMJITCALLEMAIL view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #OUTPUT_EMAIL_DATA_PROVIDER view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Summarized JIT Call Email Data Provider view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY JITCallNumber JITCallNumber JIT Call Number
Supplier Supplier Supplier's Account Number
OutputPartnerForSumzdJITCall Output partner
JITCallProfile JITCallProfile JIT Call Profile
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
_Supplier _Supplier
_SupplierCompanyByPlant _SupplierCompanyByPlant
_OutputPartner _OutputPartner
_OutputPartnerCompanyByPlant _OutputPartnerCompanyByPlant

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 C_SumzdJITCallEmailDataPrvdr.
-- 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: CSUMJITCALLEMAIL

CREATE VIEW C_SumzdJITCallEmailDataPrvdr AS
SELECT
  JITCallNumber,
  Supplier,
  cast(OutputPartnerForSumzdJITCall as vdm_pabnpl preserving type) AS OutputPartnerForSumzdJITCall,
  JITCallProfile,
  Plant,
  _Plant.PlantName AS PlantName
FROM I_SummarizedJITCall
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
;