C_JITCallComponentProcg

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_JITCallComponentProcg.
-- 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_JITCallComponentProcg AS
SELECT
  JITCallComponentUUID,
  JITHeaderUUID,
  JITCallCompGrpUUID,
  InternalJITCallNumber,
  CompGrpNumber,
  JITCallItemNumber,
  Material,
  MaterialByCustomer,
  ExtJITCallItemNumber,
  SalesSchedulingAgreement,
  SalesSchedulingAgreementItem,
  Division,
  QuantityUnit,
  RequestedQuantity,
  ActualDeliveredQuantity,
  VarianceReasonCode,
  _JITInbCallComponentGroupTP._JITDeliveryStatus._Text[1:Language = $session.system_language].DeliveryStatusText AS DeliveryStatusText,
  _JITInboundCallTP._JITLifecycleStatus._Text[1:Language = $session.system_language].JITLifecycleStatusText AS JITLifecycleStatusText,
  _JITInbCallComponentGroupTP._JITCallCompGrpCanclnStatus._Text[1:Language = $session.system_language].JITCallCompGrpCanclnStsText AS JITCallCompGrpCanclnStsText,
  _JITInbCallComponentGroupTP. CompGrpMatl AS CompGrpMatl,
  UnloadingPointName,
  CustAssemblyLoc,
  RequirementDateTime,
  CustSupplyArea,
  Plant,
  _JITInbCallComponentGroupTP._SupplierExtStatus._JITExternalStatusText[1: Language=$session.system_language].JITExternalStatusText AS JITExternalStatusText,
  JITExtStatusAtSupplier,
  JITExtStatusUpdtdOn,
  _JITInboundCallTP._CustomerToBusinessPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _JITInboundCallTP._SoldToParty.OrganizationBPName1 AS OrganizationBPName1,
  _ProductCompMatl._Text[1: Language=$session.system_language].ProductName AS ProductName,
  _JITInboundCallTP._JITComponentIsReordered._Text[1:Language = $session.system_language].JITComponentIsReorderedText AS JITComponentIsReorderedText,
  _JITInbCallComponentGroupTP._JITSupplyControlHeader._Description[1:Language=$session.system_language].SupplyControlDesc AS SupplyControlDesc,
  JITCallCompMatlBackflushStatus,
  _JITBackflushStatus ._Text[1:Language = $session.system_language].JITBackflushStatusText AS JITBackflushStatusText,
  _JITInbCallComponentGroupTP._JITInternalStatus._Text[1: Language=$session.system_language].JITInternalStatusText AS JITInternalStatusText,
  _JITInbCallComponentGroupTP._JITInternalStatus.JITIntProcessingStatusType AS JITIntProcessingStatusType,
  _JITInbCallComponentGroupTP._Plant[1:Language = $session.system_language].PlantName AS PlantName,
  _JITInbCallComponentGroupTP._JITPackingGroupTP.JITPackingGroupUsageType AS JITPackingGroupUsageType,
  _JITInbCallComponentGroupTP._JITPackingGroupTP._JITPackingGroupUsageType._Text[1:Language = $session.system_language].JITPackingGroupUsageTypeText AS JITPackingGroupUsageTypeText,
  _JITInbCallComponentGroupTP._JITCallForwardingStatus._Text[1:Language=$session.system_language].JITCallForwardingStatusText AS JITCallForwardingStatusText,
  virtual JITMatlIsNonSerialized : boolean AS virtualJITMatlIsNonSerializedboolean,
  virtual SerialNumber : gernr AS virtualSerialNumbergernr,
  virtual JITDelivConfIsNotValid : boolean AS virtualJITDelivConfIsNotValidboolean,
  virtual RespyMgmtTeamName : rsm_de_team_name AS virtualRespyMgmtTeamNamersm_de_team_name,
  virtual JITInternalStatusCriticality : abap.int1 AS int1,
  virtual JITResultHdrText : val_text AS virtualJITResultHdrTextval_text,
  virtual UICT_JITReqdAndDlvrdQtyCritlty : abap.char(3) AS char3,
  virtual NmbrOfCompMatls : abap.numc( 10 ) AS numc10,
  virtual JITCallIsSequenced : boolean AS virtualJITCallIsSequencedboolean,
  virtual JITCallIsSummarized : boolean AS virtualJITCallIsSummarizedboolean,
  _JITInboundCallTP._JITCallType._Text.JITCallTypeText : localized AS JITCallTypeTextlocalized,
  _JITInbCallComponentGroupTP._JITSupplyControlHeader._JITActionCtrl._Text[1:Language=$session.system_language].JITActionCtrlText AS JITActionCtrlText,
  _JITInbCallComponentGroupTP._JITDelivSqncGrpHeaderBasic._Description[1:Language = $session.system_language].JITDelivSqncGrpDesc AS JITDelivSqncGrpDesc,
  _JITInbCallComponentGroupTP._JITDelivSqncGrpHeaderBasic.ExtJITDelivSqncGrpID AS ExtJITDelivSqncGrpID,
  _JITInbCallComponentGroupTP.DeliveryStatus AS DeliveryStatus,
  _JITInbCallComponentGroupTP.JITFormattedSequenceNumber AS JITFormattedSequenceNumber,
  _JITInbCallComponentGroupTP.JITCallCompGrpCancellationSts AS JITCallCompGrpCancellationSts,
  _JITInbCallComponentGroupTP.JITDelivSqncGrpUUID AS JITDelivSqncGrpUUID,
  _JITInbCallComponentGroupTP.SupplyControlUUID AS SupplyControlUUID,
  _JITInbCallComponentGroupTP.ActualShippingDateTime AS ActualShippingDateTime,
  _JITInbCallComponentGroupTP.JITActionCtrl AS JITActionCtrl,
  _JITInbCallComponentGroupTP.CustCompGrpMatl AS CustCompGrpMatl,
  _JITInbCallComponentGroupTP.JITIntStatusUpdtdOn AS JITIntStatusUpdtdOn,
  _JITInbCallComponentGroupTP.JITIntProcessingStatus AS JITIntProcessingStatus,
  _JITInbCallComponentGroupTP.JITCallForwardingStatus AS JITCallForwardingStatus,
  _JITInbCallComponentGroupTP.SupplyControlID AS SupplyControlID,
  _JITInbCallComponentGroupTP.JITDelivSqncGrpID AS JITDelivSqncGrpID,
  _JITInboundCallTP.ExternalJITCallNumber AS ExternalJITCallNumber,
  _JITInboundCallTP.ShipToParty AS ShipToParty,
  _JITInboundCallTP.JITLifecycleStatus AS JITLifecycleStatus,
  _JITInboundCallTP.JITExtSequenceNumber AS JITExtSequenceNumber,
  _JITInboundCallTP.SalesOrganization AS SalesOrganization,
  _JITInboundCallTP.DistributionChannel AS DistributionChannel,
  _JITInboundCallTP.SoldToParty AS SoldToParty,
  _JITInboundCallTP.JITCallType AS JITCallType,
  _JITInboundCallTP.VehicleModel AS JITVehicleModel,
  _JITInboundCallTP.VehicleIdentificationNumber AS VehicleIdentificationNumber,
  _JITInboundCallTP.JITComponentIsReordered AS JITComponentIsReordered,
  _JITInboundCallTP.CreatedByUser AS CreatedByUser
