C_JITTeamAttributeLookUp

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_JITTeamAttributeLookUp.
-- 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.
-- Parameters: P_RespyMgmtTeamID : hrobjid

CREATE VIEW C_JITTeamAttributeLookUp AS
SELECT
  RespyMgmtTeamID,
  cast(_AttributeCompGrpMatl.RespyMgmtAttributeLowValue as njit_comp_grp_mat) AS CompGrpMatl,
  cast(_AttributeCustSupplyArea.RespyMgmtAttributeLowValue as njit_cs_area) AS CustSupplyArea,
  cast(_AttributeJITDelivSqnceGrpID.RespyMgmtAttributeLowValue as njit_de_delv_seq_grp_id) AS JITDelivSqncGrpID,
  cast(_AttributeIntProcessingStatus.RespyMgmtAttributeLowValue as njit_int_stat) AS JITIntProcessingStatus,
  cast(_AttributeShipToParty.RespyMgmtAttributeLowValue as kunwe) AS ShipToParty,
  cast(_AttributePlant.RespyMgmtAttributeLowValue as werks_d) AS Plant,
  cast(_AttributeProductionLine.RespyMgmtAttributeLowValue as sa_line1) AS ProductionLine,
  cast(_AttributeJITVerificationPrfl.RespyMgmtAttributeLowValue as njit_verification_profile) AS VerificationProfileID,
  cast(_AttributeReasonCode.RespyMgmtAttributeLowValue as pph_agrnd) AS VarianceReasonCode,
  cast(_AttributeSortVariant.RespyMgmtAttributeLowValue as njit_sort_variant_id) AS SortVariantID
LEFT OUTER JOIN I_RespyMgmtTeamAttribute AS _AttributeShipToParty ON RespyMgmtTeamID = _AttributeShipToParty.RespyMgmtTeamID AND _AttributeShipToParty.RespyMgmtReferenceAttribName = 'SHIPTOPARTY'  -- association [0..1]
LEFT OUTER JOIN I_RespyMgmtTeamAttribute AS _AttributePlant ON RespyMgmtTeamID = _AttributePlant.RespyMgmtTeamID AND _AttributePlant.RespyMgmtReferenceAttribName = 'JITPLANT'  -- association [0..1]
LEFT OUTER JOIN I_RespyMgmtTeamAttribute AS _AttributeCustSupplyArea ON RespyMgmtTeamID = _AttributeCustSupplyArea.RespyMgmtTeamID AND _AttributeCustSupplyArea.RespyMgmtReferenceAttribName = 'CUSTSUPPLYAREA'  -- association [0..1]
LEFT OUTER JOIN I_RespyMgmtTeamAttribute AS _AttributeJITDelivSqnceGrpID ON RespyMgmtTeamID = _AttributeJITDelivSqnceGrpID.RespyMgmtTeamID AND _AttributeJITDelivSqnceGrpID.RespyMgmtReferenceAttribName = 'JITDELIVSQNCGRPID'  -- association [0..1]
LEFT OUTER JOIN I_RespyMgmtTeamAttribute AS _AttributeJITPckgGrpStatus ON RespyMgmtTeamID = _AttributeJITPckgGrpStatus.RespyMgmtTeamID AND _AttributeJITPckgGrpStatus.RespyMgmtReferenceAttribName = 'JITPCKGGRPSTATUS'  -- association [0..1]
LEFT OUTER JOIN I_RespyMgmtTeamAttribute AS _AttributeIntProcessingStatus ON RespyMgmtTeamID = _AttributeIntProcessingStatus.RespyMgmtTeamID AND _AttributeIntProcessingStatus.RespyMgmtReferenceAttribName = 'STATUS'  -- association [0..1]
LEFT OUTER JOIN I_RespyMgmtTeamAttribute AS _AttributeCompGrpMatl ON RespyMgmtTeamID = _AttributeCompGrpMatl.RespyMgmtTeamID AND _AttributeCompGrpMatl.RespyMgmtReferenceAttribName = 'COMPONENTMATERIAL'  -- association [0..1]
LEFT OUTER JOIN I_RespyMgmtTeamAttribute AS _AttributeProductionLine ON RespyMgmtTeamID = _AttributeProductionLine.RespyMgmtTeamID AND _AttributeProductionLine.RespyMgmtReferenceAttribName = 'PRODUCTIONLINE'  -- association [0..1]
LEFT OUTER JOIN I_RespyMgmtTeamAttribute AS _AttributeJITVerificationPrfl ON RespyMgmtTeamID = _AttributeJITVerificationPrfl.RespyMgmtTeamID AND _AttributeJITVerificationPrfl.RespyMgmtReferenceAttribName = 'VERIFICATIONPROFILEID'  -- association [0..1]
LEFT OUTER JOIN I_RespyMgmtTeamAttribute AS _AttributeReasonCode ON RespyMgmtTeamID = _AttributeReasonCode.RespyMgmtTeamID AND _AttributeReasonCode.RespyMgmtReferenceAttribName = 'VARIANCEREASONCODE'  -- association [0..1]
LEFT OUTER JOIN I_RespyMgmtTeamAttribute AS _AttributeSortVariant ON RespyMgmtTeamID = _AttributeSortVariant.RespyMgmtTeamID AND _AttributeSortVariant.RespyMgmtReferenceAttribName = 'SORTVARIANT'  -- association [0..1]
;