I_SummarizedJITCallItem

DDL: I_SUMMARIZEDJITCALLITEM SQL: IPPSUMJITCALLITM Type: view BASIC
20 Fields 1 Data Sources 5 Associations

Summarized JIT Call Item

I_SummarizedJITCallItem (Basic)

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

Manufacturing

I_SummarizedJITCallItem is a Basic CDS View that provides data about "Summarized JIT Call Item" in SAP S/4HANA. It reads from 1 data source (pabit) and exposes 20 fields with key fields JITCallNumber, JITCallItemNumber. It has 5 associations to related views.

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentPP-KAB-VDM
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageManufacturing for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides access to the items of Kanban summarized JIT calls.</p> <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
pabit pabit from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_SummarizedJITCall _SummarizedJITCall $projection.JITCallNumber = _SummarizedJITCall.JITCallNumber
[0..1] I_Supplier _Supplier $projection.supplier = _Supplier.Supplier
[0..1] I_SupplierCompanyByPlant _SupplierCompanyByPlant $projection.supplier = _SupplierCompanyByPlant.Supplier and $projection.plant = _SupplierCompanyByPlant.Plant
[0..1] I_Supplier _OutputPartner $projection.outputpartnerforsumzdjitcall = _OutputPartner.Supplier
[0..1] I_SupplierCompanyByPlant _OutputPartnerCompanyByPlant $projection.outputpartnerforsumzdjitcall = _OutputPartnerCompanyByPlant.Supplier and $projection.plant = _OutputPartnerCompanyByPlant.Plant

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IPPSUMJITCALLITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Summarized JIT Call Item view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey JITCallItemNumber view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY JITCallNumber pabnum JIT Call Number
KEY JITCallItemNumber pabpos JIT call item
Product matnr Material Number
SummarizedJITCallQtyInBaseUnit pabmng JIT Call Quantity
BaseUnit meins Base Unit of Measure
PurchasingDocument ebeln Agreement Number
PurchasingDocumentItem ebelp Item pur. doc.
UnloadingPointName ablad Unloading Point
ProductionSupplyArea prvbe Production Supply Area
SumzdJITCallPlndDelivDateTime pabtim Time for a JIT call
GoodsReceiptIsExisting pabwef Goods receipt flag for JIT call
GoodsReceiptQtyInBaseUnit pabwem Goods receipt qty for a JIT call
Plant _SummarizedJITCall Plant Valuation Area
_SummarizedJITCall _SummarizedJITCall
Supplier _SummarizedJITCall Supplier Supplier's Account Number
_Supplier _Supplier
_SupplierCompanyByPlant _SupplierCompanyByPlant
OutputPartnerForSumzdJITCall _SummarizedJITCall OutputPartnerForSumzdJITCall Output partner for JIT call
_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 I_SummarizedJITCallItem.
-- 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: IPPSUMJITCALLITM

CREATE VIEW I_SummarizedJITCallItem AS
SELECT
  pabnum AS JITCallNumber,
  pabpos AS JITCallItemNumber,
  matnr AS Product,
  pabmng AS SummarizedJITCallQtyInBaseUnit,
  meins AS BaseUnit,
  ebeln AS PurchasingDocument,
  ebelp AS PurchasingDocumentItem,
  ablad AS UnloadingPointName,
  prvbe AS ProductionSupplyArea,
  pabtim AS SumzdJITCallPlndDelivDateTime,
  pabwef AS GoodsReceiptIsExisting,
  pabwem AS GoodsReceiptQtyInBaseUnit,
  _SummarizedJITCall.Plant AS Plant,
  _SummarizedJITCall.Supplier AS Supplier,
  _SummarizedJITCall.OutputPartnerForSumzdJITCall AS OutputPartnerForSumzdJITCall
FROM pabit
LEFT OUTER JOIN I_SummarizedJITCall AS _SummarizedJITCall ON JITCallNumber = _SummarizedJITCall.JITCallNumber  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompanyByPlant AS _SupplierCompanyByPlant ON supplier = _SupplierCompanyByPlant.Supplier AND plant = _SupplierCompanyByPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _OutputPartner ON outputpartnerforsumzdjitcall = _OutputPartner.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompanyByPlant AS _OutputPartnerCompanyByPlant ON outputpartnerforsumzdjitcall = _OutputPartnerCompanyByPlant.Supplier AND plant = _OutputPartnerCompanyByPlant.Plant  -- association [0..1]
;

Learn More