C_JITPckgGrpItmRelToProdn

DDL: C_JITPCKGGRPITMRELTOPRODN Type: view_entity CONSUMPTION
33 Fields 1 Data Sources

Pakg Grp Rep Manf Itm: Consumption view

C_JITPckgGrpItmRelToProdn is a Consumption CDS View that provides data about "Pakg Grp Rep Manf Itm: Consumption view" in SAP S/4HANA. It reads from 1 data source (I_JITPckgGrpItmRelToProdn) and exposes 33 fields with key field JITPckgGrpItemRefUUID.

Data Sources (1)

SourceAliasJoin Type
I_JITPckgGrpItmRelToProdn I_JITPckgGrpItmRelToProdn from

Annotations (12)

NameValueLevelField
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Pakg Grp Rep Manf Itm: Consumption view view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Rep Manuf Seq JIT call for Out-Del Item view
UI.headerInfo.typeNamePlural Items view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value JITPckgGrpCellNumber view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY JITPckgGrpItemRefUUID JITPckgGrpItemRefUUID NodeID
JITPckgGrpUUID JITPckgGrpUUID NodeID
ReferenceDocumentUUID ReferenceDocumentUUID NodeID
JITPckgGrpCellNumber _JITPckgGrpItem JITPckgGrpCellNumber Slot ID
Material _JITCallCompGroupBasic CompGrpMatl Component Group Material
CompGrpMatl _JITCallCompGroupBasic CompGrpMatl Comp. Group Matl.
JITPckgGrpID _JITPckgGrpRelToProdn JITPckgGrpID Package ID
ExternalJITCallNumber External JIT Call Number
JITExtSequenceNumber _JITCallCompGroupBasic JITExtSequenceNumber Sequence Number
JITInternalStatusText
JITIntProcessingStatus _JITCallCompGroupBasic JITIntProcessingStatus Internal Processing Status
ProductionVersion _JITCallCompGroupBasic ProductionVersion Production Version
ProductionLine Production Line
ProductionEndDateendasProductionEndDate Production End Date
ProductName
MaterialName
JITPckgGrpStatus _JITPckgGrpRelToProdn JITPckgGrpStatus Packing Group Status
ShipToParty _JITPckgGrpRelToProdn ShipToParty Ship-To Party (obsolete)
JITPckgCntntType JITPckgCntntType Content Type
InternalJITCallNumber
BusinessPartnerName
JITCallTypeText
JITLifecycleStatusText
MatlUsageIndicatorText
CustSupplyArea _JITCallCompGroupBasic CustSupplyArea Cust. Supply Area
UnloadingPointName _JITCallCompGroupBasic UnloadingPointName Unloading Point Name
JITExternalStatusText
NumberOfAlerts
JITAltvHndlgUnitID _JITPckgGrpRelToProdn JITAltvHndlgUnitID Alt. PG ID Short
JITAltvHndlgUnitIDShrt _JITPckgGrpRelToProdn JITAltvHndlgUnitIDShrt Alt. PG ID Short
_JITPckgGrpRelToProdn _JITPckgGrpRelToProdn
_JITCallCompGroupBasic _JITCallCompGroupBasic
_JITPckgGrpHeader _JITPckgGrpHeader

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_JITPckgGrpItmRelToProdn.
-- 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 C_JITPckgGrpItmRelToProdn AS
SELECT
  JITPckgGrpItemRefUUID,
  JITPckgGrpUUID,
  ReferenceDocumentUUID,
  _JITPckgGrpItem.JITPckgGrpCellNumber AS JITPckgGrpCellNumber,
  _JITCallCompGroupBasic.CompGrpMatl AS Material,
  _JITCallCompGroupBasic.CompGrpMatl AS CompGrpMatl,
  _JITPckgGrpRelToProdn.JITPckgGrpID AS JITPckgGrpID,
  _JITCallCompGroupBasic._JITCallHeaderBasic.ExternalJITCallNumber AS ExternalJITCallNumber,
  _JITCallCompGroupBasic.JITExtSequenceNumber AS JITExtSequenceNumber,
  _JITCallCompGroupBasic._JITInternalStatus._Text[1: Language=$session.system_language].JITInternalStatusText AS JITInternalStatusText,
  _JITCallCompGroupBasic.JITIntProcessingStatus AS JITIntProcessingStatus,
  _JITCallCompGroupBasic.ProductionVersion AS ProductionVersion,
  _JITCallCompGroupBasic._ProductionVersion.ProductionLine AS ProductionLine,
  case when JITPckgCntntType = '1' then _JITCallCompGroupBasic.ProductionEndDate else _JITPckgGrpRelToProdn.ProductionEndDate end as ProductionEndDate AS ProductionEndDateendasProductionEndDate,
  _JITCallCompGroupBasic._ProductCompGrp._Text[1:Language = $session.system_language].ProductName AS ProductName,
  _JITCallCompGroupBasic._ProductCompGrp._Text[1:Language = $session.system_language].ProductName AS MaterialName,
  _JITPckgGrpRelToProdn.JITPckgGrpStatus AS JITPckgGrpStatus,
  _JITPckgGrpRelToProdn.ShipToParty AS ShipToParty,
  JITPckgCntntType,
  _JITCallCompGroupBasic._JITCallHeaderBasic.InternalJITCallNumber AS InternalJITCallNumber,
  _JITPckgGrpHeader._Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _JITCallCompGroupBasic._JITCallHeaderBasic._JITCallType._Text[1:Language = $session.system_language].JITCallTypeText AS JITCallTypeText,
  _JITCallCompGroupBasic._JITCallHeaderBasic._JITLifecycleStatus._Text[1:Language = $session.system_language].JITLifecycleStatusText AS JITLifecycleStatusText,
  _JITCallCompGroupBasic._JITCallHeaderBasic._MatlUsageIndicator._Text[1:Language = $session.system_language].MatlUsageIndicatorText AS MatlUsageIndicatorText,
  _JITCallCompGroupBasic.CustSupplyArea AS CustSupplyArea,
  _JITCallCompGroupBasic.UnloadingPointName AS UnloadingPointName,
  _JITCallCompGroupBasic._SupplierExtStatus._JITExternalStatusText[1: Language=$session.system_language].JITExternalStatusText AS JITExternalStatusText,
  cast( 0 as int4 ) AS NumberOfAlerts,
  _JITPckgGrpRelToProdn.JITAltvHndlgUnitID AS JITAltvHndlgUnitID,
  _JITPckgGrpRelToProdn.JITAltvHndlgUnitIDShrt AS JITAltvHndlgUnitIDShrt
FROM I_JITPckgGrpItmRelToProdn
;

Learn More