BUSINESSPARTNER

65 Fields

BUSINESSPARTNER is an SAP database table in S/4HANA. It contains 65 fields.

Fields (65)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner,TransportationVehicleDriver 11
KEY CompanyCode CompanyCode 3
KEY Customer Customer 2
KEY FiscalYear FiscalYear 1
KEY Ledger Ledger 1
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDChgProcessSrceObject MDChgProcessSrceObject 1
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 1
KEY MDChgProcessStep MDChgProcessStep 1
KEY OffsettingAccount OffsettingAccount 2
KEY OffsettingAccountType OffsettingAccountType 2
KEY Supplier Supplier 2
_CompanyCode _CompanyCode 1
_FiscalYear _FiscalYear 1
_Ledger _Ledger 1
AcademicTitle2 AcademicTitle2 2
ActiveCountry ActiveCountry 1
AdditionalLastName AdditionalLastName 3
AuthorizationGroup AuthorizationGroup 6
BirthDate BirthDate 2
BPTaxNumber BPTaxNumber 1
BPTaxType BPTaxType 1
BusinessPartnerCategory BusinessPartnerCategory 5
BusinessPartnerFullName BusinessPartnerFullName,FullName 6
BusinessPartnerIDByExtSystem BusinessPartnerIDByExtSystem 2
BusinessPartnerName BusinessPartnerName,TranspVehicleDriverName 12
BusinessPartnerNumber RiskPartnerNo 1
BusinessPartnerUUID BusinessPartnerUUID 3
CityName CityName 4
CityNumber CityNumber 2
CO_DIANCountry CO_DIANCountry 3
Country Country 5
CountryThreeLetterISOCode CountryThreeLetterISOCode 1
DataController1 DataController1 8
DataController10 DataController10 8
DataController2 DataController2 8
DataController3 DataController3 8
DataController4 DataController4 8
DataController5 DataController5 8
DataController6 DataController6 8
DataController7 DataController7 8
DataController8 DataController8 8
DataController9 DataController9 8
DataControllerSet DataControllerSet 8
FirstName FirstName 7
FormOfAddress FormOfAddress 1
FormOfAddressName FormOfAddressName 1
IndependentAddressID IndependentAddressID 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 8
IsNaturalPerson IsNaturalPerson 4
IsOneTimeAccount IsOneTimeAccount 5
LastName LastName 7
MiddleName MiddleName 3
OrganizationBPName1 OrganizationBPName1 5
OrganizationBPName2 OrganizationBPName2 5
OrganizationBPName3 OrganizationBPName3 4
OrganizationBPName4 OrganizationBPName4 4
partner BusinessPartner 2
PersonNumber PersonNumber 1
Region Region 4
StreetName StreetName 4
TaxNumber1 TaxNumber1 1
TaxNumberResponsible TaxNumberResponsible 1
TaxNumberType TaxNumberType 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 BUSINESSPARTNER (
    BUSINESSPARTNER,
    COMPANYCODE,
    CUSTOMER,
    FISCALYEAR,
    LEDGER,
    MASTERDATACHANGEPROCESS,
    MDCHGPROCESSSRCEOBJECT,
    MDCHGPROCESSSRCESYSTEM,
    MDCHGPROCESSSTEP,
    OFFSETTINGACCOUNT,
    OFFSETTINGACCOUNTTYPE,
    SUPPLIER,
    _COMPANYCODE,
    _FISCALYEAR,
    _LEDGER,
    ACADEMICTITLE2,
    ACTIVECOUNTRY,
    ADDITIONALLASTNAME,
    AUTHORIZATIONGROUP,
    BIRTHDATE,
    BPTAXNUMBER,
    BPTAXTYPE,
    BUSINESSPARTNERCATEGORY,
    BUSINESSPARTNERFULLNAME,
    BUSINESSPARTNERIDBYEXTSYSTEM,
    BUSINESSPARTNERNAME,
    BUSINESSPARTNERNUMBER,
    BUSINESSPARTNERUUID,
    CITYNAME,
    CITYNUMBER,
    CO_DIANCOUNTRY,
    COUNTRY,
    COUNTRYTHREELETTERISOCODE,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    FIRSTNAME,
    FORMOFADDRESS,
    FORMOFADDRESSNAME,
    INDEPENDENTADDRESSID,
    ISBUSINESSPURPOSECOMPLETED,
    ISNATURALPERSON,
    ISONETIMEACCOUNT,
    LASTNAME,
    MIDDLENAME,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    ORGANIZATIONBPNAME3,
    ORGANIZATIONBPNAME4,
    PARTNER,
    PERSONNUMBER,
    REGION,
    STREETNAME,
    TAXNUMBER1,
    TAXNUMBERRESPONSIBLE,
    TAXNUMBERTYPE,
    XPCPT,
    PRIMARY KEY (BUSINESSPARTNER, COMPANYCODE, CUSTOMER, FISCALYEAR, LEDGER, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCEOBJECT, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSTEP, OFFSETTINGACCOUNT, OFFSETTINGACCOUNTTYPE, SUPPLIER)
);

Learn More