CRMS4_IU_I_POD

CDS View
28 Fields 6 CDS Views

Point of Delivery

CRMS4_IU_I_POD is a CDS View in S/4HANA. Point of Delivery. It contains 28 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
CRMS4_IU_C_POD view from Point of Delivery
CRMS4_IU_C_PODEXT view from Point of Delivery by External PoD ID
CRMS4_IU_I_PODPRM view from Point of Delivery
CRMS4_IU_P_CNTPODG view from Number of PoDs for Premise group
CRMS4_IU_P_PODADDR view from Point of Delivery by Address
CRMS4_IU_P_PODCA view inner Point of Delivery by Contract Account

Fields (28)

KeyField CDS FieldsUsed in Views
KEY UtilitiesPremise UtilitiesPremise,VSTELLE 2
KEY UtilsExternalPointOfDelivery PD_EXT_UI,UtilsExternalPointOfDelivery 2
KEY UtilsInternalPointOfDelivery PD_INT_UI,UtilsInternalPointOfDelivery 3
AuthorizationGroup PD_BEGRU 1
DeletionIndicator PD_LOEVM 1
Division PD_SPARTE 1
DivisionName PD_SPARTE_DESC 1
UtilitiesGrid PD_GRID_ID 1
UtilitiesGridLevel PD_GRID_LEVL 1
UtilitiesGridLevelType PD_GRID_LTYP 1
UtilitiesGridLevelTypeName PD_GRID_LTYP_DESC 1
UtilitiesGridName PD_GRID_ID_DESC 1
UtilitiesInstallation PD_ANLAGE 1
UtilitiesIsOutlineContract PD_OUTL_CONT 1
UtilitiesPointOfDeliveryType PD_UITYPE 1
UtilitiesPtOfDeliveryTypeName PD_UITYPE_DESC 1
UtilitiesVoltageLevelName PD_GRID_LEVL_DESC 1
UtilsInstToPoDAllocFromDteTme PD_INST_ALLOC_FROM 1
UtilsInstToPoDAllocToDteTme PD_INST_ALLOC_TO 1
UtilsPoDLastChangeDate PD_AEDAT 1
UtilsPoDLastChangedByUser PD_AENAM 1
UtilsPointOfDeliveryCategory PD_UICAT 1
UtilsPtOfDeliveryCreatedByUser PD_ERNAM 1
UtilsPtOfDeliveryCreationDate PD_ERDAT 1
UtilsPtOfDeliveryIsDeregulated PD_EUIROLED 1
UtilsPtOfDeliveryIsTechnical PD_EUIROLET 1
UtilsPtOfDeliveryValidFrom PD_VALID_FROM 1
UtilsPtOfDeliveryValidTo PD_VALID_TO 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Point of Delivery
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4_IU_I_POD (
    UTILITIESPREMISE,
    UTILSEXTERNALPOINTOFDELIVERY,
    UTILSINTERNALPOINTOFDELIVERY,
    AUTHORIZATIONGROUP,
    DELETIONINDICATOR,
    DIVISION,
    DIVISIONNAME,
    UTILITIESGRID,
    UTILITIESGRIDLEVEL,
    UTILITIESGRIDLEVELTYPE,
    UTILITIESGRIDLEVELTYPENAME,
    UTILITIESGRIDNAME,
    UTILITIESINSTALLATION,
    UTILITIESISOUTLINECONTRACT,
    UTILITIESPOINTOFDELIVERYTYPE,
    UTILITIESPTOFDELIVERYTYPENAME,
    UTILITIESVOLTAGELEVELNAME,
    UTILSINSTTOPODALLOCFROMDTETME,
    UTILSINSTTOPODALLOCTODTETME,
    UTILSPODLASTCHANGEDATE,
    UTILSPODLASTCHANGEDBYUSER,
    UTILSPOINTOFDELIVERYCATEGORY,
    UTILSPTOFDELIVERYCREATEDBYUSER,
    UTILSPTOFDELIVERYCREATIONDATE,
    UTILSPTOFDELIVERYISDEREGULATED,
    UTILSPTOFDELIVERYISTECHNICAL,
    UTILSPTOFDELIVERYVALIDFROM,
    UTILSPTOFDELIVERYVALIDTO,
    PRIMARY KEY (UTILITIESPREMISE, UTILSEXTERNALPOINTOFDELIVERY, UTILSINTERNALPOINTOFDELIVERY)
);

Learn More