FROM R_JITInbCallComponentTP
LEFT OUTER JOIN C_JITCallDelivConfRefDoc AS _JITCallDelivConfRefDoc ON InternalJITCallNumber = _JITCallDelivConfRefDoc.BusinessTransactionDocument AND JITCallItemNumber = _JITCallDelivConfRefDoc.BusinessTransactionDocItem  -- association [0..*]
LEFT OUTER JOIN C_JITInbCallCompSerialNumber AS _JITInbCallCompSerialNumber ON InternalJITCallNumber = _JITInbCallCompSerialNumber.InternalJITCallNumber AND CompGrpNumber = _JITInbCallCompSerialNumber.CompGrpNumber AND JITCallItemNumber = _JITInbCallCompSerialNumber.JITCallItemNumber  -- association [0..*]
LEFT OUTER JOIN C_JITCallComponentMatlDocRef AS _JITCallComponentMatlDocRef ON JITCallComponentUUID = _JITCallComponentMatlDocRef.JITCallComponentUUID  -- association [0..*]
LEFT OUTER JOIN C_JITCallCompRefText AS _JITCallCompRefText ON JITCallComponentUUID = _JITCallCompRefText.ParentDraftKey  -- association [0..*]
LEFT OUTER JOIN C_JITCallCompGrpProcg AS _JITCallCompGrpProcg ON JITCallCompGrpUUID = _JITCallCompGrpProcg.JITCallCompGrpUUID  -- association [0..1]
LEFT OUTER JOIN C_JITInbCallFwdngCompRef AS _JITInbCallFwdngCompRef ON JITCallComponentUUID = _JITInbCallFwdngCompRef.ReferenceJITComponentUUID  -- association [0..*]
;