BUT000
BP: General data I
BUT000 is an SAP database table in S/4HANA. BP: General data I. It contains 112 fields. 95 CDS views read from this table.
CDS Views using this table (95)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /BOFU/CV_BP_AddressInformation | view | from | BOPF: /BOFU/BuPa Node Addressinformation | |
| /BOFU/CV_BP_AddressUsage | view | inner | BOPF: /BOFU/BuPa Node Address Usage | |
| /BOFU/CV_BPCommon | view | from | BOPF: /BOFU/BuPa Node Common | |
| /BOFU/CV_BPCurrentDefaultAddr | view | inner | BOPF: /BOFU/BuPa Current Default Address | |
| /BOFU/CV_BPIdentification | view | inner | BOPF: /BOFU/BuPa Node Identification | |
| /BOFU/CV_BPRelationship | view | inner | BOPF: /BOFU/BuPa Node Relationship | |
| /BOFU/CV_BPRelshpContactPerson | view | inner | BOPF: /BOFU/BuPa Node Relshp Cntct Persn | |
| /BOFU/CV_BPRoleValidity | view | inner | BOPF: Help View for /BOFU/BuPa Node Role | |
| /BOFU/CV_BPRoot | view | from | BOPF: /BOFU/BuPa Node Root | |
| /BOFU/CV_BPTax | view | inner | BOPF: /BOFU/BuPa Node Tax | |
| /BOFU/CV_Q_BPNamesKeywords | view | from | BOPF: Root Query on Names and Keywords | |
| /dmbe/i_Shipto_With_Admin_Data | view | from | Ship To View Contaning Admin Data | |
| /dmbe/i_Shipto_With_Admin_Data | view | inner | Ship To View Contaning Admin Data | |
| /dmbe/i_Shipto_Without_Adm_Dat | view | from | Ship To View With Empty Admin Data | |
| /dmbe/i_Shipto_Without_Adm_Dat | view | inner | Ship To View With Empty Admin Data | |
| C_BankBusinessPartnerVH | view | inner | CONSUMPTION | Value Help for Bank Business Partner |
| C_BankGroupRootNodeValueHelp | view_entity | inner | CONSUMPTION | Bank Group |
| CRMS4_IU_C_CONBP | view | inner | Connection object by business partner | |
| CRMS4_IU_C_CONVAR | view_entity | left_outer | Connection Object by Various Fields | |
| CRMS4_IU_C_PODBP | view | inner | Point of Delivery by Business Partner | |
| E_BP_D | view | from | EXTENSION | Extensibility BP Core |
| Fclm_Bm_BP | view | inner | Bussiness Parterner for bank management | |
| Fclm_Bm_Contacts | view | inner | Contact person for bank | |
| Fclm_Bm_Used_Bp_Adr | view | inner | Used business partner address for banks | |
| FNDEI_BUT000_BlockingInfo | view | from | Blocking Infor View for table BUT000 | |
| FNDEI_BUT000_FILTER | view | from | Filter View for table BUT000 | |
| I_ACMBusPartData | view | from | BASIC | Business Partner data |
| I_ACMBusPartValues | view | inner | COMPOSITE | Business Partner Values |
| I_ACMOptnSourceLocVH | view | from | BASIC | Value Help for Option Souce Location |
| I_ACMTradeOffice | view | from | BASIC | Interface for Trade Office |
| I_BankHierBankGroupMapping | view | left_outer | BASIC | Bank Hierarchy Bank Group Name Mapping |
| I_BankUsedBP | view | inner | COMPOSITE | Used business partner for banks |
| I_BhvrlInsgtsCustomer | view | from | BASIC | Customer Data for BEI |
| I_BhvrlInsgtsCustomerWithRole | view | from | BASIC | Customers with role for BEI |
| I_BPBankLinkage | view | inner | BASIC | Linkage between BP and Bank |
| I_BPCntctPersnEmailAddrGov | view_entity | inner | TRANSACTIONAL | Base Union WplcAddr Email |
| I_BPContactPersonAddressGov | view_entity | inner | TRANSACTIONAL | Base Contact Person Workplace Address |
| I_BPContactPersonFaxNumberGov | view_entity | inner | TRANSACTIONAL | Base Union for Workplace Fax Number |
| I_BPContactPersonMblNumberGov | view_entity | inner | TRANSACTIONAL | Base Union for Workplace Mbl Number |
| I_BPContactPersonTelNumberGov | view_entity | inner | TRANSACTIONAL | Base Union for Workplace Tel Number |
| I_BPContactPersonWebsiteURLGov | view_entity | inner | TRANSACTIONAL | Base Union WplcAddr Websites |
| I_BpContactToAddress | view | inner | BASIC | Business Partner Contact To Address |
| I_BPReltdWithParentCompany | view | inner | BASIC | Business Partner Relationship for Parent company/subsidiary |
| I_BusinessPartAddress_2 | view | inner | COMPOSITE | Business Partner Address |
| I_BusinessPartner | view | from | BASIC | Business Partner |
| I_BusinessPartnerCustomer | view | left_outer | BASIC | Business Partner Customer |
| I_BusinessPartnerSupplier | view | left_outer | BASIC | Business Partner Supplier |
| I_BusinessUserBasic | view_entity | from | BASIC | Business User Basic |
| I_Employee | view | inner | BASIC | Employee |
| I_EmployeeOp | view | inner | BASIC | Employee CDS view for OP |
| I_HCMEmployeeAddressBook | view | inner | Employee Address Book | |
| I_IHBBankAreaOwner | view_entity | from | BASIC | IHB Bank Area Owner |
| I_IHBBusinessPartner | view_entity | from | BASIC | IHB Business Partner |
| I_MDGovBPFltr | view | from | COMPOSITE | MDG Business Partner Filter |
| I_WorkplaceAddress | view | inner | BASIC | Employee Workplace Address |
| ICM_BP_ADDR_INDP | view | from | BusinessPartner_Address_Indep | |
| ICM_EMPLOYEE_CONTACT | view | inner | Employee | |
| ICM_PARTNER_CONTACT | view | inner | BusinessPartner_contact | |
| ICM_PARTNER_ORGANIZATION | view | from | BusinessPartner_Organization | |
| ICM_PARTNER_PERSON | view | from | BusinessPartner_person | |
| ISU_C4C_BP_V | view | from | CDS for Business partner name | |
| P_ALTERNATE_PAYEE | view | inner | BASIC | |
| P_Bpcontacts_Address | view | inner | BASIC | |
| P_Bpcontacts_Data | view | from | BASIC | |
| P_BPContactToAddress | view | inner | BP Contact person address | |
| P_BPUsrPerson | view | from | BASIC | Business User - Private View |
| P_BUPA_BPU_BP001 | view | inner | BASIC | |
| P_EmployeeCl | view | from | BASIC | |
| P_ISU_CSML_BUSPARTNERVH_BR | view | from | BASIC | |
| P_MDChgProcCustClAssgmtWthNmbr | view | from | BASIC | |
| P_MDChgProcCustClAssgmtWthNmbr | view | union | BASIC | |
| P_MDChgProcCustValnWthBusPart | view | union | BASIC | |
| P_MDChgProcCustValnWthBusPart | view | from | BASIC | |
| P_MDChgProcSuplrClAssmtWthNmbr | view | union | BASIC | |
| P_MDChgProcSuplrClAssmtWthNmbr | view | from | BASIC | |
| P_MDChgProcSuplrValnWthBusPart | view | from | BASIC | |
| P_MDChgProcSuplrValnWthBusPart | view | union | BASIC | |
| P_Supplierbp_Fs | view | left_outer | BASIC | |
| P_WFDKEYMAP | view | inner | BASIC | SDM View for WFD_D_KEYMAP |
| R_ACMBusPartValues | view | inner | BASIC | CDS view for Counterparty Type Values for BP |
| R_BPUsrRole | view_entity | from | COMPOSITE | Business User Role |
| SHSM_BUT00047 | view | from | ||
| SHSM_DFKKINVBILL_H | view | left_outer | nach Belegkopfdaten | |
| SHSM_DFKKPOH | view | left_outer | Ersatz für DFKKOP in Suchhilfe | |
| SHSM_FKK_CM_CPERS | view | from | Ersatz für FKK_CNTCT_PRSN in Suchhilfe | |
| SHSM_FKKBUT000 | view | from | Ersatz für BUT000 in Suchhilfe | |
| SHSM_M_EKUNP | view | from | Business Partner by Postal Code Search Help | |
| SHSM_V_BUT000 | view | from | Ersatz für V_BUT000 in Suchhilfe | |
| SHSM_V_BUT000_I | view | from | Ersatz für V_BUT000_I in Suchhilfe | |
| SHSM_V_EPROP | view | inner | Ownership by Owner Search Help | |
| SHSM_V_EVERG | view | inner | Business Partner for Contract Search Help | |
| VFCLM_BAM_DDL_BANK_HIER_BGN | view | left_outer | Bank Hierarchy Bank Group Name Mapping | |
| VFCLM_BAM_DDL_BPBNKALINK | view | inner | Linkage between BP and Bank | |
| VFCLM_BAM_DDL_BPREL_FSB002 | view | inner | Business Partner Relationship for FSB002 | |
| VFCLM_BAM_DDL_BPUSERFULLNAME | view | from | User name for Business Parnter |
Fields (112)
| Key | Field | Data Element | Description |
|---|---|---|---|
| KEY | client | MANDT | |
| KEY | partner | BU_PARTNER | |
| type | BU_TYPE | ||
| bpkind | BU_BPKIND | ||
| bu_group | BU_GROUP | ||
| bpext | BU_BPEXT | ||
| bu_sort1 | BU_SORT1 | ||
| bu_sort2 | BU_SORT2 | ||
| source | BU_SOURCE | ||
| title | AD_TITLE | ||
| xdele | BU_XDELE | ||
| xblck | BU_XBLCK | ||
| augrp | BU_AUGRP | ||
| title_let | BU_TITLE_LET | ||
| bu_logsys | LOGSYS | ||
| contact | BU_CONTACT | ||
| not_released | BU_XNOT_RELEASED | ||
| not_lg_competent | BU_NOT_LEG_COMPETENT | ||
| print_mode | BU_PRINT_MODE | ||
| bp_eew_dummy | DUMMY | ||
| rate | DPR_TV_RATE | ||
| name_org1 | BU_NAMEOR1 | ||
| name_org2 | BU_NAMEOR2 | ||
| name_org3 | BU_NAMEOR3 | ||
| name_org4 | BU_NAMEOR4 | ||
| legal_enty | BU_LEGENTY | ||
| ind_sector | BU_INDSECT | ||
| legal_org | BU_LEGAL_ORG | ||
| dc_not_req | BU_DC_NOT_REQ | ||
| found_dat | BU_FOUND_DAT | ||
| liquid_dat | BU_LIQUID_DAT | ||
| location_1 | BBBNR | ||
| location_2 | BBSNR | ||
| location_3 | BUBKZ | ||
| name_last | BU_NAMEP_L | ||
| name_first | BU_NAMEP_F | ||
| name_lst2 | BU_NAMEPL2 | ||
| name_last2 | BU_BIRTHNM | ||
| namemiddle | BU_NAMEMID | ||
| title_aca1 | AD_TITLE1 | ||
| title_aca2 | AD_TITLE2 | ||
| title_royl | AD_TITLES | ||
| prefix1 | AD_PREFIX | ||
| prefix2 | AD_PREFIX2 | ||
| name1_text | BU_NAME1TX | ||
| nickname | BU_NICKNAM | ||
| initials | AD_INITS | ||
| nameformat | AD_FORMAT | ||
| namcountry | AD_NAMCTRY | ||
| langu_corr | BU_LANGU_CORR | ||
| xsexm | BU_XSEXM | ||
| xsexf | BU_XSEXF | ||
| birthpl | BU_BIRTHPL | ||
| marst | BU_MARST | ||
| emplo | BU_EMPLO | ||
| jobgr | BU_JOBGR | ||
| natio | BU_NATIO | ||
| cntax | BU_CNTAX | ||
| cndsc | BU_CNDSC | ||
| persnumber | AD_PERSNUM | ||
| xsexu | BU_XSEXU | ||
| xubname | BU_XUBNAME | ||
| bu_langu | BU_LANGU | ||
| gender | BU_SEXID | ||
| birthdt | BU_BIRTHDT | ||
| deathdt | BU_DEATHDT | ||
| perno | BU_PERNO | ||
| children | BU_CHILDREN | ||
| mem_house | BU_MEM_HOUSE | ||
| birthdt_status | BU_BIRTHDT_STATUS | ||
| partgrptyp | BU_GRPTYP | ||
| name_grp1 | BU_NAMEGR1 | ||
| name_grp2 | BU_NAMEGR2 | ||
| mc_name1 | BU_MCNAME1 | ||
| mc_name2 | BU_MCNAME2 | ||
| crusr | BU_CRUSR | ||
| crdat | BU_CRDAT | ||
| crtim | BU_CRTIM | ||
| chusr | BU_CHUSR | ||
| chdat | BU_CHDAT | ||
| chtim | BU_CHTIM | ||
| partner_guid | BU_PARTNER_GUID | ||
| addrcomm | BU_ADDRCOMM | ||
| td_switch | BU_TD_SWITCH | ||
| is_org_centre | BU_IS_ORG_CENTRE | ||
| db_key | SYSUUID_X | ||
| valid_from | BU_BP_VALID_FROM | ||
| valid_to | BU_BP_VALID_TO | ||
| xpcpt | BU_XPCPT | ||
| data_ctrlr1 | BU_DATA_CONTROLLER | ||
| data_ctrlr2 | BU_DATA_CONTROLLER | ||
| data_ctrlr3 | BU_DATA_CONTROLLER | ||
| data_ctrlr4 | BU_DATA_CONTROLLER | ||
| data_ctrlr5 | BU_DATA_CONTROLLER | ||
| data_ctrlr6 | BU_DATA_CONTROLLER | ||
| data_ctrlr7 | BU_DATA_CONTROLLER | ||
| data_ctrlr8 | BU_DATA_CONTROLLER | ||
| data_ctrlr9 | BU_DATA_CONTROLLER | ||
| data_ctrlr10 | BU_DATA_CONTROLLER | ||
| xdcset | BU_XDCSET | ||
| bank_area | /PF1/DTE_IHB_BANK_AREA | ||
| credit_tax_code | /PF1/DTE_CREDIT_TAX_CODE | ||
| debit_tax_code | /PF1/DTE_DEBIT_TAX_CODE | ||
| credit_tax_type | /PF1/DTE_CREDIT_TAX_TYPE | ||
| debit_tax_type | /PF1/DTE_DEBIT_TAX_TYPE | ||
| natpers | BU_NATURAL_PERSON | ||
| milve | MILVE | ||
| nuc_sec | NUC_SEC | ||
| par_rel | BP_PAR_REL | ||
| bp_sort | BP_SORT_PH | ||
| kbanks | BANKS | ||
| kbankl | BANKK |