CRMS4_IU_C_POD

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 CRMS4_IU_C_POD.
-- 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: CRMS4IUVCPOD

CREATE VIEW CRMS4_IU_C_POD AS
SELECT
  UtilsInternalPointOfDelivery AS INT_UI,
  UtilsExternalPointOfDelivery AS EXT_UI,
  UtilsPtOfDeliveryValidFrom AS PD_VALID_FROM,
  UtilsPtOfDeliveryValidTo AS PD_VALID_TO,
  UtilsInternalPtOfDeliveryName AS PD_SHTXT,
  UtilsPoDLastChangeDate AS PD_AEDAT,
  UtilsPoDLastChangedByUser AS PD_AENAM,
  AuthorizationGroup AS PD_BEGRU,
  UtilsPtOfDeliveryCreationDate AS PD_ERDAT,
  UtilsPtOfDeliveryCreatedByUser AS PD_ERNAM,
  UtilsPtOfDeliveryIsDeregulated AS PD_EUIROLED,
  UtilsPtOfDeliveryIsTechnical AS PD_EUIROLET,
  UtilsExternalPointOfDelivery AS PD_EXT_UI,
  UtilsInternalPointOfDelivery AS PD_INT_UI,
  DeletionIndicator AS PD_LOEVM,
  Division AS PD_SPARTE,
  DivisionName AS PD_SPARTE_DESC,
  UtilsPoDIDStructureType AS PD_UISTRUTYP,
  UtilsPointOfDeliveryCategory AS PD_UICAT,
  UtilitiesPointOfDeliveryType AS PD_UITYPE,
  UtilitiesPtOfDeliveryTypeName AS PD_UITYPE_DESC,
  UtilitiesGridLevelType AS PD_GRID_LTYP,
  UtilitiesGridLevelTypeName AS PD_GRID_LTYP_DESC,
  UtilitiesGridLevel AS PD_GRID_LEVL,
  UtilitiesVoltageLevelName AS PD_GRID_LEVL_DESC,
  UtilitiesGrid AS PD_GRID_ID,
  UtilitiesGridName AS PD_GRID_ID_DESC,
  UtilitiesIsOutlineContract AS PD_OUTL_CONT,
  UtilitiesGridDivisionCategory AS PD_SPARTYP,
  UtilitiesPremise AS VSTELLE,
  UtilsPoDAllocValidityEndDate,
  UtilsPoDAllocValidityEndTime,
  UtilitiesInstallation AS PD_ANLAGE,
  UtilsInstToPoDAllocFromDteTme AS PD_INST_ALLOC_FROM,
  UtilsInstToPoDAllocToDteTme AS PD_INST_ALLOC_TO
FROM CRMS4_IU_I_POD
;