_BP

49 Fields

_BP is an SAP database table in S/4HANA. It contains 49 fields.

Fields (49)

KeyField CDS FieldsUsed in Views
KEY BPCounterParty BPCounterParty 1
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDChgProcessSrceObject MDChgProcessSrceObject 1
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 1
KEY MDChgProcessStep MDChgProcessStep 1
_AcademicTitleText _AcademicTitleText 2
_AcademicTitleValueHelp _AcademicTitleValueHelp 2
_BusinessPartner _BusinessPartner 1
AcademicTitle AcademicTitle 2
AddressID AddressID 4
AuthorizationGroup AuthorizationGroup 5
BankCountryKey BankCountry 1
BankNumber BankInternalID 1
BirthDate BirthDate 2
BusinessPartner BusinessPartner 12
BusinessPartnerCategory BusinessPartnerCategory 4
BusinessPartnerFullName InvgCsMActivityMainPtyName 1
BusinessPartnerName businessPartnerName 5
DataController1 DataController1 5
DataController10 DataController10 5
DataController2 DataController2 5
DataController3 DataController3 5
DataController4 DataController4 5
DataController5 DataController5 5
DataController6 DataController6 5
DataController7 DataController7 5
DataController8 DataController8 5
DataController9 DataController9 5
DataControllerSet DataControllerSet 5
FirstName FirstName 3
firstNameGroup firstNameGroup 1
firstNameOrg firstNameOrg 1
FormOfAddress FormOfAddress 2
GenderCodeName GenderCodeName 2
InvgCsMIsUnknownPerson InvgCsMIsUnknownPerson 2
InvgCsMSecurityLevel InvgCsMSecurityLevel 4
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 5
IsFemale IsFemale 1
LastName LastName 3
lastNameGroup lastNameGroup 1
lastNameOrg lastNameOrg 1
LegalForm LegalForm 2
Name BusinessPartnerName 1
OrganizationBPName1 OrganizationBPName1 2
OrganizationFoundationDate OrganizationFoundationDate 2
OrganizationLiquidationDate OrganizationLiquidationDate 2
PersonFullName PersonFullName 1
SearchTerm1 SearchTerm1 1
SearchTerm2 SearchTerm2 1

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 _BP (
    BPCOUNTERPARTY,
    MASTERDATACHANGEPROCESS,
    MDCHGPROCESSSRCEOBJECT,
    MDCHGPROCESSSRCESYSTEM,
    MDCHGPROCESSSTEP,
    _ACADEMICTITLETEXT,
    _ACADEMICTITLEVALUEHELP,
    _BUSINESSPARTNER,
    ACADEMICTITLE,
    ADDRESSID,
    AUTHORIZATIONGROUP,
    BANKCOUNTRYKEY,
    BANKNUMBER,
    BIRTHDATE,
    BUSINESSPARTNER,
    BUSINESSPARTNERCATEGORY,
    BUSINESSPARTNERFULLNAME,
    BUSINESSPARTNERNAME,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    FIRSTNAME,
    FIRSTNAMEGROUP,
    FIRSTNAMEORG,
    FORMOFADDRESS,
    GENDERCODENAME,
    INVGCSMISUNKNOWNPERSON,
    INVGCSMSECURITYLEVEL,
    ISBUSINESSPURPOSECOMPLETED,
    ISFEMALE,
    LASTNAME,
    LASTNAMEGROUP,
    LASTNAMEORG,
    LEGALFORM,
    NAME,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONFOUNDATIONDATE,
    ORGANIZATIONLIQUIDATIONDATE,
    PERSONFULLNAME,
    SEARCHTERM1,
    SEARCHTERM2,
    PRIMARY KEY (BPCOUNTERPARTY, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCEOBJECT, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSTEP)
);

Learn More