BUPA_INMOB_D_2
Draft table for entity I_BPADDRESSINDEPENDNTMOBTP_2
BUPA_INMOB_D_2 is an SAP database table in S/4HANA. Draft table for entity I_BPADDRESSINDEPENDNTMOBTP_2. It contains 36 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_BPAddrIndependentMobileDraft | view_entity | from | BASIC | BP AddrIndependentMobile-Draft |
Fields (36)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | businesspartner | bu_partner | Busn. Partner | |||
| KEY | addressid | ad_addrnum | Address Number | |||
| KEY | person | ad_persnum | Person Number | |||
| KEY | ordinalnumber | ad_consnum | Sequence Number | |||
| KEY | draftuuid | sdraft_uuid | Draft Document ID | |||
| parentdraftuuid | sdraft_uuid | Draft Document ID | ||||
| addressidforedit | ad_addrnum | Address Number | ||||
| ordinalnumberforedit | ad_consnum | Sequence Number | ||||
| mobilephonecountry | ad_comctry | Country/Region | ||||
| telephonecountryprefix | sktelfto | Tel. to | ||||
| isdefaultphonenumber | boole_d | TRUE | ||||
| commnumberisnotused | ad_flnouse | Do not use | ||||
| mobilephonenumber | ad_tlnmbr | Telephone | ||||
| phonenumberextension | ad_tlxtns | Extension | ||||
| completetelephonenumber | ad_telnrlg | Telephone no. | ||||
| phoneissmsenabled | ad_flgsms | SMS-Enab. | ||||
| phonenumbertype | ad_phonenumbertype | Phone number type | ||||
| authorizationgroup | bu_augrp | Authorization Group | ||||
| addresscommunicationremarktext | ad_remark2 | Notes | ||||
| isbusinesspurposecompleted | bu_xpcpt | Purpose Completed | ||||
| validitystartdate | abap.dats | |||||
| validityenddate | abap.dats | |||||
| validitystartdatetime | ad_valfrom | Valid From | ||||
| validityenddatetime | ad_valto | Valid To | ||||
| datacontrollerset | bu_xdcset | Data Ctrlr. Set | ||||
| datacontroller1 | bu_data_controller | Data Controller | ||||
| datacontroller2 | bu_data_controller | Data Controller | ||||
| datacontroller3 | bu_data_controller | Data Controller | ||||
| datacontroller4 | bu_data_controller | Data Controller | ||||
| datacontroller5 | bu_data_controller | Data Controller | ||||
| datacontroller6 | bu_data_controller | Data Controller | ||||
| datacontroller7 | bu_data_controller | Data Controller | ||||
| datacontroller8 | bu_data_controller | Data Controller | ||||
| datacontroller9 | bu_data_controller | Data Controller | ||||
| datacontroller10 | bu_data_controller | Data Controller |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Draft table for entity I_BPADDRESSINDEPENDNTMOBTP_2
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUPA_INMOB_D_2 (
MANDT, -- Client [mandt]
BUSINESSPARTNER, -- Busn. Partner [bu_partner]
ADDRESSID, -- Address Number [ad_addrnum]
PERSON, -- Person Number [ad_persnum]
ORDINALNUMBER, -- Sequence Number [ad_consnum]
DRAFTUUID, -- Draft Document ID [sdraft_uuid]
PARENTDRAFTUUID, -- Draft Document ID [sdraft_uuid]
ADDRESSIDFOREDIT, -- Address Number [ad_addrnum]
ORDINALNUMBERFOREDIT, -- Sequence Number [ad_consnum]
MOBILEPHONECOUNTRY, -- Country/Region [ad_comctry]
TELEPHONECOUNTRYPREFIX, -- Tel. to [sktelfto]
ISDEFAULTPHONENUMBER, -- TRUE [boole_d]
COMMNUMBERISNOTUSED, -- Do not use [ad_flnouse]
MOBILEPHONENUMBER, -- Telephone [ad_tlnmbr]
PHONENUMBEREXTENSION, -- Extension [ad_tlxtns]
COMPLETETELEPHONENUMBER, -- Telephone no. [ad_telnrlg]
PHONEISSMSENABLED, -- SMS-Enab. [ad_flgsms]
PHONENUMBERTYPE, -- Phone number type [ad_phonenumbertype]
AUTHORIZATIONGROUP, -- Authorization Group [bu_augrp]
ADDRESSCOMMUNICATIONREMARKTEXT, -- Notes [ad_remark2]
ISBUSINESSPURPOSECOMPLETED, -- Purpose Completed [bu_xpcpt]
VALIDITYSTARTDATE, -- abap.dats
VALIDITYENDDATE, -- abap.dats
VALIDITYSTARTDATETIME, -- Valid From [ad_valfrom]
VALIDITYENDDATETIME, -- Valid To [ad_valto]
DATACONTROLLERSET, -- Data Ctrlr. Set [bu_xdcset]
DATACONTROLLER1, -- Data Controller [bu_data_controller]
DATACONTROLLER2, -- Data Controller [bu_data_controller]
DATACONTROLLER3, -- Data Controller [bu_data_controller]
DATACONTROLLER4, -- Data Controller [bu_data_controller]
DATACONTROLLER5, -- Data Controller [bu_data_controller]
DATACONTROLLER6, -- Data Controller [bu_data_controller]
DATACONTROLLER7, -- Data Controller [bu_data_controller]
DATACONTROLLER8, -- Data Controller [bu_data_controller]
DATACONTROLLER9, -- Data Controller [bu_data_controller]
DATACONTROLLER10, -- Data Controller [bu_data_controller]
PRIMARY KEY (MANDT, BUSINESSPARTNER, ADDRESSID, PERSON, ORDINALNUMBER, DRAFTUUID)
);
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