DATE_TO in BUT050
Valid To (DE: Gültig bis)
DATE_TO is a field in SAP table BUT050 (GP-Beziehungen/GP-Rollenfindungen: Allgemeine Daten). It represents "Valid To". Data element: BU_DATTO. Available in 52 CDS view(s) as ValidityEndDate, EndDate, validuntildate.
Business Meaning
| Description (EN) | Valid To |
|---|---|
| Beschreibung (DE) | Gültig bis |
| Data Element | BU_DATTO |
| Key Field | Yes |
CDS Views & Technical Names (52)
BUT050.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
(25 views)
Validity Date (Valid To)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_BPContact | direct | BASIC | Business Partner Contact | |
| I_BPRelationship | direct | BASIC | Business Partner Relationship | |
| I_BPRelationship_2 | direct | BASIC | Business Partner Relationship | |
| I_BPRelationshipUnion | direct | BASIC | Business Partner Relationship | |
| I_BPTranspSalesRepresentative | direct | BASIC | Core View BP Transp Sales Representative | |
| I_CrdtMAcctRelationship | direct | BASIC | Credit Management Account Relationsship | |
| I_JITBusPartContact | direct | BASIC | JIT Customer Contact Person Relationship | |
| P_BPContactToAddress | direct | BP Contact person address | ||
| P_BusinessPartnerContacts | direct | BASIC | Business Partner Contact | |
| P_Businesspartnerpcontacts | direct | BASIC | Business Partner Contacts | |
| A_BPRelationship | via 2 level | BASIC | Business Partner Relationship | |
| A_BusinessPartnerContact | via 2 level | BASIC | Contact | |
| C_LglCntntMExtContactByBPVH | via 2 level | CONSUMPTION | External Contact by General Data | |
| I_BusinessPartnerContact | via 2 level | COMPOSITE | Business Partner Contact | |
| I_BusinessPartnerContactTP | via 2 level | TRANSACTIONAL | Business Partner Contact BO View | |
| I_BusPartRelationshipTP_2 | via 2 level | TRANSACTIONAL | BO View fot BUPA Relationship | |
| I_SupplierToEmployment | via 2 level | COMPOSITE | Supplier with his supported employments | |
| I_WrkfrcPersnRelshpToCoTP | via 2 level | Workforce Person Relationship to Company | ||
| R_BPRelationshipCurrent | via 2 level | COMPOSITE | BP Relationship Current (valid today) | |
| R_BPRelationshipNext | via 2 level | COMPOSITE | BP Relationship Next (valid in future) | |
| R_BPRelationshipPrevious | via 2 level | COMPOSITE | BP Relationship Previous (valid in past) | |
| C_BusinessPartnerContact | via 3 levels | CONSUMPTION | Consumption BusinessPartner Contact | |
| C_BusPartRelationship | via 3 levels | CONSUMPTION | Consumption view for BUPA relationships | |
| I_CustomerContact | via 3 levels | COMPOSITE | CustomerContact | |
| R_BPRelationshipLatest | via 3 levels | COMPOSITE | BP Relationship Latest |
EndDate
(7 views)
Validity Date (Valid To)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_ServicePerformerFor | direct | BASIC | Service Performer | |
| I_SupplierDetail | via 2 level | BASIC | Supplier for Contingent Worker | |
| I_WorkAssgmtWorkOrderDEX | via 2 level | COMPOSITE | Assignment Work Order Details | |
| I_WrkAssgmtWrkOrderDetail | via 2 level | COMPOSITE | Assignment Work Order Details | |
| R_SupplierDetail | via 2 level | COMPOSITE | Supplier for Contingent Worker | |
| R_WrkAssgmtWrkOrdDet | via 2 level | TRANSACTIONAL | Workorder details for Work Assignment | |
| C_SupplierDetail | via 3 levels | CONSUMPTION | Supplier of Contingent Worker |
validuntildate
(3 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| /BOFU/VE_BPRCP | direct | BOPF: Business Partner Contact Person | ||
| /BOFU/VE_BPRL | direct | BOPF: Business Partner Relationship | ||
| /BOFU/CV_Q_BPRelationship | via 2 level | BOPF: Business Partner Query on Relshp |
date_to
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| SHSM_FKK_CM_CPERS | direct | Ersatz für FKK_CNTCT_PRSN in Suchhilfe |
ValidityEndDateForEdit
(12 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_BusinessPartnerContactTP | via 2 level | TRANSACTIONAL | Business Partner Contact BO View | |
| I_BusPartRelationshipTP | via 2 level | TRANSACTIONAL | RAP BO View for BUPA Relationship | |
| I_BusPartRelationshipTP_2 | via 2 level | TRANSACTIONAL | BO View fot BUPA Relationship | |
| C_BusinessPartnerContact | via 3 levels | CONSUMPTION | Consumption BusinessPartner Contact | |
| C_BusPartContactPersonTP | via 3 levels | CONSUMPTION | Projection view for Contact Persons | |
| C_BusPartRelationship | via 3 levels | CONSUMPTION | Consumption view for BUPA relationships | |
| C_BusPartRelationshipTP | via 3 levels | CONSUMPTION | Projection view for BUPA relationship | |
| C_BusPartRelationshipTP_2 | via 3 levels | CONSUMPTION | Projection view for BUPA relationship | |
| I_BPRelshpContactPersonTmpTP | via 3 levels | TRANSACTIONAL | Contact Person Temp View | |
| I_BusPartRelationshipTmpTP | via 3 levels | TRANSACTIONAL | BP Relationship Dummy Entity | |
| C_BPRelshpContactPersonTmpTP_2 | via 4 levels | CONSUMPTION | Relationship Contact Person Temp View | |
| C_BusPartRelationshipTmpTP | via 4 levels | CONSUMPTION | Business Partner Relationship Dummy Proj |
WorkAssignmentEndDate
(4 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| R_WrkAssgmtWrkOrdDetTP | via 3 levels | TRANSACTIONAL | Workassignment Workorder details - TP | |
| R_WrkAssgmtWrkOrdDetTP_3 | via 3 levels | TRANSACTIONAL | Workassignment Workorder details - TP | |
| A_WrkAssgmtWrkOrdDet | via 4 levels | CONSUMPTION | Workforce Person Assignment Work Order Detail CDS | |
| I_WrkAssgmtWrkOrdDetTP | via 4 levels | TRANSACTIONAL | Projection of Workorder - TP |
BPRelationshipEndDateForEdit
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| R_BPRltnShipSupplierTP | via 2 level | TRANSACTIONAL | TP View for Business Partner Relationship to suppliers | |
| C_BPRltnShipSupplier | via 3 levels | CONSUMPTION | BP Relationship to Supplier |
EndDateForBPRelationshipFoEd
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| R_BPRltnShipSupplierTP_2 | via 2 level | TRANSACTIONAL | TP View for Business Partner Relationship to suppliers | |
| C_BPRltnShipSupplier_2 | via 3 levels | CONSUMPTION | BP Relationship to Supplier |
Other Tables with Field DATE_TO (32)
| Table | Data Element | Key | Description |
|---|---|---|---|
| ADCP | AD_DATE_TO | Zuordnung Person/Adresse (Business Address Services) | |
| ADRC | AD_DATE_TO | Adressen (Business Address Services) | |
| ADRP | AD_DATE_TO | Personen (Business Address Services) | |
| 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_TD_PRC | BU_DATTO | KEY | MDC: Process table BUT050 Time Dependent + general data |
| BUT051 | BU_DATTO | KEY | GP-Beziehung: Ansprechpartnerbeziehung |
| BUT052 | BU_DATTO | KEY | GP-Beziehung: Adressen |
| BUT053 | BU_DATTO | KEY | GP-Beziehung: Firmenbeteiligung |
| CAWN | CAWN_DATE_TO | Merkmalwerte | |
| CPE_TERM | CPET_TIER_DATETO | CPE Term | |
| DEMO_EMPL_HIER | ABAP.DATS | Employee Table for testing CDS Hierarchy | |
| DEMO_PARCHLD_PRD | ABAP.DATS | Temporary Table with Hierarchical Data and Date Fields | |
| 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 | |
| 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 |
| MDI_BUT050_OID | BU_DATTO | KEY | Mapping table for BP Relationship Key attributes to ODM CUID |
| PPH_DD_STK | PPH_ENDDA | Time Dependent Actual Stock Levels | |
| SUSG_ADMIN | SUSG_DATE_TO | Usage Data: Admin | |
| UDMBPTEMPASSIGNM | UDM_DATE_TO | KEY | Temporäre Zuordnungen im Geschäftspartner |
| UTI_BIT_MTRRDNG | BITPERIODTO_KK | Utilities Meter Readings for Billable Items | |
| UTI_BIT_PREVPQTY | BITPERIODTO_KK | Utilities Previous Period Quantity for Billable Items | |
| VCH_CFE_BATCH | DATUV | Secondary Persistence for Batch Characteristics | |
| VCH_CFE_CONF_CPS | DATUB | Secondary Persistence for Capacity Planning and Scheduling | |
| VCH_CFE_CONFIG | DATUV | Secondary Persistence for Config Characteristics | |
| WCOCOH | WCB_DATE_TO | Condition Contract: Header | |
| WCOCOI | WCB_DATE_TO_I | Condition Contract: Eligible Partner | |
| WRF_MATGRP_SKU | WRF_DATE_TO | Article Assignments Table |
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