I_JITScanPackingGroup

DDL: I_JITSCANPACKINGGROUP Type: view_entity TRANSACTIONAL Package: NJIT_APP_SCANNING
60 Fields 1 Data Sources

Packing group to be scanned

I_JITScanPackingGroup is a Transactional CDS View that provides data about "Packing group to be scanned" in SAP S/4HANA. It reads from 1 data source (R_JITPackingGroupTP) and exposes 60 fields with key field JITPckgGrpUUID. Part of development package NJIT_APP_SCANNING.

Data Sources (1)

SourceAliasJoin Type
R_JITPackingGroupTP R_JITPackingGroupTP from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Packing group to be scanned view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY JITPckgGrpUUID JITPckgGrpUUID NodeID
JITPckgGrpID JITPckgGrpID Package Group ID
JITPckgGrpDefUUID JITPckgGrpDefUUID NodeID
JITPckgGrpStatus JITPckgGrpStatus Packing Group Status
ShipToParty ShipToParty Ship-To Party (obsolete)
UnloadingPointName UnloadingPointName Unloading Point Name
ShippingPoint ShippingPoint Shipping Point
PlannedShippingDateTime PlannedShippingDateTime Pl. Shippg Date Time
RequirementDateTime RequirementDateTime Time Stamp
DeliveryCreationDate DeliveryCreationDate Delivery Date
MaterialAvailabilityDateTime MaterialAvailabilityDateTime Time Stamp
ProductionStartDate ProductionStartDate Start of Production
ProductionEndDate ProductionEndDate Production End Date
CustSupplyArea CustSupplyArea Cust. Supply Area
CustAssemblyLoc CustAssemblyLoc Assembly Location
Plant Plant Valuation Area
JITComponentIsReordered JITComponentIsReordered Usage Type
JITPackageLevel JITPackageLevel Packing Level
StorageLocation StorageLocation StorageLocation
JITPackingGroupIsNested JITPackingGroupIsNested Packing Nested Ind.
CustomerUUID CustomerUUID NodeID
JITAltvHndlgUnitID JITAltvHndlgUnitID Alt. PG ID Short
JITAltvHndlgUnitIDShrt JITAltvHndlgUnitIDShrt Alt. PG ID Short
RepetitiveManufacturingIsAllwd RepetitiveManufacturingIsAllwd Repetitive Manufacturing Enabled
JITDelivSqncGrpID JITDelivSqncGrpID Del. Seq. Grp. ID
JITDelivSqncGrpUUID JITDelivSqncGrpUUID NodeID
JITExtSequenceNumberFrom JITExtSequenceNumberFrom Ext.Seq. Number
JITExtSequenceNumberTo JITExtSequenceNumberTo Ext.Seq. Number
JITFormattedSequenceNmbrFrom JITFormattedSequenceNmbrFrom Formtd Seq. No
JITFormattedSequenceNmbrTo JITFormattedSequenceNmbrTo Formtd Seq. No
JITExtStatusUpdtdOn JITExtStatusUpdtdOn Ext. Status Updtd
JITIntStatusUpdtdOn JITIntStatusUpdtdOn Int Status Updtd On
DeliveryStatus DeliveryStatus Delivery Status
GoodsMovementStatus GoodsMovementStatus Gds Movemt Status
JITBillingStatus JITBillingStatus Billing Status
JITReleaseToProductionStatus JITReleaseToProductionStatus R2PStatus
JITProdnConfirmationStatus JITProdnConfirmationStatus Confirm Prod. Status
JITReleaseForPackingStatus JITReleaseForPackingStatus Rls.Pack. Sts.
JITPackingConfirmationStatus JITPackingConfirmationStatus Packing Status
HandlingUnitStatus HandlingUnitStatus Handling Unit Status
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
ChangedOnDateTime ChangedOnDateTime Last Changed At
LastChangedByUser LastChangedByUser User Name
JITPckgGrpStatusTxt
IsBusinessPurposeCompleted _Customer IsBusinessPurposeCompleted Purpose Completed
AuthorizationGroup _Customer AuthorizationGroup AuthorizGroup
ExtJITDelivSqncGrpID _JITDelivSqncGrpHeader ExtJITDelivSqncGrpID Ext Group Number
_CreatedByUser _CreatedByUser
_Customer _Customer
_JITDelivSqncGrpHeader _JITDelivSqncGrpHeader
_JITPackingGroupActionLogTP _JITPackingGroupActionLogTP
_JITPackingGroupDocumentRefTP _JITPackingGroupDocumentRefTP
_JITPackingGroupItemTP _JITPackingGroupItemTP
_JITPackingGrpCellCnsmpnTP _JITPackingGrpCellCnsmpnTP
_JITPckgGrpDef _JITPckgGrpDef
_JITPckgGrpStatus _JITPckgGrpStatus
_LastChangedByUser _LastChangedByUser
_Plant _Plant
_StorageLocation _StorageLocation

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_JITScanPackingGroup.
-- 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_JITScanPackingGroup AS
SELECT
  JITPckgGrpUUID,
  JITPckgGrpID,
  JITPckgGrpDefUUID,
  JITPckgGrpStatus,
  ShipToParty,
  UnloadingPointName,
  ShippingPoint,
  PlannedShippingDateTime,
  RequirementDateTime,
  DeliveryCreationDate,
  MaterialAvailabilityDateTime,
  ProductionStartDate,
  ProductionEndDate,
  CustSupplyArea,
  CustAssemblyLoc,
  Plant,
  JITComponentIsReordered,
  JITPackageLevel,
  StorageLocation,
  JITPackingGroupIsNested,
  CustomerUUID,
  JITAltvHndlgUnitID,
  JITAltvHndlgUnitIDShrt,
  RepetitiveManufacturingIsAllwd,
  JITDelivSqncGrpID,
  JITDelivSqncGrpUUID,
  JITExtSequenceNumberFrom,
  JITExtSequenceNumberTo,
  JITFormattedSequenceNmbrFrom,
  JITFormattedSequenceNmbrTo,
  JITExtStatusUpdtdOn,
  JITIntStatusUpdtdOn,
  DeliveryStatus,
  GoodsMovementStatus,
  JITBillingStatus,
  JITReleaseToProductionStatus,
  JITProdnConfirmationStatus,
  JITReleaseForPackingStatus,
  JITPackingConfirmationStatus,
  HandlingUnitStatus,
  CreationDateTime,
  CreatedByUser,
  ChangedOnDateTime,
  LastChangedByUser,
  _JITPckgGrpStatus._Text[1: Language=$session.system_language].JITPckgGrpStatusTxt AS JITPckgGrpStatusTxt,
  _Customer.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _Customer.AuthorizationGroup AS AuthorizationGroup,
  _JITDelivSqncGrpHeader.ExtJITDelivSqncGrpID AS ExtJITDelivSqncGrpID
FROM R_JITPackingGroupTP
;

Learn More