I_BPIndepMobileNumberProc

DDL: I_BPINDEPMOBILENUMBERPROC Type: view_entity
19 Fields 1 Data Sources

Core View: BP Indep Mobile Number(Process)

I_BPIndepMobileNumberProc is a CDS View that provides data about "Core View: BP Indep Mobile Number(Process)" in SAP S/4HANA. It reads from 1 data source (I_BPIndepPhoneNumbersProc) and exposes 19 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, OrdinalNumber.

Data Sources (1)

SourceAliasJoin Type
I_BPIndepPhoneNumbersProc I_BPIndepPhoneNumbersProc from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Core View: BP Indep Mobile Number(Process) view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
KEY MDChgProcessStep MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject MDChgProcessSrceObject Source ID
KEY OrdinalNumber OrdinalNumber Sequence Number
AddressNumber AddressNumber Src Address No
AddrCommunicationValidFromDate AddrCommunicationValidFromDate Validity Start Date
MobilePhoneCountry DestinationLocationCountry Country/Region
CommNumberIsNotUsed CommNumberIsNotUsed Do not use
MobilePhoneNumber PhoneNumber Telephone no.
CompleteTelephoneNumber InternationalPhoneNumber Telephone no.
PhoneIsSMSEnabled PhoneIsSMSEnabled SMS-Enab.
PhoneNumberType PhoneNumberType Phone number type
ValidityStartDateTime ValidityStartDateTime Valid From Timestamp
ValidityEndDateTime ValidityEndDateTime Valid To Timestamp
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime Last Changed On
MDChgProcessSourceModified MDChgProcessSourceModified Modified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary Modification
_BusinessPartner _BusinessPartner

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_BPIndepMobileNumberProc.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_BPIndepMobileNumberProc AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  OrdinalNumber,
  AddressNumber,
  AddrCommunicationValidFromDate,
  DestinationLocationCountry AS MobilePhoneCountry,
  CommNumberIsNotUsed,
  PhoneNumber AS MobilePhoneNumber,
  InternationalPhoneNumber AS CompleteTelephoneNumber,
  PhoneIsSMSEnabled,
  PhoneNumberType,
  ValidityStartDateTime,
  ValidityEndDateTime,
  MDChgProcSrceLastChgdDateTime,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary
FROM I_BPIndepPhoneNumbersProc
;

Learn More