Top SAP © Table - list for the Business Partner BP, Module AP-MD-BP
View table content with transaction SE16, SE16N or SE16H (with HANA-Database) and tablestructure with SE11
Masterdata
| Table | Table - name | S/4HANA -Table and general Notes | BP001 | FS-Specific Attributes; Organization | General financial services information for the organisation-BP, e.g. for the trading partner. | BUT000 | Business Partner: General data I | Field TYPE for the Business Partner category: 1 = Person, 2 = Organization, 3 = Group. In Logical Database REBP UKM_BUPA. | BUT001 | BP: General data II | BUT020 | Business Partner: Addresses | In Logical Database REBP. | BUT021 | BP: Address usages | Is no longer filled. Table BUT021_FS is used instead for the different time intervals. | BUT021_FS | Time-Dependent Address Usages | The valid fields have the UTC time stamp format. Use function module CIF_GEN3_CONVERT_TIMESTAMP to convert. | BUT030 | BP Where-Used List: Usages | BUT030T | BP Object Usage: Application Table, Texts | BUT050 | BP relationships/role definitions: General data | BUT050S | BP Relationships/Role Definitions: General Data | BUT051 | BP Relationship: Contact Person Relationship | BUT052 | BP Relationship: Addresses | BUT053 | BP Relationship: Company Interest | BUT0BK | BP: Bank Details | BUT0ID | BP: ID Numbers | BP Identifaction numbers. | BUT0IS | BP: Industries | BUT100 | Business Partner: Roles | In Logical Database REBP. | DFKKBPTAXNUM | Tax Numbers for Business Partner | VIBPOBJREL | Business Partner-Object Relationship | For RE-FX Objects |
Customer-Tables for the Customer-Vendor-Integration (CVI) With the roles FLCU00 and FLCU01
| Table | Table - name | S/4HANA -Table and general Notes | ABUSINESSPARTNER | Businesspartner | Only available in S/4. Shows supplier-, customer- and business-partner relationship. | CVI_CUST_LINK | Assignment Between Customer and Business Partner | Linked to table BUT000 via the field Partner_GUID. | IBUPACUSTOMER | View for the customer - business partner | Only available in S/4. | KNA1 | General Data in Customer Master | Also transaction S_ALR_87012179. In Logical Database BRF DDF SD_KUSTA VC1 VC2 VDF WTY. | KNAT | Customer Master Record (Tax Groupings) | KNB1 | Customer Master (Company Code) | In Logical Database BRF DDF VDF. | KNB5 | Customer master (dunning data) | In Logical Database BRF DDF. | KNBK | Customer Master (Bank Details) | In Logical Database BRF DDF. | KNBW | Customer master record (withholding tax types) X | KNEX | Customer Master: Legal Control - Sanctioned Party List | KNKK | Customer master credit management: Control area data | In Logical Database BRF DDF. | KNVA | Customer Master Unloading Points | KNVI | Customer Master Tax Indicator | KNVP | Customer Master Partner Functions | In Logical Database SD_KUSTA VC2. | KNVV | Customer Master Sales Data | In Logical Database SD_KUSTA VC1 VC2. | TIBAN | IBAN | In Logical Database IBAN. |
Vendor-Tables for the Customer-Vendor-Integration (CVI) With the roles FLVN00 and FLVN01
| Table | Table - name | S/4HANA -Table and general Notes | ABUSINESSPARTNER | Businesspartner | Only available in S/4. Shows supplier-, customer- and business-partner relationship. | CVI_VEND_LINK | Assignment Between Vendor and Business Partner | Linked to table BUT000 via the field Partner_GUID. | IBPSUPPLIER | View for the supplier - business partner | Only available in S/4. | LFA1 | Vendor Master (General Section) | Also transaction S_ALR_87012086. In Logical Database BRF KDF WTY. | LFAT | Vendor master record (tax groupings) | LFB1 | Vendor Master (Company Code) | In Logical Database BRF KDF. | LFB5 | Vendor master (dunning data) | LFBK | Vendor Master (Bank Details) | In Logical Database BRF KDF. | LFBW | Vendor master record (withholding tax types) X | LFM1 | Vendor master record purchasing organization data | TIBAN | IBAN | In Logical Database IBAN. | WYT3 | Partner Functions |
Addresses
| Table | Table - name | S/4HANA -Table and general Notes | ADCP | Person/Address Assignment (Business Address Services) | ADR12 | FTP and URL (Business Address Services) | Communication types and identifiers. | ADR2 | Telephone Numbers (Business Address Services) | ADR3 | Fax Numbers (Business Address Services) | ADR6 | E-Mail Addresses (Business Address Services) | ADRC | Addresses (Business Address Services) | In Logical Database OIRB_LOC REBP. | ADRCITY | Postal cities | ADRP | Persons (Business Address Services) | ADRT | Communication Data Text (Business Address Services) |
Customizing - Tables Areamenu-Transaction: BUPT
To go to the IMG customizing entry, enter the table name in transaction SM30, click on 'Customizing' and then on 'Continue w/o Specifying Project'.
| Table | Table - name | S/4HANA -Table and general Notes | NRIV | Number Range Intervals | Edit with transaction SNUM. For Business Partners the object name is = 'BU_PARTNER'. Maintain the Business Partner number intervals directly via transaction BUCF. | T008 | Blocking Reasons for Automatic Payment Transcations | T077D | Customer account groups | T077K | Supplier Account Groups | T077X | Account Group Names (Table T077D) | T077Y | Account Group Names (Table T077K) | TB001 | BP groupings | TB002 | BP grouping: Texts | TB003 | BP Roles | TB004 | BP types | Text and Translations are in table TB004T. | TB009 | BP address types | TB039A | BP ID Types | Text and Translations are in table TB093T. | TBZ3 | BDT Screen Sequences | TBZ3A | BDT Screens | TBZ3L | BDT-Screen Sequence Categories | TBZ3R | Assign BDT Field Group -> BDT Field | TFKTAXNUMTYPE | Tax Number Categories of Business Partner | Function Modules for the tax-format checks. | TPAR | Business Partner: Functions |
Report a missing table or a suggestion for improvement here...
Additional tables for the following modules at Erp-Top.com:
FI FI-GL FI-AR FI-AP FI-BL FI-AA CO CO-OM-CEL CO-OM-CCA CO-OM-OPA CO-PC EC-PCA RE-FX RE-FX-LA SD MM MM-PUR QM PM PP PP-PI PS PA Top Transaction - list for the Business Partner BP, Module AP-MD-BP
Masterdata
| Transaction | Transaction - Name | Notes | BP | Maintain Business Partner | Menu Extras Create/Change to see the BP grouping used for the Business Partner | BUPA_DEL | Deletion without Archiving | MDS_LINKS | Get the Mapped Cust/Vend/BP |
Information System and Reporting
| Transaction | Transaction - Name | Notes | BPB1 | Evaluation of Business Partner/Roles | BPB2 | Evaluation of Business Parter Data | BPB4 | Evaluation of Partner Relationships | BPCD | Business Partner: Change Documents | REISCNBP | IS: Business Partners of Contracts | TBI8 | Standing Instructions: Evaluations |
Customizing - Transactions Areamenu-Transaction: BUPT
| Transaction | Transaction - Name | Notes | BUCF | BP Cust: Number Ranges | For Business Partners the object name is = 'BU_PARTNER' | BUS23 | BP Tax: Data Sets | BUS3 | BDT: Views | XDN1 | Number Ranges (Customer) | XKN1 | Number Ranges (Vendor) |
