I_JITOutbPlanningObject

DDL: I_JITOUTBPLANNINGOBJECT SQL: IJITOUTBPLNGOBJT Type: view COMPOSITE
18 Fields 3 Data Sources

JIT S2P - S2L Pegging Area / Material/ Location mapping

I_JITOutbPlanningObject is a Composite CDS View that provides data about "JIT S2P - S2L Pegging Area / Material/ Location mapping" in SAP S/4HANA. It reads from 3 data sources (I_JITOutbLocationId, I_JITOutbMaterialId, I_JITOutbPeggingArea) and exposes 18 fields with key field PeggingAreaUUID.

Data Sources (3)

SourceAliasJoin Type
I_JITOutbLocationId _JITOutbLocationId from
I_JITOutbMaterialId _JITOutbMaterialId inner
I_JITOutbPeggingArea _JITOutbPeggingArea inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IJITOUTBPLNGOBJT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
EndUserText.label JIT S2P - S2L Pegging Area / Material/ Location mapping view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY PeggingAreaUUID PeggingAreaUUID Pegging Area
ProductInternalUUID I_JITOutbPeggingArea ProductInternalUUID Product ID
LocationUUID I_JITOutbPeggingArea LocationUUID UUID
PlanningVersionUUID I_JITOutbPeggingArea PlanningVersionUUID Plan Version
AccountAssignmentUUID I_JITOutbPeggingArea AccountAssignmentUUID Key
JITOutbPlanningSegmentType I_JITOutbPeggingArea JITOutbPlanningSegmentType PlngSegmentType
JITOutbPlanningEvent I_JITOutbPeggingArea JITOutbPlanningEvent Event
JITOutbChangeMethodCode I_JITOutbPeggingArea JITOutbChangeMethodCode Method
ProductMaterial I_JITOutbMaterialId ProductMaterial
Product I_JITOutbMaterialId Product Product Sold
LogicalSystemName I_JITOutbMaterialId LogicalSystemName Source system
LocationExternalID I_JITOutbLocationId LocationExternalID Ext. Location Id
LocationType I_JITOutbLocationId LocationType Location Type
Location I_JITOutbLocationId Location Text
Customer I_JITOutbLocationId Customer Sold-to Party
LocationPlant I_JITOutbLocationId LocationPlant Location Plant
MRPAreaStorageLocation I_JITOutbLocationId MRPAreaStorageLocation Storage Loc.
CompanyCode I_JITOutbLocationId CompanyCode Receiver Company Code

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_JITOutbPlanningObject.
-- 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: IJITOUTBPLNGOBJT

CREATE VIEW I_JITOutbPlanningObject AS
SELECT
  PeggingAreaUUID,
  _JITOutbPeggingArea.ProductInternalUUID AS ProductInternalUUID,
  _JITOutbPeggingArea.LocationUUID AS LocationUUID,
  _JITOutbPeggingArea.PlanningVersionUUID AS PlanningVersionUUID,
  _JITOutbPeggingArea.AccountAssignmentUUID AS AccountAssignmentUUID,
  _JITOutbPeggingArea.JITOutbPlanningSegmentType AS JITOutbPlanningSegmentType,
  _JITOutbPeggingArea.JITOutbPlanningEvent AS JITOutbPlanningEvent,
  _JITOutbPeggingArea.JITOutbChangeMethodCode AS JITOutbChangeMethodCode,
  _JITOutbMaterialId.ProductMaterial AS ProductMaterial,
  _JITOutbMaterialId.Product AS Product,
  _JITOutbMaterialId.LogicalSystemName AS LogicalSystemName,
  _JITOutbLocationId.LocationExternalID AS LocationExternalID,
  _JITOutbLocationId.LocationType AS LocationType,
  _JITOutbLocationId.Location AS Location,
  _JITOutbLocationId.Customer AS Customer,
  _JITOutbLocationId.LocationPlant AS LocationPlant,
  _JITOutbLocationId.MRPAreaStorageLocation AS MRPAreaStorageLocation,
  _JITOutbLocationId.CompanyCode AS CompanyCode
FROM I_JITOutbLocationId AS _JITOutbLocationId
INNER JOIN I_JITOutbPeggingArea AS _JITOutbPeggingArea ON /* join condition not captured in parsed metadata */
INNER JOIN I_JITOutbMaterialId AS _JITOutbMaterialId ON /* join condition not captured in parsed metadata */
;

Learn More