DATE_TO in BUT052
Valid To (DE: Gültig bis)
DATE_TO is a field in SAP table BUT052 (BP Relationship: Addresses). It represents "Valid To". Data element: BU_DATTO. Available in 34 CDS view(s) as ValidityEndDate, RelValidityEndDate, date_to.
Business Meaning
| Description (EN) | Valid To |
|---|---|
| Beschreibung (DE) | Gültig bis |
| Data Element | BU_DATTO |
| Key Field | Yes |
CDS Views & Technical Names (34)
BUT052.DATE_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.
ValidityEndDate
(24 views)
Validity Date (Valid To)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_BpContactToAddress | direct | BASIC | Business Partner Contact To Address | |
| A_BPContactPersonEmlAddr | via 2 level | BASIC | Contact Person Email Address | |
| A_BPContactPersonFaxNmbr | via 2 level | BASIC | Contact Person Fax Number | |
| A_BPContactPersonMblNmbr | via 2 level | BASIC | Contact Person Mobile Number | |
| A_BPContactPersonTelNmbr | via 2 level | BASIC | Contact Person Telephone Number | |
| A_BPContactPersonWbsteURL | via 2 level | BASIC | Contact Person Website URL | |
| A_BPContactToAddress | via 2 level | BASIC | Contact Person Address | |
| A_BPContactWorkPlaceEmailAddr | via 2 level | BASIC | BP Contact Work Place Email Address | |
| A_BPContactWorkPlaceFaxNumber | via 2 level | BASIC | BP Contact Work Place Fax Number | |
| A_BPContactWrkPlaceHomePageURL | via 2 level | BASIC | BP Contact Work Place URL Address | |
| A_BPContactWrkPlacePhoneNumber | via 2 level | BASIC | BP Contact Work Place Phone Number | |
| I_BPContactAddressTP | via 2 level | TRANSACTIONAL | TP View for BP Contact Person Address | |
| I_BPContactEmlAddrTP | via 2 level | TRANSACTIONAL | TP View BP Contact Person Email Address | |
| I_BPContactFaxNmbrTP | via 2 level | TRANSACTIONAL | BO view for BP contact Fax number | |
| I_BPContactMblNmbrTP | via 2 level | TRANSACTIONAL | BO view for BP contact Mobile number | |
| I_BPContactTelNmbrTP | via 2 level | TRANSACTIONAL | TP View for BP Contact Person Telephone | |
| I_BpContactToAddressStdVH | via 2 level | COMPOSITE | Business Partner Contact To Address | |
| I_BPContactWbsteURLTP | via 2 level | TRANSACTIONAL | BO view for BP contact Website URL | |
| C_BPContactAddress | via 3 levels | CONSUMPTION | C View for BP Contact Address | |
| C_BPContactEmlAddr | via 3 levels | CONSUMPTION | C View for BP Contact Email Address | |
| C_BPContactFaxNmbr | via 3 levels | CONSUMPTION | C view fir BP contact Fax number | |
| C_BPContactMblNmbr | via 3 levels | CONSUMPTION | C view for BP contact Mobile number | |
| C_BPContactTelNmbr | via 3 levels | CONSUMPTION | C View for BP Contact Telephone number | |
| C_BPContactWbsteURL | via 3 levels | CONSUMPTION | C view fir BP contact Website URL |
RelValidityEndDate
(9 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_BPContactToAddress | direct | BP Contact person address | ||
| I_BPRelshpCntctPersnAddressTP | via 2 level | TRANSACTIONAL | RAPBO view for BP Contact Person Address | |
| I_BPRelshpCntctPersnTelNmbrTP | via 2 level | TRANSACTIONAL | RAP BO Contact Person Telephone Number | |
| C_BPCntctPersnTelNmbrTP | via 3 levels | CONSUMPTION | Projection for Contact Telephone Number | |
| C_BPContactPersonAddressTP | via 3 levels | CONSUMPTION | Projection for Contact Person Address | |
| C_BPRelshpCntctPersnAddressTP | via 3 levels | CONSUMPTION | Projection for Contact Person Address | |
| C_BPRelshpCntctPersnAddrTP_2 | via 3 levels | CONSUMPTION | Projection for Contact Person Address | |
| C_BPRelshpCntctPersnTelNmbrTP | via 3 levels | CONSUMPTION | Projection for Contact Telephone Number | |
| C_BPRelshpCntctTelNmbrTP_2 | via 3 levels | CONSUMPTION | Projection for Contact Telephone Number |
date_to
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| ICM_PARTNER_CONTACT | direct | BusinessPartner_contact |
ValidityEndDateForEdit
(12 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_BPContactAddressTP | via 2 level | TRANSACTIONAL | TP View for BP Contact Person Address | |
| I_BPContactEmlAddrTP | via 2 level | TRANSACTIONAL | TP View BP Contact Person Email Address | |
| I_BPContactFaxNmbrTP | via 2 level | TRANSACTIONAL | BO view for BP contact Fax number | |
| I_BPContactMblNmbrTP | via 2 level | TRANSACTIONAL | BO view for BP contact Mobile number | |
| I_BPContactTelNmbrTP | via 2 level | TRANSACTIONAL | TP View for BP Contact Person Telephone | |
| I_BPContactWbsteURLTP | via 2 level | TRANSACTIONAL | BO view for BP contact Website URL | |
| C_BPContactAddress | via 3 levels | CONSUMPTION | C View for BP Contact Address | |
| C_BPContactEmlAddr | via 3 levels | CONSUMPTION | C View for BP Contact Email Address | |
| C_BPContactFaxNmbr | via 3 levels | CONSUMPTION | C view fir BP contact Fax number | |
| C_BPContactMblNmbr | via 3 levels | CONSUMPTION | C view for BP contact Mobile number | |
| C_BPContactTelNmbr | via 3 levels | CONSUMPTION | C View for BP Contact Telephone number | |
| C_BPContactWbsteURL | via 3 levels | CONSUMPTION | C view fir BP contact Website URL |
Other Tables with Field DATE_TO (50+)
| Table | Data Element | Key | Description |
|---|---|---|---|
| /ACCGO/T_SNPCOM | WLF_DATE_TO | Document Snapshot : Commodity Item Fields | |
| /ACCGO/T_WASH_I | WLF_DATE_TO | Item table for Non standard washout process | |
| /IBX/T_SLICE2 | /IBX/E_DATE_TO | IPX: Time Slices | |
| /SAPAPO/TDSL | ENDDA | PPDS Time Dependent Stock Levels | |
| ACEDSASSGMT | ACE_DATETO | KEY | Standard Account Assignments for Accrual Objects |
| ACEDSOH | ACE_DATETO | KEY | Accrual Subobject Header Data |
| ACEDSOI | ACE_DATETO | KEY | Item Data for Accrual Subobject |
| ACEDSOI_ACCOUNTS | ACE_DATETO | KEY | Accounts for Accrual Postings per Accrual Item |
| ACEDSOP | ACE_DATETO | KEY | Accrual Subobject Parameters |
| ACESOBJ_ASSGMT | ACE_DATETO | KEY | Standard Account Assignments for Accrual Objects |
| ACESOBJ_ITEM | ACE_DATETO | KEY | Item Data for Accrual Subobject |
| ACESOBJ_PARAM | ACE_DATETO | KEY | Accrual Subobject Parameters |
| ADCP | AD_DATE_TO | Person/Address Assignment (Business Address Services) | |
| ADRC | AD_DATE_TO | Addresses (Business Address Services) | |
| ADRP | AD_DATE_TO | Persons (Business Address Services) | |
| AUSP | AUSPEXT_DATE_TO | Characteristic Values | |
| BP1012 | FSBP_RATING_DATE_END | KEY | Ratings |
| BP1012_DQ_RES | FSBP_RATING_DATE_END | KEY | Master Data Quality Results of OTC 147, Table BP1012 |
| BP1012_PRC | FSBP_RATING_DATE_END | KEY | Process Records Of OTC 147, Table BP1012 |
| BUR_ADCP_PRC | AD_DATE_TO | Process Records Of OTC 1405, Table ADCP | |
| BUT_ADRC_IMOUT | AD_DATE_TO | Master Data Consolidation: Process Table for ADRC | |
| BUT_ADRC_PRC | AD_DATE_TO | Master Data Consolidation: Process Table for ADRC | |
| BUT050 | BU_DATTO | KEY | BP relationships/role definitions: General data |
| BUT050_TD_PRC | BU_DATTO | KEY | MDC: Process table BUT050 Time Dependent + general data |
| BUT051 | BU_DATTO | KEY | BP Relationship: Contact Person Relationship |
| BUT053 | BU_DATTO | KEY | BP Relationship: Company Interest |
| CAWN | CAWN_DATE_TO | Characteristic values | |
| CPE_TERM | CPET_TIER_DATETO | CPE Term | |
| CRMS4D_ACTV_H | CRMS4_ACT_DATE_TO | Activity Header: Header transaction data | |
| DB_WCOCOA | WCB_DATE_TO | KEY | Generated Table for View |
| DB_WCOCOA_JEST | WCB_DATE_TO | KEY | Generated Table for View |
| DB_WCOCOH_I_ST | WCB_DATE_TO | KEY | Generated Table for View |
| DEMO_EMPL_HIER | ABAP.DATS | Employee Table for testing CDS Hierarchy | |
| DEMO_PARCHLD_PRD | ABAP.DATS | Temporary Table with Hierarchical Data and Date Fields | |
| DFKKINV_TRIG | BILL_PERIOD_TO_KK | Invoicing Request | |
| DFKKINVBILL_H | BILL_PERIOD_TO_KK | Billing Document Header | |
| DFKKINVBILL_I | ITEMPERIOD_TO_KK | Billing Document Items | |
| DFKKINVDOC_C | ITEMPERIOD_TO_KK | Invoicing Document: Charges and Discounts | |
| DFKKINVDOC_I | ITEMPERIOD_TO_KK | Items of Invoicing Document | |
| EITR | BILL_PERIOD_TO_KK | Temporary Selection Data for IS-U Invoicing | |
| FCHT_CHAIN | FCH_DATE_TO | Financial Chain | |
| FCLM_BRM_GENAPPT | SC_DATETO | Generated appointments | |
| FHC_C_FCAL_EXC | FHC_DATE_TO | KEY | Special Rules and Exceptions for Factory Calendar |
| FHC_C_FCAL_EXC_T | FHC_DATE_TO | KEY | Factory Calendars Text Table |
| FIRUD_ATXCNCDOC | FIRU_ATX_CONC_DOC_DATE_TO | Documents for asset tax concession application | |
| FKKVKP_CHGDISC | CHGDISC_DATE_TO_KK | Charges and Discounts for CtrAcct<->Partner Relationship | |
| FMLT_PRICE | FML_DATE_TO | Material Price | |
| FPM_IDA_TEST_EVT | ABAP.DATS | FPM IDA Test Data Event | |
| FPM_IDA_TEST_RES | ABAP.DATS | FPM IDA Test Data Ressource | |
| GLO_FAAT_MD_PRM | BDATU | KEY | Country-Specific Fixed Asset Master: Precious Materials |
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