I_SummarizedJITCallOutpReqItem

DDL: I_SUMMARIZEDJITCALLOUTPREQITEM SQL: ISUMJITCOPREQITM Type: view COMPOSITE Package: LAPA_OM

Output Request Item for Summarized JIT Call

I_SummarizedJITCallOutpReqItem is a Composite CDS View that provides data about "Output Request Item for Summarized JIT Call" in SAP S/4HANA. It reads from 2 data sources (I_OutputRequestItem, I_SummarizedJITCall) and exposes 18 fields. Part of development package LAPA_OM.

Data Sources (2)

SourceAliasJoin Type
I_OutputRequestItem OutputRequestItem inner
I_SummarizedJITCall SummarizedJITCall from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISUMJITCOPREQITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Output Request Item for Summarized JIT Call view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (18)

KeyFieldSource TableSource FieldDescription
JITCallNumber I_SummarizedJITCall JITCallNumber JIT Call Number
Plant I_SummarizedJITCall Plant Valuation Area
Supplier I_SummarizedJITCall Supplier Supplier
JITCallProfile I_SummarizedJITCall JITCallProfile JIT Call Prof.
SumzdJITCallPlndDelivDateTime I_SummarizedJITCall SumzdJITCallPlndDelivDateTime JIT call time
OutputPartnerForSumzdJITCall I_SummarizedJITCall OutputPartnerForSumzdJITCall Output partner
OutputControlApplObjectType I_OutputRequestItem OutputControlApplObjectType Appl. Object Type
OutputDocumentType I_OutputRequestItem OutputDocumentType
OutputChannel I_OutputRequestItem OutputChannel
RecipientRole I_OutputRequestItem RecipientRole
DispatchTime I_OutputRequestItem DispatchTime
OutputRequestItemStatus I_OutputRequestItem OutputRequestItemStatus
PrintCopyNumber I_OutputRequestItem PrintCopyNumber
Recipient I_OutputRequestItem Recipient To
_Supplier I_SummarizedJITCall _Supplier
_SupplierCompanyByPlant I_SummarizedJITCall _SupplierCompanyByPlant
_OutputPartner I_SummarizedJITCall _OutputPartner
_OutputPartnerCompanyByPlant I_SummarizedJITCall _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 I_SummarizedJITCallOutpReqItem.
-- 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: ISUMJITCOPREQITM

CREATE VIEW I_SummarizedJITCallOutpReqItem AS
SELECT
  SummarizedJITCall.JITCallNumber AS JITCallNumber,
  SummarizedJITCall.Plant AS Plant,
  SummarizedJITCall.Supplier AS Supplier,
  SummarizedJITCall.JITCallProfile AS JITCallProfile,
  SummarizedJITCall.SumzdJITCallPlndDelivDateTime AS SumzdJITCallPlndDelivDateTime,
  SummarizedJITCall.OutputPartnerForSumzdJITCall AS OutputPartnerForSumzdJITCall,
  OutputRequestItem.OutputControlApplObjectType AS OutputControlApplObjectType,
  OutputRequestItem.OutputDocumentType AS OutputDocumentType,
  OutputRequestItem.OutputChannel AS OutputChannel,
  OutputRequestItem.RecipientRole AS RecipientRole,
  OutputRequestItem.DispatchTime AS DispatchTime,
  OutputRequestItem.OutputRequestItemStatus AS OutputRequestItemStatus,
  OutputRequestItem.PrintCopyNumber AS PrintCopyNumber,
  OutputRequestItem.Recipient AS Recipient,
  SummarizedJITCall._Supplier AS _Supplier,
  SummarizedJITCall._SupplierCompanyByPlant AS _SupplierCompanyByPlant,
  SummarizedJITCall._OutputPartner AS _OutputPartner,
  SummarizedJITCall._OutputPartnerCompanyByPlant AS _OutputPartnerCompanyByPlant
FROM I_SummarizedJITCall AS SummarizedJITCall
INNER JOIN I_OutputRequestItem AS OutputRequestItem ON /* join condition not captured in parsed metadata */
;