I_JITPckgGrpHandlingUnitRef

DDL: I_JITPCKGGRPHANDLINGUNITREF Type: view_entity COMPOSITE Package: NJIT_APP_REUSE_LIBRARY
8 Fields 1 Data Sources 2 Associations 1 OData Services 1 Fiori Apps

Composite view for JIT Pckg Group HU Ref

I_JITPckgGrpHandlingUnitRef is a Composite CDS View that provides data about "Composite view for JIT Pckg Group HU Ref" in SAP S/4HANA. It reads from 1 data source (I_JITPckgGrpDocRefBasic) and exposes 8 fields with key field JITDocRefUUID. It has 2 associations to related views. It is exposed through 1 OData service (NJIT_UI_JITCOMPGRPPROCG). It is used in 1 Fiori application: Manage Customer JIT Calls - by Component Groups. Part of development package NJIT_APP_REUSE_LIBRARY.

Data Sources (1)

SourceAliasJoin Type
I_JITPckgGrpDocRefBasic I_JITPckgGrpDocRefBasic from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_JITHandlingUnitHeader _HandlingUnitHeaderCombined $projection.BusinessTransactionDocument = _HandlingUnitHeaderCombined.HandlingUnitExternalID and $projection.BusinessTransactionDocType = 'X'
[1..1] I_JITBusTransDocType _JITBusTransDocType $projection.BusinessTransactionDocType = _JITBusTransDocType.BusinessTransactionDocType

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Composite view for JIT Pckg Group HU Ref view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view

OData Services (1)

ServiceBindingVersionContractRelease
NJIT_UI_JITCOMPGRPPROCG NJIT_UI_JITCOMPGRPPROCG V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F6077 Manage Customer JIT Calls - by Component Groups Transactional This application shall be used by Material Planners to Manage/ Monitor Customer JIT Calls from Component Group perspective.

Manage Customer JIT Calls - by Component Groups

Business Role: Others

With this application, you can view customer JIT calls for each component group in list view. Each component group"s details can be viewed by navigating to detail view. Various filter criteria could be used to restrict component groups that are managed/viewed.

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY JITDocRefUUID JITDocRefUUID NodeID
JITPckgGrpUUID JITPckgGrpUUID NodeID
BusinessTransactionDocType BusinessTransactionDocType BTD Type Code
BusinessTransactionDocument BusinessTransactionDocument BTD ID
HandlingUnitExternalID BTD ID
_HandlingUnitHeaderCombined _HandlingUnitHeaderCombined
_JITPckgGrpHeader _JITPckgGrpHeader
_JITBusTransDocType _JITBusTransDocType

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_JITPckgGrpHandlingUnitRef.
-- 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.

CREATE VIEW I_JITPckgGrpHandlingUnitRef AS
SELECT
  JITDocRefUUID,
  JITPckgGrpUUID,
  BusinessTransactionDocType,
  BusinessTransactionDocument,
  cast (BusinessTransactionDocument as exidv) AS HandlingUnitExternalID
FROM I_JITPckgGrpDocRefBasic
LEFT OUTER JOIN I_JITHandlingUnitHeader AS _HandlingUnitHeaderCombined ON BusinessTransactionDocument = _HandlingUnitHeaderCombined.HandlingUnitExternalID AND BusinessTransactionDocType = 'X'  -- association [0..1]
LEFT OUTER JOIN I_JITBusTransDocType AS _JITBusTransDocType ON BusinessTransactionDocType = _JITBusTransDocType.BusinessTransactionDocType  -- association [1..1]
;

Learn More