_BUSINESSPARTNER

104 Fields

_BUSINESSPARTNER is an SAP database table in S/4HANA. It contains 104 fields.

Fields (104)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner,BusinessPartnerForEdit,Person 49
_AcademicTitleValueHelp _AcademicTitleValueHelp 8
_AcademicTitleVH _AcademicTitleVH 1
_AuthorizationGroup _AuthorizationGroup 9
_BPAuthorizationGroupVH _BPAuthorizationGroupVH 3
_BPCatHelpText _BPCatHelpText 1
_BPGenderText _BPGenderText 1
_BPGroupingText _BPGroupingText 1
_BusinessPartnerCategory _BusinessPartnerCategory 1
_CategoryValueHelp _CategoryValueHelp 5
_CountryText _CountryName 1
_CountryVH _CountryVH 1
_FormOfAddrOrgValueHelp _FormOfAddrOrgValueHelp 1
_FormOfAddrPersnValueHelp _FormOfAddrPersnValueHelp 1
_GenderValueHelp _GenderValueHelp 1
_GroupingValueHelp _GroupingValueHelp 4
_LegalFormText _LegalFormText 1
_LegalFormValueHelp _LegalFormValueHelp 1
AcademicTitle AcademicTitle 8
AcademicTitle2 AcademicSecondTitle 1
AcademicTitleName AcademicTitleName 1
AuthorizationGroup AuthorizationGroup,AuthorizationGroupObject 102
BirthDate BirthDate,InsurClmDriverBirthDate 11
BPCustMultiAddrIsActive BPCustMultiAddrIsActive 4
BPFirstNameSearchHelp BPFirstNameSearchHelp 10
BPLastNameSearchHelp BPLastNameSearchHelp 10
BusinessPartnerCategory BusinessPartnerCategory 25
BusinessPartnerCategoryText BusinessPartnerCategoryText 5
BusinessPartnerForEdit BusinessPartnerForEdit 5
BusinessPartnerFullName BusinessPartnerFullName,BusinessPartnerName,FullName,LglCntntMExtCntctBPName,partner_name,ProjectManagerName 94
BusinessPartnerGrouping BusinessPartnerGrouping 15
BusinessPartnerId BusinessPartnerId 1
BusinessPartnerIDByExtSystem BusinessPartnerIDByExtSystem 2
BusinessPartnerIsBlocked BusinessPartnerIsBlocked 15
BusinessPartnerName BillToPartyName,BusinessPartnerName,CACollectionAgencyName,CnstltnTskListBizPartnerName,ContactPersonFullName,FullName,InsurClmClaimantName,InsurClmDriverName,InsurClmPolicyHolderName,ServicePerformerName 124
BusinessPartnerOccupation BusinessPartnerOccupation 1
BusinessPartnerType BusinessPartnerType 3
BusinessPartnerUUID BusinessPartnerUUID,partner_guid 9
BusPartAddrLanguageIsHidden BusPartAddrLanguageIsHidden 1
BusPartGroupDataIsHidden BusPartGroupDataIsHidden 1
BusPartMaritalStatus BusPartMaritalStatus 1
BusPartNationality BusPartNationality 1
BusPartOrgDataIsHidden BusPartOrgDataIsHidden 1
BusPartPersonDataIsHidden BusPartPersonDataIsHidden 1
CityName CityName 4
CompanyName CompanyName 2
Country Country 5
CountryName CountryName 2
CreatedByUser CreatedByUser,UserID 9
CreationDate CreationDate 9
CreationTime CreationTime 1
DataController1 DataController1 53
DataController10 DataController10 53
DataController2 DataController2 53
DataController3 DataController3 53
DataController4 DataController4 53
DataController5 DataController5 53
DataController6 DataController6 53
DataController7 DataController7 53
DataController8 DataController8 53
DataController9 DataController9 53
DataControllerSet DataControllerSet 56
EmailAddress EmailAddress 2
EnvrmtWastePartnerFirstName EnvrmtWastePartnerFirstName 1
EnvrmtWastePartnerLastName EnvrmtWastePartnerLastName 1
EnvrmtWastePartnerName EnvrmtWastePartnerName 2
ETag ETag 2
FirstName FirstName,GivenName,PartnerFirstName 59
FormOfAddress FormOfAddress 5
FormOfAddressOrganization FormOfAddressOrganization 1
FormOfAddressPerson FormOfAddressPerson 1
FullName FullName 5
GenderCodeName GenderCodeName,InsurClmDriverGender 14
GroupBusinessPartnerName1 GroupBusinessPartnerName1 8
GroupBusinessPartnerName2 GroupBusinessPartnerName2 7
HouseNumber HouseNumber 3
IsBusinessPurposeCompleted bp_completed,IsBusinessPurposeCompleted 100
IsMarkedForArchiving IsMarkedForArchiving 7
IsNaturalPerson IsNaturalPerson 9
LastChangeDate LastChangeDate 10
LastChangedByUser LastChangedByUser 10
LastChangeTime LastChangeTime 3
LastName FamilyName,LastName,PartnerLastName 59
LegalForm LegalForm 8
MDChgProcessActivationTarget MDChgProcessActivationTarget 90
MDChgProcessReplicationStatus MDChgProcessReplicationStatus 89
MDChgProcessValidationStatus MDChgProcessValidationStatus 90
NameCountry NameCountry 1
OrganizationBPName1 BUSINESSPARTNERNAME,OrganizationBPName1 33
OrganizationBPName2 OrganizationBPName2 28
OrganizationBPName3 OrganizationBPName3 7
OrganizationBPName4 OrganizationBPName4 7
OrganizationFoundationDate OrganizationFoundationDate 10
OrganizationLiquidationDate OrganizationLiquidationDate 1
PersonFullName EHSTaskUserName,PersonFullName 8
PersonNumber PersonNumber 5
PhoneNumber PhoneNumber 2
Plant Plant 1
PostalCode PostalCode 4
Region Region 3
SearchTerm1 SearchTerm1 20
SearchTerm2 SearchTerm2 19
StreetName StreetName 3
TradingPartner TradingPartner 3

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _BUSINESSPARTNER (
    BUSINESSPARTNER,
    _ACADEMICTITLEVALUEHELP,
    _ACADEMICTITLEVH,
    _AUTHORIZATIONGROUP,
    _BPAUTHORIZATIONGROUPVH,
    _BPCATHELPTEXT,
    _BPGENDERTEXT,
    _BPGROUPINGTEXT,
    _BUSINESSPARTNERCATEGORY,
    _CATEGORYVALUEHELP,
    _COUNTRYTEXT,
    _COUNTRYVH,
    _FORMOFADDRORGVALUEHELP,
    _FORMOFADDRPERSNVALUEHELP,
    _GENDERVALUEHELP,
    _GROUPINGVALUEHELP,
    _LEGALFORMTEXT,
    _LEGALFORMVALUEHELP,
    ACADEMICTITLE,
    ACADEMICTITLE2,
    ACADEMICTITLENAME,
    AUTHORIZATIONGROUP,
    BIRTHDATE,
    BPCUSTMULTIADDRISACTIVE,
    BPFIRSTNAMESEARCHHELP,
    BPLASTNAMESEARCHHELP,
    BUSINESSPARTNERCATEGORY,
    BUSINESSPARTNERCATEGORYTEXT,
    BUSINESSPARTNERFOREDIT,
    BUSINESSPARTNERFULLNAME,
    BUSINESSPARTNERGROUPING,
    BUSINESSPARTNERID,
    BUSINESSPARTNERIDBYEXTSYSTEM,
    BUSINESSPARTNERISBLOCKED,
    BUSINESSPARTNERNAME,
    BUSINESSPARTNEROCCUPATION,
    BUSINESSPARTNERTYPE,
    BUSINESSPARTNERUUID,
    BUSPARTADDRLANGUAGEISHIDDEN,
    BUSPARTGROUPDATAISHIDDEN,
    BUSPARTMARITALSTATUS,
    BUSPARTNATIONALITY,
    BUSPARTORGDATAISHIDDEN,
    BUSPARTPERSONDATAISHIDDEN,
    CITYNAME,
    COMPANYNAME,
    COUNTRY,
    COUNTRYNAME,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    EMAILADDRESS,
    ENVRMTWASTEPARTNERFIRSTNAME,
    ENVRMTWASTEPARTNERLASTNAME,
    ENVRMTWASTEPARTNERNAME,
    ETAG,
    FIRSTNAME,
    FORMOFADDRESS,
    FORMOFADDRESSORGANIZATION,
    FORMOFADDRESSPERSON,
    FULLNAME,
    GENDERCODENAME,
    GROUPBUSINESSPARTNERNAME1,
    GROUPBUSINESSPARTNERNAME2,
    HOUSENUMBER,
    ISBUSINESSPURPOSECOMPLETED,
    ISMARKEDFORARCHIVING,
    ISNATURALPERSON,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    LASTNAME,
    LEGALFORM,
    MDCHGPROCESSACTIVATIONTARGET,
    MDCHGPROCESSREPLICATIONSTATUS,
    MDCHGPROCESSVALIDATIONSTATUS,
    NAMECOUNTRY,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    ORGANIZATIONBPNAME3,
    ORGANIZATIONBPNAME4,
    ORGANIZATIONFOUNDATIONDATE,
    ORGANIZATIONLIQUIDATIONDATE,
    PERSONFULLNAME,
    PERSONNUMBER,
    PHONENUMBER,
    PLANT,
    POSTALCODE,
    REGION,
    SEARCHTERM1,
    SEARCHTERM2,
    STREETNAME,
    TRADINGPARTNER,
    PRIMARY KEY (BUSINESSPARTNER)
);

Learn More