I_InvgCsMBusinessPartner

DDL: I_INVGCSMBUSINESSPARTNER SQL: IINVGCSMBP Type: view COMPOSITE
59 Fields 1 Data Sources 3 Associations

Basic View for ICM BP

I_InvgCsMBusinessPartner is a Composite CDS View that provides data about "Basic View for ICM BP" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartner_to_BP_Role) and exposes 59 fields with key field BusinessPartner. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartner_to_BP_Role _BPRole from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..1] I_InvgCsMBusinessPartnerExtn _BPExtn $projection.BusinessPartner = _BPExtn.BusinessPartner
[1..1] I_Address _Address $projection.AddressID = _Address.AddressID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IINVGCSMBP view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Basic View for ICM BP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view

Fields (59)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BusinessPartner_to_BP_Role BusinessPartner Issuing Authority
BusinessPartnerCategory _BusinessPartner BusinessPartnerCategory Partner Cat.
AuthorizationGroup _BusinessPartner AuthorizationGroup AuthorizGroup
FormOfAddress _BusinessPartner FormOfAddress Title Key
BusinessPartnerUUID
ActiveBusinessPartnerUUID _BusinessPartner BusinessPartnerUUID UUID
PersonNumber _BusinessPartner PersonNumber Person Number
BusinessPartnerName _BusinessPartner BusinessPartnerName Extracted Customer Name
BusinessPartnerFullName _BusinessPartner BusinessPartnerFullName Broker Name
FirstName _BusinessPartner FirstName First Name
LastName _BusinessPartner LastName Last Name
PersonFullName _BusinessPartner PersonFullName Full Name
OrganizationBPName1 _BusinessPartner OrganizationBPName1 Name 1
OrganizationBPName2 _BusinessPartner OrganizationBPName2 Name 2
OrganizationBPName3 _BusinessPartner OrganizationBPName3 Name 3
OrganizationBPName4 _BusinessPartner OrganizationBPName4 Name 4
LegalForm _BusinessPartner LegalForm Legal form
OrganizationFoundationDate _BusinessPartner OrganizationFoundationDate Date founded
OrganizationLiquidationDate _BusinessPartner OrganizationLiquidationDate Liquidation
GenderCodeName _BusinessPartner GenderCodeName Sex
IsFemale _BusinessPartner IsFemale Female
IsMale _BusinessPartner IsMale Male
IsSexUnknown _BusinessPartner IsSexUnknown Unknown
BirthDate _BusinessPartner BirthDate Date of Birth
InternationalLocationNumber1 _BusinessPartner InternationalLocationNumber1 Location no. 1
Industry _BusinessPartner Industry Industry Sector
AcademicTitle _BusinessPartner AcademicTitle Academic Title
NameFormat _BusinessPartner NameFormat Name Format
NameCountry _BusinessPartner NameCountry Country/Region
BusinessPartnerGrouping _BusinessPartner BusinessPartnerGrouping Grouping
BusinessPartnerType _BusinessPartner BusinessPartnerType Undefined range (can be used for patch levels)
MiddleName _BusinessPartner MiddleName Middle Name
AdditionalLastName _BusinessPartner AdditionalLastName Other Last Name
GroupBusinessPartnerName1 _BusinessPartner GroupBusinessPartnerName1 Name 1
Language _BusinessPartner Language Report Text Language
SearchTerm1 _BusinessPartner SearchTerm1 Search Term 1
SearchTerm2 _BusinessPartner SearchTerm2 Search Term 2
BPLastNameSearchHelp _BusinessPartner BPLastNameSearchHelp Name 1/Last Nme
BPFirstNameSearchHelp _BusinessPartner BPFirstNameSearchHelp Name2/First Nme
BusinessPartnerIsNotReleased _BusinessPartner BusinessPartnerIsNotReleased Not released
IsNotContractuallyCapable _BusinessPartner IsNotContractuallyCapable Not Legally Competnt
CorrespondenceLanguage _BusinessPartner CorrespondenceLanguage Language
IsBusinessPurposeCompleted _BusinessPartner IsBusinessPurposeCompleted Purpose Completed
AddressID
StreetName
HouseNumber
PostalCode
CityName
Country
Region
District
InvgCsMSecurityLevel _BPExtn InvgCsMSecurityLevel
InvgCsMIsHidden _BPExtn InvgCsMIsHidden
InvgCsMIsUnknownPerson _BPExtn InvgCsMIsUnknownPerson
_AcademicTitleText _BusinessPartner _AcademicTitleText
_AcademicTitleValueHelp _BusinessPartner _AcademicTitleValueHelp
_BPExtn _BPExtn
_BusinessPartner _BusinessPartner
_Address _Address

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_InvgCsMBusinessPartner.
-- 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.
-- SQL view name: IINVGCSMBP

CREATE VIEW I_InvgCsMBusinessPartner AS
SELECT
  _BPRole.BusinessPartner AS BusinessPartner,
  _BusinessPartner.BusinessPartnerCategory AS BusinessPartnerCategory,
  _BusinessPartner.AuthorizationGroup AS AuthorizationGroup,
  _BusinessPartner.FormOfAddress AS FormOfAddress,
  bintohex(_BusinessPartner.BusinessPartnerUUID) AS BusinessPartnerUUID,
  _BusinessPartner.BusinessPartnerUUID AS ActiveBusinessPartnerUUID,
  _BusinessPartner.PersonNumber AS PersonNumber,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  _BusinessPartner.FirstName AS FirstName,
  _BusinessPartner.LastName AS LastName,
  _BusinessPartner.PersonFullName AS PersonFullName,
  _BusinessPartner.OrganizationBPName1 AS OrganizationBPName1,
  _BusinessPartner.OrganizationBPName2 AS OrganizationBPName2,
  _BusinessPartner.OrganizationBPName3 AS OrganizationBPName3,
  _BusinessPartner.OrganizationBPName4 AS OrganizationBPName4,
  _BusinessPartner.LegalForm AS LegalForm,
  _BusinessPartner.OrganizationFoundationDate AS OrganizationFoundationDate,
  _BusinessPartner.OrganizationLiquidationDate AS OrganizationLiquidationDate,
  _BusinessPartner.GenderCodeName AS GenderCodeName,
  _BusinessPartner.IsFemale AS IsFemale,
  _BusinessPartner.IsMale AS IsMale,
  _BusinessPartner.IsSexUnknown AS IsSexUnknown,
  _BusinessPartner.BirthDate AS BirthDate,
  _BusinessPartner.InternationalLocationNumber1 AS InternationalLocationNumber1,
  _BusinessPartner.Industry AS Industry,
  _BusinessPartner.AcademicTitle AS AcademicTitle,
  _BusinessPartner.NameFormat AS NameFormat,
  _BusinessPartner.NameCountry AS NameCountry,
  _BusinessPartner.BusinessPartnerGrouping AS BusinessPartnerGrouping,
  _BusinessPartner.BusinessPartnerType AS BusinessPartnerType,
  _BusinessPartner.MiddleName AS MiddleName,
  _BusinessPartner.AdditionalLastName AS AdditionalLastName,
  _BusinessPartner.GroupBusinessPartnerName1 AS GroupBusinessPartnerName1,
  _BusinessPartner.Language AS Language,
  _BusinessPartner.SearchTerm1 AS SearchTerm1,
  _BusinessPartner.SearchTerm2 AS SearchTerm2,
  _BusinessPartner.BPLastNameSearchHelp AS BPLastNameSearchHelp,
  _BusinessPartner.BPFirstNameSearchHelp AS BPFirstNameSearchHelp,
  _BusinessPartner.BusinessPartnerIsNotReleased AS BusinessPartnerIsNotReleased,
  _BusinessPartner.IsNotContractuallyCapable AS IsNotContractuallyCapable,
  _BusinessPartner.CorrespondenceLanguage AS CorrespondenceLanguage,
  _BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _BusinessPartner._CurrentDefaultAddress.AddressID AS AddressID,
  _BusinessPartner._CurrentDefaultAddress._Address.StreetName AS StreetName,
  _BusinessPartner._CurrentDefaultAddress._Address.HouseNumber AS HouseNumber,
  _BusinessPartner._CurrentDefaultAddress._Address.PostalCode AS PostalCode,
  _BusinessPartner._CurrentDefaultAddress._Address.CityName AS CityName,
  _BusinessPartner._CurrentDefaultAddress._Address.Country AS Country,
  _BusinessPartner._CurrentDefaultAddress._Address.Region AS Region,
  _BusinessPartner._CurrentDefaultAddress._Address.District AS District,
  _BPExtn.InvgCsMSecurityLevel AS InvgCsMSecurityLevel,
  _BPExtn.InvgCsMIsHidden AS InvgCsMIsHidden,
  _BPExtn.InvgCsMIsUnknownPerson AS InvgCsMIsUnknownPerson,
  _BusinessPartner._AcademicTitleText AS _AcademicTitleText,
  _BusinessPartner._AcademicTitleValueHelp AS _AcademicTitleValueHelp
FROM I_BusinessPartner_to_BP_Role AS _BPRole
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_InvgCsMBusinessPartnerExtn AS _BPExtn ON BusinessPartner = _BPExtn.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Address AS _Address ON AddressID = _Address.AddressID  -- association [1..1]
;

Learn More