CRMS4_IU_P_PODADDR

Point of Delivery by Address | view: CRMS4IUVPPODADDR | Extraction: Not supported | Component: S4CRM: Utilities Industry
Column Name Description
UtilsInternalPointOfDelivery Internal key for point of delivery
AddressID FK Address Number
Column Name Description
Column Name Description
Column Name Description
PD_AEDAT Last Changed On
PD_ERDAT Date on which the record was created
Column Name Description
PD_EUIROLED Deregulation Point of Delivery Show values
PD_EUIROLET Technical Point of Delivery Show values
PD_LOEVM Deletion Indicator Show values
PD_UICAT Point of Delivery Category Show values
PD_OUTL_CONT Outline Contract Show values
Column Name Description Domain name
PD_VALID_FROM null
PD_VALID_TO null
PD_AENAM Name of Person Who Changed Object USNAM
PD_BEGRU Authorization Group BEGRU
PD_ERNAM Name of Person Responsible for Creating the Object USNAM
PD_EXT_UI Point of Delivery ID EXT_UI
PD_INT_UI Internal key for point of delivery INT_POD
PD_SPARTE_DESC Description of Single Value DDTEXT
PD_UITYPE_DESC Description of point of delivery type TEXT30
PD_GRID_LTYP Grid Level Type GRID_LEVEL_TYPE
PD_GRID_LTYP_DESC Name of Grid Level Type TEXT40
PD_GRID_LEVL Grid Level GRID_LEVEL
PD_GRID_LEVL_DESC Text (30 Characters) TEXT30
PD_GRID_ID Grid GRID_ID
PD_GRID_ID_DESC Grid Description TEXT40
VSTELLE Premise VSTELLE
NAME1 Name 1 TEXT40
NAME2 Name 2 TEXT40
CITY1 City TEXT40
CITY2 District TEXT40
POST_CODE1 City postal code CHAR10
POST_CODE2 PO Box Postal Code CHAR10
POST_CODE3 Company Postal Code (for Large Customers) CHAR10
PO_BOX_LOC PO Box city TEXT40
STREET Street TEXT60
STR_SUPPL1 Street 2 TEXT40
STR_SUPPL2 Street 3 TEXT40
STR_SUPPL3 Street 4 TEXT40
HOUSE_NUM1 House Number TEXT10
HOUSE_NUM2 House number supplement TEXT10
SORT1 Search Term 1 CHAR20
SORT2 Search Term 2 CHAR20
PO_BOX_LOBBY PO Box Lobby TEXT40
DELI_SERV_TYPE Number of Delivery Service CHAR10
COUNTY County TEXT40
Master Data Relations Join Conditions
Address Number
  • Client
  • Address Number
  • Address Number
  • ?
  • ?
  • CRMS4_IU_P_PODADDR.MANDT == ADRC.CLIENT
  • CRMS4_IU_P_PODADDR.ADDRESSID == ADRC.ADDRNUMBER
  • CRMS4_IU_P_PODADDR.ADDRNUMBER == ADRC.ADDRNUMBER
  • CRMS4_IU_P_PODADDR.[column in domain "AD_NATION"] == ADRC.NATION
  • CRMS4_IU_P_PODADDR.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Address Number
  • Client
  • Address Number
  • Address Number
  • ?
  • ?
  • CRMS4_IU_P_PODADDR.MANDT == ADRC.CLIENT
  • CRMS4_IU_P_PODADDR.ADDRESSID == ADRC.ADDRNUMBER
  • CRMS4_IU_P_PODADDR.ADDRNUMBER == ADRC.ADDRNUMBER
  • CRMS4_IU_P_PODADDR.[column in domain "AD_NATION"] == ADRC.NATION
  • CRMS4_IU_P_PODADDR.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Country key
  • Country/Region Key
  • Client
  • CRMS4_IU_P_PODADDR.COUNTRY == T005.LAND1
  • CRMS4_IU_P_PODADDR.MANDT == T005.MANDT
Address Delivery service type text table
  • Type of Delivery Service
  • ?
Point of Delivery Type
  • Client
  • Point of Delivery Type
  • CRMS4_IU_P_PODADDR.MANDT == EUITYPE.MANDT
  • CRMS4_IU_P_PODADDR.PD_UITYPE == EUITYPE.UITYPE
Region code
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • CRMS4_IU_P_PODADDR.COUNTRY == T005S.LAND1
  • CRMS4_IU_P_PODADDR.MANDT == T005S.MANDT
  • CRMS4_IU_P_PODADDR.REGION == T005S.BLAND
Other Relations | to Master Data Relations ↑ Join Conditions
Division
  • Client
  • Division
  • CRMS4_IU_P_PODADDR.MANDT == TESPT.MANDT
  • CRMS4_IU_P_PODADDR.PD_SPARTE == TESPT.SPARTE