VALID_TO in ADR2
Valid To (DE: Gültig bis)
VALID_TO is a field in SAP table ADR2 (Telefonnummern (Business Address Services)). It represents "Valid To". Data element: AD_VALTO. Available in 4 CDS view(s) as valid_to, ValidityEndDateTime.
Business Meaning
| Description (EN) | Valid To |
|---|---|
| Beschreibung (DE) | Gültig bis |
| Data Element | AD_VALTO |
| Key Field | No |
CDS Views & Technical Names (4)
ADR2.VALID_TO is exposed in CDS views under the following technical names. Views reading the table directly are listed first; "via" marks views that pass the field on through intermediate views.
valid_to
(3 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| fiscds_adr2_mphone | direct | User Mobile Phone Numbers | ||
| fiscds_adr2_phone | direct | User Phone Numbers | ||
| fndei_adr2_filter | direct | Filter View for table ADR2 |
ValidityEndDateTime
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_AddressPhoneNumber | direct | BASIC | Address Phone Number |
Other Tables with Field VALID_TO (50+)
| Table | Data Element | Key | Description |
|---|---|---|---|
| /ACCGO/T_DGR_CUS | DATUM | Mater data for Cushion | |
| /ACCGO/T_DGR_LIC | /ACCGO/E_VALID_TO | DGR Table To Maintain License Plant detaill | |
| /ACCGO/T_DPQS_H | /ACCGO/E_VALID_TO | DPQS Header | |
| /ACCGO/T_FEE_MD | /ACCGO/E_VALID_TO | Fee Master Data | |
| /ACCGO/T_HLREVNT | TZNTSTMPS | HLR Event Processing -- Event table | |
| /CEECV/ROFI_BPTY | /CEECV/ROFI_VATNR_VALID_TO | KEY | Romania - Business Partner Type Assignment |
| /MVA/AMUOLICCATT | /MVA/AMD_VALID_TO | Texttabelle Kennzeichenart | |
| /MVA/AMUOVEHCAT | /MVA/AMD_VALID_TO | Aufbauart pflegen | |
| /SAPAPO/CULLHDR | TIMESTAMP | Determines Key for Cluster Table | |
| /SAPAPO/PSDRES | /SAPAPO/PSD_VALTOTSTMP | S4PPDS: Alternative Resources used to store products in PSD | |
| /SCMB/PRR | /SCMB/DE_DATE_TO | Processor: General Data | |
| /SCMB/RESTMSHD | /SAPAPO/CRES_TZNTSTMPS | Additional header table for TMS Resources | |
| /SCMB/RESTMSSK | /SAPAPO/CRES_TZNTSTMPS | Qualification Values for TMS resources | |
| /SCMTMS/C_SCAC | /SCMTMS/VAL_DATE_TO | Standard Carrier Alpha Codes | |
| ADR3 | AD_VALTO | Faxnummern (Business Address Services) | |
| ADR6 | AD_VALTO | E-Mail-Adressen (Business Address Services) | |
| ADRU | AD_VALTO | KEY | Tabelle für Kommunikationsverwendungen |
| BPTAXC | FSBP_TAXC_TO_DATE | Geschäftspartner Steuer-Compliance | |
| BUT_ADR2_PRC | AD_VALTO | Master Data Consolidation: Process Table for ADR2 | |
| BUT_ADR3_PRC | AD_VALTO | Master Data Consolidation: Process Table for ADR3 | |
| BUT_ADR6_PRC | AD_VALTO | Master Data Consolidation: Process Table for ADR12 | |
| BUT000 | BU_BP_VALID_TO | GP: Allgemeine Daten I | |
| BUT000_PRC | BU_BP_VALID_TO | Master Data Consolidation: Process Table for BUT000 | |
| BUT000_SRC | BU_BP_VALID_TO | Master Data Consolidation: Source Table for BUT000 | |
| BUT021_FS | BU_ADVW_VALID_TO | KEY | zeitabhängige Adressverwendungen |
| CMD_CNSNT | CME_CONSENT_VALID_TO | Consent Administration: Consent | |
| CMM_NB_KEYDATE | DATUM | Maturity Key Dates | |
| CRMCHKMSG_LOCAL | CRMEXCUDAT | Customizing: System local priorities | |
| CRMS4D_ICM_LOC | CRMS4_ICM_VALID_TO | ICM Location | |
| CRMS4D_ICM_OBJ | CRMS4_ICM_VALID_TO | ICM Object | |
| CRMS4D_ICM_STAFF | CRMS4_ICM_VALID_TO | Satff and Units for Location and Object | |
| CRMS4D_OBJ_ATTR | CRMS4_ICM_VALID_TO | Multi-value attributes for ICM Objects | |
| DFACTS | PS_VALID_TO | KEY | OBJNR to Facts |
| DFS_SUBS_OBJLIST | ENDDA | KEY | Subscription - Object List |
| ECOMP_GRP_BR | BISZEITSCH | Brazil: Compensation Groups | |
| ECOMP_REL_BR | BISZEITSCH | Brazil: Define Energy Compensation Relationships | |
| EHFNDD_REQ_ROOT | EHFND_REQ_END_DATE | Compliance Requirement Root | |
| ESH_TAU_CL_P | ESH_E_CL_VALID_TO | Classification Test: Property | |
| ESH_TAU_CL_PDT | ESH_E_CL_VALID_TO | Classification Test: Prop. Datatype | |
| ESH_TAU_CL_PVPD | TZNTSTMPS | Classification Test: Property Value Assignm. to EPM Product | |
| FCLM_ACC_BS_CONF | FCLM_BAM_ACLINK_VALIDTO | Bank Account Balance and Bank Statement Integration Setting | |
| FCLM_BAM_ACLINK2 | FCLM_BAM_ACLINK_VALIDTO | Linkages Between Bank Account and House Bank Accounts | |
| FCLM_BAM_AMD_LIM | FCLM_BAM_LIM_VALID_TO | Bank Account Master Data: Overdraft Limit | |
| FCLM_BAM_BNKABP2 | FCLM_BAM_VALID_TO | KEY | Risk Business Partners Assigned to Bank |
| FCLM_BAM_HIER | FCLM_BAM_VALID_TO | KEY | Bank Account Hierarchy |
| FCLM_BAM_HIERDT | FCLM_BAM_VALID_TO | KEY | Hierarchy Node in Design Time |
| FCLM_BAM_HIERRT | FCLM_BAM_VALID_TO | KEY | Hierarchy Node in Run Time |
| FCLM_BAM_HIERVC | FCLM_BAM_VALID_TO | KEY | Visibility Control |
| FCLM_BAM_SIG | FCLM_BAM_SIGN_VALID_TO | KEY | Payment Approver |
| FCLM_BAM_SIGCARD | FCLM_BAM_VALID_TO | Signatory Cards |
Showing the first 50 tables. Search all occurrences →
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA