I_BUSINESSPARTNER is the Basic CDS view, which provides access to the Business Partner data in SAP S/HANA system. Core Data Services (CDS) views are semantically rich data models that provide efficient in-built functions such as aggregations, annotations, and conceptual associations.
This CDS view is found in the VDM Master Data BP: basic Views (VDM_MD_BP_BASE) package and is part of the SAP Business Partner (AP-MD-BP) module.
CDS View | I_BUSINESSPARTNER |
---|---|
DDL SQL View | IBUSINESSPARTNER |
Status | Released |
CDS View Type | Basic |
Package | VDM_MD_BP_BASE |
Technical Component | AP-MD-BP |
You can create custom CDS views for released views and expose them as a read-only OData service that delivers data tailored to the needs of your external application.
Tables Used
The following are the SAP HANA table(s) used to develop this CDS view
Table Name | Table Description |
---|---|
BUT000 | BP: General data I |
CDS View Fields
The following is the list of fields available in the CDS view and key fields are highlighted in color:
CDS View Field | Text | SQL View/Table | Table Field | Data Type | Length |
---|---|---|---|---|---|
MANDT | Client | BUT000 | CLIENT | CLNT | 3 |
BUSINESSPARTNER | Business Partner Number | BUT000 | PARTNER | CHAR | 10 |
BUSINESSPARTNERCATEGORY | Business Partner Category | BUT000 | TYPE | CHAR | 1 |
AUTHORIZATIONGROUP | Authorization Group | BUT000 | AUGRP | CHAR | 4 |
BUSINESSPARTNERUUID | Business Partner GUID | BUT000 | PARTNER_GUID | RAW | 16 |
PERSONNUMBER | Person Number | BUT000 | PERSNUMBER | CHAR | 10 |
CREATEDBYUSER | User who created the object | BUT000 | CRUSR | CHAR | 12 |
CREATIONDATE | Date on which the object was created | BUT000 | CRDAT | DATS | 8 |
CREATIONTIME | Time at which the object was created | BUT000 | CRTIM | TIMS | 6 |
LASTCHANGEDBYUSER | Last user to change object | BUT000 | CHUSR | CHAR | 12 |
LASTCHANGEDATE | Date when object was last changed | BUT000 | CHDAT | DATS | 8 |
LASTCHANGETIME | Time at which object was last changed | BUT000 | CHTIM | TIMS | 6 |
BUSINESSPARTNERISBLOCKED | Central Block for Business Partner | BUT000 | XBLCK | CHAR | 1 |
ISBUSINESSPURPOSECOMPLETED | Business Purpose Completed Flag | BUT000 | XPCPT | CHAR | 1 |
FIRSTNAME | First name of business partner (person) | BUT000 | NAME_FIRST | CHAR | 40 |
LASTNAME | Last name of business partner (person) | BUT000 | NAME_LAST | CHAR | 40 |
PERSONFULLNAME | Full Name | BUT000 | NAME1_TEXT | CHAR | 80 |
ORGANIZATIONBPNAME1 | Name 1 of organization | BUT000 | NAME_ORG1 | CHAR | 40 |
ORGANIZATIONBPNAME2 | Name 2 of organization | BUT000 | NAME_ORG2 | CHAR | 40 |
ORGANIZATIONBPNAME3 | Name 3 of organization | BUT000 | NAME_ORG3 | CHAR | 40 |
ORGANIZATIONBPNAME4 | Name 4 of organization | BUT000 | NAME_ORG4 | CHAR | 40 |
INTERNATIONALLOCATIONNUMBER1 | International location number (part 1) | BUT000 | LOCATION_1 | NUMC | 7 |
INTERNATIONALLOCATIONNUMBER2 | International location number (Part 2) | BUT000 | LOCATION_2 | NUMC | 5 |
INTERNATIONALLOCATIONNUMBER3 | Check digit for the international location number | BUT000 | LOCATION_3 | NUMC | 1 |
LEGALFORM | BP: Legal form of organization | BUT000 | LEGAL_ENTY | CHAR | 2 |
ORGANIZATIONFOUNDATIONDATE | Date organization founded | BUT000 | FOUND_DAT | DATS | 8 |
INDUSTRY | Industry sector | BUT000 | IND_SECTOR | CHAR | 10 |
ISNATURALPERSON | Business Partner Is a Natural Person Under the Tax Laws | BUT000 | NATPERS | CHAR | 1 |
ISFEMALE | Selection: Business partner is female | BUT000 | XSEXF | CHAR | 1 |
ISMALE | Selection: Business partner is male | BUT000 | XSEXM | CHAR | 1 |
ISSEXUNKNOWN | Selection: Sex of business partner is not known | BUT000 | XSEXU | CHAR | 1 |
FORMOFADDRESS | Form-of-Address Key | BUT000 | TITLE | CHAR | 4 |
ACADEMICTITLE | Academic Title: Key | BUT000 | TITLE_ACA1 | CHAR | 4 |
ACADEMICTITLE2 | Second academic title (key) | BUT000 | TITLE_ACA2 | CHAR | 4 |
NAMEFORMAT | Name format | BUT000 | NAMEFORMAT | CHAR | 2 |
NAMECOUNTRY | Country for Name Format Rule | BUT000 | NAMCOUNTRY | CHAR | 3 |
BUSINESSPARTNERGROUPING | Business Partner Grouping | BUT000 | BU_GROUP | CHAR | 4 |
BUSINESSPARTNERTYPE | Business Partner Type | BUT000 | BPKIND | CHAR | 4 |
MIDDLENAME | Middle name or second forename of a person | BUT000 | NAMEMIDDLE | CHAR | 40 |
ADDITIONALLASTNAME | Other Last Name of a Person | BUT000 | NAME_LST2 | CHAR | 40 |
GROUPBUSINESSPARTNERNAME1 | Name 1 (group) | BUT000 | NAME_GRP1 | CHAR | 40 |
GROUPBUSINESSPARTNERNAME2 | Name 2 (group) | BUT000 | NAME_GRP2 | CHAR | 40 |
CORRESPONDENCELANGUAGE | Business Partner: Correspondence Language | BUT000 | LANGU_CORR | LANG | 1 |
LANGUAGE | Business partner: Language | BUT000 | BU_LANGU | LANG | 1 |
SEARCHTERM1 | Search Term 1 for Business Partner | BUT000 | BU_SORT1 | CHAR | 20 |
SEARCHTERM2 | Search Term 2 for Business Partner | BUT000 | BU_SORT2 | CHAR | 20 |
BPLASTNAMESEARCHHELP | Search Help Field 1 (Name 1/Last Name) | BUT000 | MC_NAME1 | CHAR | 35 |
BPFIRSTNAMESEARCHHELP | Search Help Field 2 (Name 2/First Name) | BUT000 | MC_NAME2 | CHAR | 35 |
BUSINESSPARTNERNICKNAMELABEL | Nickname of Business Partner (Person) | BUT000 | NICKNAME | CHAR | 40 |
INDEPENDENTADDRESSID | Address Number | BUT000 | ADDRCOMM | CHAR | 10 |
BIRTHDATE | Date of Birth of Business Partner | BUT000 | BIRTHDT | DATS | 8 |
ISMARKEDFORARCHIVING | Central Archiving Flag | BUT000 | XDELE | CHAR | 1 |
CONTACTPERMISSION | Business Partner: Contact Permission | BUT000 | CONTACT | CHAR | 1 |
BUSINESSPARTNERIDBYEXTSYSTEM | Business Partner Number in External System | BUT000 | BPEXT | CHAR | 20 |
LEGALENTITYOFORGANIZATION | Legal Entity of Organization | BUT000 | LEGAL_ORG | CHAR | 2 |
BUSINESSPARTNERPRINTFORMAT | Business Partner Print Format | BUT000 | PRINT_MODE | CHAR | 1 |
BUSINESSPARTNERDATAORIGINTYPE | Data Origin Types | BUT000 | SOURCE | CHAR | 4 |
BUSINESSPARTNERISNOTRELEASED | Indicator: Not Released | BUT000 | NOT_RELEASED | CHAR | 1 |
ISNOTCONTRACTUALLYCAPABLE | Indicator: Not Legally Competent | BUT000 | NOT_LG_COMPETENT | CHAR | 1 |
BUSINESSPARTNEROCCUPATION | Occupation/group | BUT000 | JOBGR | CHAR | 4 |
BUSPARTMARITALSTATUS | Marital Status of Business Partner | BUT000 | MARST | CHAR | 1 |
BUSPARTNATIONALITY | Nationality | BUT000 | NATIO | CHAR | 3 |
NONRESIDENTCOMPANYORIGINCNTRY | Ctry of Origin: Non-Res. Companies | BUT000 | CNDSC | CHAR | 3 |
BUSINESSPARTNERSALUTATION | Salutation | BUT000 | TITLE_LET | CHAR | 50 |
BUSINESSPARTNERBIRTHNAME | Name at birth of business partner | BUT000 | NAME_LAST2 | CHAR | 40 |
BUSINESSPARTNERSUPPLEMENTNAME | Name supplement, e.g. noble title (key) | BUT000 | TITLE_ROYL | CHAR | 4 |
BUSINESSPARTNERBIRTHPLACENAME | Birthplace of business partner | BUT000 | BIRTHPL | CHAR | 40 |
NATURALPERSONEMPLOYERNAME | Name of Employer of a Natural Person | BUT000 | EMPLO | CHAR | 35 |
BUSINESSPARTNERDEATHDATE | Date of death of business partner | BUT000 | DEATHDT | DATS | 8 |
BUSINESSPARTNERBIRTHDATESTATUS | Date of Birth: Status | BUT000 | BIRTHDT_STATUS | CHAR | 1 |
BUSINESSPARTNERGROUPTYPE | Group type | BUT000 | PARTGRPTYP | CHAR | 4 |
LASTNAMEPREFIX | Name Prefix (Key) | BUT000 | PREFIX1 | CHAR | 4 |
LASTNAMESECONDPREFIX | 2nd name prefix (key) | BUT000 | PREFIX2 | CHAR | 4 |
INITIALS | Middle Initial or personal initials | BUT000 | INITIALS | CHAR | 10 |
GENDERCODENAME | Sex of business partner (person) | BUT000 | GENDER | CHAR | 1 |
TRDCMPLNCLICENSEISMILITARYSCTR | ID for mainly military use | BUT000 | MILVE | CHAR | 1 |
TRDCMPLNCLICENSEISNUCLEARSCTR | Nuclear Sector (Indicator) | BUT000 | NUC_SEC | CHAR | 1 |
CDS View Annotaions
The following are the CDS View Annotations used in this CDS view:
CDS Annotation Name | CDS Annotation Value |
---|---|
ACCESSCONTROL.AUTHORIZATIONCHECK | #CHECK |
ANALYTICS.DATACATEGORY | #DIMENSION |
ANALYTICS.DATAEXTRACTION.ENABLED | true |
ABAPCATALOG.PRESERVEKEY | true |
ANALYTICS.DATAEXTRACTION.DELTA.CHANGEDATACAPTURE.AUTOMATIC | true |
METADATA.ALLOWEXTENSIONS | true |
METADATA.IGNOREPROPAGATEDANNOTATIONS | true |
ACCESSCONTROL.PERSONALDATA.BLOCKING | #BLOCKED_DATA_EXCLUDED |
CLIENTHANDLING.ALGORITHM | #SESSION_VARIABLE |
ABAPCATALOG.SQLVIEWNAME | ‘IBUSINESSPARTNER’ |
OBJECTMODEL.USAGETYPE.SERVICEQUALITY | #A |
OBJECTMODEL.REPRESENTATIVEKEY | ‘BusinessPartner’ |
OBJECTMODEL.USAGETYPE.DATACLASS | #MASTER |
OBJECTMODEL.USAGETYPE.SIZECATEGORY | #XL |
VDM.VIEWTYPE | #BASIC |
ENDUSERTEXT.LABEL | ‘Business Partner’ |
Availability
The CDS view I_BUSINESSPARTNER is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
SAP S/4HANA Version | Released |
---|---|
1909 | Yes |
2020 | Yes |
2021 | Yes |
2022 | Yes |
2023 | Yes |
Supported Capabilities
It is possible for a single CDS view to provide many capabilities such as a data source, association target, or analytical provider. Supported Capabilities indicates clear use cases for CDS views and provides an idea of the most efficient ways to use a CDS view. Each CDS view can have multiple supported capabilities.
Supported Capabilities are not defined for this CDS view.
Extensibility
Coming Soon!!
Related CDS Views
Coming Soon!!