BP

76 Fields

BP is an SAP database table in S/4HANA. It contains 76 fields.

Fields (76)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner,BusinessPartnerNumber 6
KEY BusinessPartnerId BusinessPartnerId,PersonID 2
KEY BusinessPartnerRole BusinessPartnerRole 1
KEY BusinessPartnerUUID BusinessPartnerUUID 2
KEY CompanyCode CompanyCode 1
KEY Product Product 1
AddressPhoneNumber AddressPhoneNumber 1
augrp AuthorizationGroup 2
AuthorizationGroup AuthorizationGroup 3
BusinessPartnerBirthName BirthName 1
BusinessPartnerFullName BusinessPartnerFullName 1
BusinessPartnerName BusinessPartnerName 3
BusinessPartnerRoleShortName BusinessPartnerRoleShortName 1
chdat LastChangeDate 2
chtim LastChangeTime 2
chusr LastChangedByUser 2
CityName CityName 1
CompanyName CompanyName 1
CorrespondenceLanguage NativePreferredLanguage 1
Country Country 2
crdat CreationDate 2
crtim CreationTime 2
crusr CreatedByUser 2
Customer Customer 2
DataController1 DataController1 2
DataController10 DataController10 2
DataController2 DataController2 2
DataController3 DataController3 2
DataController4 DataController4 2
DataController5 DataController5 2
DataController6 DataController6 2
DataController7 DataController7 2
DataController8 DataController8 2
DataController9 DataController9 2
DataControllerSet DataControllerSet 2
EmailAddress EmailAddress 2
FinancialAccountType FinancialAccountType 2
FirstName FirstName 3
FullName FullName 1
Initials Initials 3
InvoiceReference InvoiceReference 2
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear 2
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 4
langu_corr CorrespondenceLanguage 2
LastName LastName 3
LastNamePrefix LastNamePrefix 1
LglCntntMEntityType LglCntntMEntityType 1
LglCntntMEntityTypeName LglCntntMEntityTypeName 1
mc_name1 LastName 2
mc_name2 BusinessPartnerName 2
MiddleName MiddleName 1
name_first FirstName,GivenName,name_first 6
name_last FamilyName,name_last 6
name_lst2 AdditionalFamilyName 2
name1_text EmployeeFullName,FullName 2
namemiddle MiddleName 2
OrganizationBPName1 OrganizationBPName1 3
OrganizationBPName2 OrganizationBPName2 3
partner EmployeeInternalID 2
partner_guid BusinessPartnerUUID 2
persnumber Person 2
PersonFullName PersonFullName 1
PhoneNumber PhoneNumber 1
PostalCode PostalCode 1
prefix1 FamilyNamePrefix 2
ProductDescription ProductDescription 1
Region Region 1
StreetName StreetName 1
Supplier Supplier 2
title FormOfAddress 2
title_aca1 AcademicTitle 2
type BusinessPartnerCategory,BusinessPartnerType 3
VATRegistration VATRegistration 2
WebAddress WebAddress 1
xdele IsMarkedForArchiving 1
xpcpt IsBusinessPurposeCompleted 2

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 (
    BUSINESSPARTNER,
    BUSINESSPARTNERID,
    BUSINESSPARTNERROLE,
    BUSINESSPARTNERUUID,
    COMPANYCODE,
    PRODUCT,
    ADDRESSPHONENUMBER,
    AUGRP,
    AUTHORIZATIONGROUP,
    BUSINESSPARTNERBIRTHNAME,
    BUSINESSPARTNERFULLNAME,
    BUSINESSPARTNERNAME,
    BUSINESSPARTNERROLESHORTNAME,
    CHDAT,
    CHTIM,
    CHUSR,
    CITYNAME,
    COMPANYNAME,
    CORRESPONDENCELANGUAGE,
    COUNTRY,
    CRDAT,
    CRTIM,
    CRUSR,
    CUSTOMER,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    EMAILADDRESS,
    FINANCIALACCOUNTTYPE,
    FIRSTNAME,
    FULLNAME,
    INITIALS,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    ISBUSINESSPURPOSECOMPLETED,
    LANGU_CORR,
    LASTNAME,
    LASTNAMEPREFIX,
    LGLCNTNTMENTITYTYPE,
    LGLCNTNTMENTITYTYPENAME,
    MC_NAME1,
    MC_NAME2,
    MIDDLENAME,
    NAME_FIRST,
    NAME_LAST,
    NAME_LST2,
    NAME1_TEXT,
    NAMEMIDDLE,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    PARTNER,
    PARTNER_GUID,
    PERSNUMBER,
    PERSONFULLNAME,
    PHONENUMBER,
    POSTALCODE,
    PREFIX1,
    PRODUCTDESCRIPTION,
    REGION,
    STREETNAME,
    SUPPLIER,
    TITLE,
    TITLE_ACA1,
    TYPE,
    VATREGISTRATION,
    WEBADDRESS,
    XDELE,
    XPCPT,
    PRIMARY KEY (BUSINESSPARTNER, BUSINESSPARTNERID, BUSINESSPARTNERROLE, BUSINESSPARTNERUUID, COMPANYCODE, PRODUCT)
);

Learn More