C_InvgCsMLocStaffUnitTP

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_InvgCsMLocStaffUnitTP.
-- 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.
-- SQL view name: CINVGCSMSTFUNTTP

CREATE VIEW C_InvgCsMLocStaffUnitTP AS
SELECT
  InvgCsMStaffUnitID,
  InvgCsMPartnerNumber,
  InvgCsMRelationship,
  InvgCsMRelatedEntityType,
  BusinessPartnerUUID AS InvgCsMRelationshipTargetUUID,
  InvgCsMPartnerNumberForEdit,
  FullName,
  InvgCsMRelationshipForEdit,
  InvgCsMPartnerFunction,
  InvgCsMTargetID,
  InvgCsMIsMainPartner,
  ValidFrom,
  ValidTo,
  InvgCsMIsDeleteAllowed,
  _Address.CityName AS CityName,
  _Address.Country AS Country,
  _Address.MobilePhoneNumber AS MobilePhoneNumber,
  _Address.PhoneNumber AS PhoneNumber,
  I_InvgCsMLocStaffUnitTP._BusinessPartner AS _BusinessPartner
FROM I_InvgCsMLocStaffUnitTP
LEFT OUTER JOIN C_InvgCsMLocationTP AS _Location ON InvgCsMStaffUnitID = _Location.InvgCsMLocationID  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerAddress AS _Address ON InvgCsMPartnerNumber = _Address.BusinessPartner AND _Address.StandardUsage = 'X'  -- association [0..1]
LEFT OUTER JOIN C_InvgCsMPartnerFunctionVH AS _partnerfunction ON InvgCsMRelationshipForEdit = _partnerfunction.PartnerFunction  -- association [0..*]
LEFT OUTER JOIN C_InvgCsMPartFunctionText AS _partnerfunctiontxt ON InvgCsMRelationshipForEdit = _partnerfunctiontxt.PartnerFunction  -- association [0..*]
LEFT OUTER JOIN C_InvgCsMStaffUnitVH AS _User ON InvgCsMPartnerNumberForEdit = _User.BusinessPartner  -- association [0..*]
;