I_UtilitiesMoveOutDocument

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_UtilitiesMoveOutDocument.
-- 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: IEUTILMOVEOUTDOC

CREATE VIEW I_UtilitiesMoveOutDocument AS
SELECT
  eausv.auszbeleg AS UtilitiesMoveOutDocument,
  eausv.vertrag AS UtilitiesContract,
  eausv.anlage AS UtilitiesInstallation,
  eausv.auszdat AS UtilitiesMoveOutDate,
  eausv.ohneeinz AS UtilsMoveOutWithoutMoveIn,
  eausv.storausz AS UtilsMoveOutDocumentIsReversed,
  eausv.absstopkz AS UtilsBdgtBillingPlanIsStopped,
  eausv.kzsondausz AS UtilsSpclMoveOutCaseIsExisting,
  eausv.auteigeinz AS UtilsMoveInHasAutomOwnerAlloc,
  eausv.absstopdat AS UtilsFinalDateForBudgetBilling,
  eausv.schlfakt AS UtilsContrJointInvcType,
  eausv.mahnv AS CADunningProcedure,
  eausv.mansp AS CADunningLockReason,
  eausv.mahnvumz AS UtilsMoveInOutDunningProcedure,
  eausv.manoutsort AS UtilsBillgOutsortingReason,
  eausv.keinablbel AS UtilsDoNotCrteCustSelfRdngCard,
  eausv.abrdats AS ScheduledUtilitiesBillingDate,
  eausv.erdat AS UtilsMoveOutDocCreationDate,
  eausv.ernam AS UtilsMoveOutDocCreatedByUser,
  eausv.aedat AS UtilsMoveOutDocLastChangeDate,
  eausv.aenam AS UtilsMoveOutDocLastChgdByUser,
  eausv.begru AS AuthorizationGroup,
  eausv.loevm AS DeletionIndicator,
  eausv.vstelle AS UtilitiesPremise
FROM eausv
LEFT OUTER JOIN I_UtilitiesContract AS _UtilitiesContract ON UtilitiesContract = _UtilitiesContract.UtilitiesContract  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON UtilsMoveOutDocCreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON UtilsMoveOutDocLastChgdByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesInstallation AS _UtilitiesInstallation ON UtilitiesInstallation = _UtilitiesInstallation.UtilitiesInstallation  -- association [0..1]
LEFT OUTER JOIN I_CADunningProcedure AS _CADunningProcedure ON CADunningProcedure = _CADunningProcedure.CADunningProcedure  -- association [0..1]
LEFT OUTER JOIN I_UtilsMoveOutRsnWithoutMoveIn AS _UtilsMoveOutRsnWithoutMoveIn ON UtilsMoveOutWithoutMoveIn = _UtilsMoveOutRsnWithoutMoveIn.UtilsMoveOutWithoutMoveIn  -- association [0..1]
LEFT OUTER JOIN I_InvcUtilsContractsJointly AS _InvcUtilsContractsJointly ON UtilsContrJointInvcType = _InvcUtilsContractsJointly.UtilsContrJointInvcType  -- association [0..1]
LEFT OUTER JOIN I_UtilsSpclMoveOutCaseExists AS _UtilsSpclMoveOutCaseExists ON UtilsSpclMoveOutCaseIsExisting = _UtilsSpclMoveOutCaseExists.UtilsSpclMoveOutCaseIsExisting  -- association [0..1]
LEFT OUTER JOIN I_CADunningProcedure AS _UtilsMoveInOutDunningProced ON UtilsMoveInOutDunningProcedure = _UtilsMoveInOutDunningProced.CADunningProcedure  -- association [0..1]
LEFT OUTER JOIN I_UtilsBillgOutsortingGroup AS _UtilsBillgOutsortingGroup ON UtilsBillgOutsortingReason = _UtilsBillgOutsortingGroup.UtilsBillgOutsortingReason  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesPremise AS _UtilitiesPremise ON UtilitiesPremise = _UtilitiesPremise.UtilitiesPremise  -- association [0..1]
;