I_JITScanComponentGroup

DDL: I_JITSCANCOMPONENTGROUP Type: view_entity TRANSACTIONAL Package: NJIT_APP_SCANNING

JIT Scan Component Group

I_JITScanComponentGroup is a Transactional CDS View that provides data about "JIT Scan Component Group" in SAP S/4HANA. It reads from 1 data source (R_JITInbCallComponentGroupTP) and exposes 35 fields with key field JITCallCompGrpUUID. Part of development package NJIT_APP_SCANNING.

Data Sources (1)

SourceAliasJoin Type
R_JITInbCallComponentGroupTP JITCallComponentGroup from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label JIT Scan Component Group view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.quota.maximumFields 500 view
AbapCatalog.extensibility.quota.maximumBytes 50000 view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY JITCallCompGrpUUID JITCallCompGrpUUID NodeID
JITHeaderUUID JITHeaderUUID NodeID
InternalJITCallNumber InternalJITCallNumber JIT Call Number
ExternalJITCallNumber _JITInboundCallTP ExternalJITCallNumber Ext. JIT Call Number
ShipToParty _JITInboundCallTP ShipToParty Ship-To Party (obsolete)
SalesOrganization _JITInboundCallTP SalesOrganization Sales Organization
DistributionChannel _JITInboundCallTP DistributionChannel RefDistCh-Cust/Mat.
Division _JITInboundCallTP Division Internal Division ID
JITAltvHndlgUnitID _JITPckgGrpHeader JITAltvHndlgUnitID Alt. PG ID Short
JITPckgGrpID _JITPckgGrpHeader JITPckgGrpID Package Group ID
CompGrpNumber CompGrpNumber Component Group No.
CompGrpMatl CompGrpMatl Comp. Group Matl.
CustSupplyArea CustSupplyArea Cust. Supply Area
JITIntProcessingStatus JITIntProcessingStatus Transmitted Status
JITDelivSqncGrpID JITDelivSqncGrpID Del. Seq. Grp. ID
JITPackingGroupUsageType _JITPackingGroupTP JITPackingGroupUsageType Usage Type
JITPackingGroupUsageTypeText
ProductionLine _ProductionVersion ProductionLine Production Line
ShippingPoint ShippingPoint Shipping Point
Plant Plant Valuation Area
UnloadingPointName UnloadingPointName Unloading Point Name
CustAssemblyLoc CustAssemblyLoc Assembly Location
JITExtSequenceNumber JITExtSequenceNumber Ext.Seq. Number
JITFormattedSequenceNumber JITFormattedSequenceNumber Formtd Seq. No
JITExtStatusUpdtdOn JITExtStatusUpdtdOn Ext. Status Updtd
JITIntStatusUpdtdOn JITIntStatusUpdtdOn Int Status Updtd On
PlannedShippingDateTime PlannedShippingDateTime Pl. Shippg Date Time
RequirementDateTime RequirementDateTime Time Stamp
ExtJITDelivSqncGrpID _JITDelivSqncGrpHeaderBasic ExtJITDelivSqncGrpID Ext Group Number
JITPckgGrpStatus _JITPackingGroupTP JITPckgGrpStatus Packing Group Status
JITPckgGrpStatusTxt
_JITInboundCallTP _JITInboundCallTP
_ProductCompGrp _ProductCompGrp
_JITInternalStatus _JITInternalStatus
_JITPackingGroupItemRefTP _JITPackingGroupItemRefTP

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_JITScanComponentGroup.
-- 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_JITScanComponentGroup AS
SELECT
  JITCallCompGrpUUID,
  JITHeaderUUID,
  InternalJITCallNumber,
  _JITInboundCallTP.ExternalJITCallNumber AS ExternalJITCallNumber,
  _JITInboundCallTP.ShipToParty AS ShipToParty,
  _JITInboundCallTP.SalesOrganization AS SalesOrganization,
  _JITInboundCallTP.DistributionChannel AS DistributionChannel,
  _JITInboundCallTP.Division AS Division,
  _JITPckgGrpHeader.JITAltvHndlgUnitID AS JITAltvHndlgUnitID,
  _JITPckgGrpHeader.JITPckgGrpID AS JITPckgGrpID,
  CompGrpNumber,
  CompGrpMatl,
  CustSupplyArea,
  JITIntProcessingStatus,
  JITDelivSqncGrpID,
  _JITPackingGroupTP.JITPackingGroupUsageType AS JITPackingGroupUsageType,
  _JITPackingGroupTP._JITPackingGroupUsageType._Text[1:Language = $session.system_language].JITPackingGroupUsageTypeText AS JITPackingGroupUsageTypeText,
  _ProductionVersion.ProductionLine AS ProductionLine,
  ShippingPoint,
  Plant,
  UnloadingPointName,
  CustAssemblyLoc,
  JITExtSequenceNumber,
  JITFormattedSequenceNumber,
  JITExtStatusUpdtdOn,
  JITIntStatusUpdtdOn,
  PlannedShippingDateTime,
  RequirementDateTime,
  _JITDelivSqncGrpHeaderBasic.ExtJITDelivSqncGrpID AS ExtJITDelivSqncGrpID,
  _JITPackingGroupTP.JITPckgGrpStatus AS JITPckgGrpStatus,
  _JITPackingGroupTP._JITPckgGrpStatus._Text[1: Language=$session.system_language].JITPckgGrpStatusTxt AS JITPckgGrpStatusTxt
FROM R_JITInbCallComponentGroupTP AS JITCallComponentGroup
;