CONSNUMBER in ADR6
Sequence Number (DE: Laufende Nummer)
CONSNUMBER is a field in SAP table ADR6 (E-Mail Addresses (Business Address Services)). It represents "Sequence Number". Data element: AD_CONSNUM. Available in 47 CDS view(s) as OrdinalNumber, CommMediumSequenceNumber, consnumber_1.
Business Meaning
| Description (EN) | Sequence Number |
|---|---|
| Beschreibung (DE) | Laufende Nummer |
| Data Element | AD_CONSNUM |
| Key Field | Yes |
CDS Views & Technical Names (47)
ADR6.CONSNUMBER 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.
OrdinalNumber
(33 views)
Sequence Number
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_AddressEmailAddress | direct | BASIC | Email Address | |
| I_Addressindependentemail | direct | BASIC | Core view Addr Indep Email | |
| I_BPCntctPersnEmailAddrGov | direct | TRANSACTIONAL | Base Union WplcAddr Email | |
| A_AddressEmailAddress | via 2 level | BASIC | Email Address | |
| A_BPContactPersonEmlAddr | via 2 level | BASIC | Contact Person Email Address | |
| A_BPContactWorkPlaceEmailAddr | via 2 level | BASIC | BP Contact Work Place Email Address | |
| C_IHBBusPartnerEmailAddressVH | via 2 level | CONSUMPTION | IHB Business Partner Email Address | |
| I_BPAddressIndependentEmail | via 2 level | BASIC | Root View for Address Independent Email for BP app | |
| I_BPCntctPersnEmailAddrGovTP | via 2 level | TRANSACTIONAL | Base WplcAddr Email - TP | |
| I_BPContactEmlAddrTP | via 2 level | TRANSACTIONAL | TP View BP Contact Person Email Address | |
| I_BPEmailAddress | via 2 level | BASIC | Business Partner Email Core View | |
| I_BPRelshpCntctPersnEmlAddrTP | via 2 level | TRANSACTIONAL | RAP BO Contact Person Email Address | |
| I_ElectronicDocCockpitSuplrEml | via 2 level | COMPOSITE | Electronic Document: Supplier and Email | |
| I_IHBBusPartnerEmailAddress | via 2 level | COMPOSITE | IHB Business Partner Email Address | |
| C_BPCntctPersnEmailAddressTP | via 3 levels | CONSUMPTION | Projection for Contact Email Address | |
| C_BPCntctPersnEmailAddrGovTP | via 3 levels | CONSUMPTION | WorkplaceAddress Email | |
| C_BPContactEmlAddr | via 3 levels | CONSUMPTION | C View for BP Contact Email Address | |
| C_BPRelshpCntctEmlAddrTP_2 | via 3 levels | CONSUMPTION | Projection for Contact Email Address | |
| C_BPRelshpCntctPersnEmlAddrTP | via 3 levels | CONSUMPTION | Projection for Contact Email Address | |
| I_BPAddlCustEmailAddressTP | via 3 levels | TRANSACTIONAL | BO view for email for MLTAS customers | |
| I_BPAddlSuplrEmailAddressTP | via 3 levels | TRANSACTIONAL | BO view for email for MLTAS suppliers | |
| I_BPAddressIndependentEmailTP | via 3 levels | TRANSACTIONAL | Transactional Processing view for Address Independent Email | |
| I_BPAddrIndependentEmailTP_2 | via 3 levels | TRANSACTIONAL | BP Address Independent Email | |
| I_BPEmailAddressTP | via 3 levels | TRANSACTIONAL | Business Partner Email BO view | |
| I_BusPartEmailAddressTP_2 | via 3 levels | TRANSACTIONAL | Transactional View For I_BusPartEmailAddress | |
| C_BPAddlCustEmailAddress | via 4 levels | CONSUMPTION | C view for email address of mlt customer | |
| C_BPAddlSuplrEmailAddress | via 4 levels | CONSUMPTION | C view for email address of mlt supplier | |
| C_BPAddressIndependentEmail | via 4 levels | CONSUMPTION | Consumption view for Address Independent Email for BP app | |
| C_BPAddrIndependentEmailTP_2 | via 4 levels | CONSUMPTION | BP Address Independent Email | |
| C_BPEmailAddress | via 4 levels | CONSUMPTION | Business Partner Email Consumption View | |
| C_BusPartEmailAddressTP_2 | via 4 levels | CONSUMPTION | Projection View for I_BusPartEmailAddressTP_2 | |
| I_BPAddrIndependentEmailTP_3 | via 4 levels | TRANSACTIONAL | Address Independent Email | |
| I_BusPartEmailAddressTP_3 | via 4 levels | TRANSACTIONAL | BP Email Address |
CommMediumSequenceNumber
(5 views)
Sequence Number
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_AddressEmailAddress_2 | direct | BASIC | Email Address | |
| I_AddrCurDefaultEmailAddress | via 2 level | BASIC | Current Default Email Address | |
| R_AddressEmailAddressTP | via 2 level | Email Address - TP | ||
| R_EmailAddressTP | via 2 level | TRANSACTIONAL | Email Address - TP | |
| C_EmailAddressTP | via 3 levels | CONSUMPTION | Projection view for R_EmailAddressTP |
consnumber_1
(3 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| ICM_PARTNER_CONTACT | direct | BusinessPartner_contact | ||
| ICM_PARTNER_ORGANIZATION | direct | BusinessPartner_Organization | ||
| ICM_PARTNER_PERSON | direct | BusinessPartner_person |
consnumber
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| FNDEI_ADR6_BLOCKINGINFO | direct | Blocking View for table ADR6 | ||
| fndei_adr6_filter | direct | Filter View for table ADR6 |
consnumber_adr6
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| ICM_BP_ADDR_INDP | direct | BusinessPartner_Address_Indep | ||
| ICM_EMPLOYEE_CONTACT | direct | Employee |
FrcElmntOrgAddrSequenceNumber
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_FrcElmntOrgEmailAddress | direct | BASIC | ||
| I_FrcElmntOrgEmailAddress | via 2 level | BASIC | Interface View for Force Element Org Email Address |
OrdinalNumberForEdit
(13 views)
Sequence Number
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_BPAddressIndependentEmail | via 2 level | BASIC | Root View for Address Independent Email for BP app | |
| I_BPCntctPersnEmailAddrGovTP | via 2 level | TRANSACTIONAL | Base WplcAddr Email - TP | |
| I_BPContactEmlAddrTP | via 2 level | TRANSACTIONAL | TP View BP Contact Person Email Address | |
| I_BPRelshpCntctPersnEmlAddrTP | via 2 level | TRANSACTIONAL | RAP BO Contact Person Email Address | |
| C_BPCntctPersnEmailAddrGovTP | via 3 levels | CONSUMPTION | WorkplaceAddress Email | |
| C_BPContactEmlAddr | via 3 levels | CONSUMPTION | C View for BP Contact Email Address | |
| I_BPAddressIndependentEmailTP | via 3 levels | TRANSACTIONAL | Transactional Processing view for Address Independent Email | |
| I_BPAddrIndependentEmailTP_2 | via 3 levels | TRANSACTIONAL | BP Address Independent Email | |
| I_BusPartEmailAddressTP_2 | via 3 levels | TRANSACTIONAL | Transactional View For I_BusPartEmailAddress | |
| C_BPAddrIndependentEmailTP_2 | via 4 levels | CONSUMPTION | BP Address Independent Email | |
| C_BusPartEmailAddressTP_2 | via 4 levels | CONSUMPTION | Projection View for I_BusPartEmailAddressTP_2 | |
| I_BPAddrIndependentEmailTP_3 | via 4 levels | TRANSACTIONAL | Address Independent Email | |
| I_BusPartEmailAddressTP_3 | via 4 levels | TRANSACTIONAL | BP Email Address |
Other Tables with Field CONSNUMBER (24)
| Table | Data Element | Key | Description |
|---|---|---|---|
| ADR12 | AD_CONSNUM | KEY | FTP and URL (Business Address Services) |
| ADR13 | AD_CONSNUM | KEY | Pager (Business Address Services) |
| ADR2 | AD_CONSNUM | KEY | Telephone Numbers (Business Address Services) |
| ADR3 | AD_CONSNUM | KEY | Fax Numbers (Business Address Services) |
| ADRT | AD_CONSNUM | KEY | Communication Data Text (Business Address Services) |
| ADRU | AD_CONSNUM | KEY | Table for Communication Usages |
| BUR_ADR12_PRC | AD_CONSNUM | KEY | Process Records Of OTC 1405, Table ADR12 |
| BUR_ADR2_PRC | AD_CONSNUM | KEY | Process Records Of OTC 1405, Table ADR2 |
| BUR_ADR3_PRC | AD_CONSNUM | KEY | Process Records Of OTC 1405, Table ADR3 |
| BUR_ADR6_PRC | AD_CONSNUM | KEY | Process Records Of OTC 1405, Table ADR6 |
| BUT_ADR12_IN_PRC | AD_CONSNUM | KEY | Process Records Of OTC 147, Table ADR12_IN |
| BUT_ADR12_PRC | AD_CONSNUM | KEY | Master Data Consolidation: Process Table for ADR12 |
| BUT_ADR2_DQ_RES | AD_CONSNUM | KEY | Master Data Quality Results of OTC 147, Table ADR2 |
| BUT_ADR2_IN_DQ | AD_CONSNUM | KEY | Master Data Quality Results of OTC 147, Table ADR2_IN |
| BUT_ADR2_IN_PRC | AD_CONSNUM | KEY | Process Records Of OTC 147, Table ADR2_IN |
| BUT_ADR2_PRC | AD_CONSNUM | KEY | Master Data Consolidation: Process Table for ADR2 |
| BUT_ADR3_DQ_RES | AD_CONSNUM | KEY | Master Data Quality Results of OTC 147, Table ADR3 |
| BUT_ADR3_IN_DQ | AD_CONSNUM | KEY | Master Data Quality Results of OTC 147, Table ADR3_IN |
| BUT_ADR3_IN_PRC | AD_CONSNUM | KEY | Process Records Of OTC 147, Table ADR3_IN |
| BUT_ADR3_PRC | AD_CONSNUM | KEY | Master Data Consolidation: Process Table for ADR3 |
| BUT_ADR6_DQ_RES | AD_CONSNUM | KEY | Master Data Quality Results of OTC 147, Table ADR6 |
| BUT_ADR6_IN_DQ | AD_CONSNUM | KEY | Master Data Quality Results of OTC 147, Table ADR6_IN |
| BUT_ADR6_IN_PRC | AD_CONSNUM | KEY | Process Records Of OTC 147, Table ADR6_IN |
| BUT_ADR6_PRC | AD_CONSNUM | KEY | Master Data Consolidation: Process Table for ADR12 |
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