- Accounting - General (AC)
- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Business intelligence solutions (BI)
- Collaborative Cross Applications (XAP)
- Controlling (CO)
- Cross-Application Components (CA)
- Archiving (CA-ARC)
- Asset Retirement Obligation Management for Oil & Gas (CA-ARO)
- Available to Promise (ATP) (CA-ATP)
- Bank (CA-BK)
- Business Framework Architecture (CA-BFA)
- CA-VCM: Value Chain Management (CA-VCM)
- CAD Integration (CA-CAD)
- Classification (CA-CL)
- Commercial Project Management (CA-CPD)
- Cross Application Field Length Extension (CA-FLE)
- Cross functional developments in Asset Intell. N/W (CA-AIN)
- Cross-Application Objects in HR (CA-HR)
- Data Transformation (CA-DT)
- Digital Signature (CA-DSG)
- Document Management System (CA-DMS)
- Employee Self-Service (CA-ESS)
- Enterprise SOA (CA-SOA)
- European Monetary Union: Euro (CA-EUR)
- Field Logistics (CA-FL)
- Financial Mathematics/Conditions (CA-FIM)
- Financial Services (CA-FS)
- General Application Functions (CA-GTF)
- Global Organization Customizing (CA-CUS)
- IDoc Interfaces for EDI (CA-EDI)
- Integration from S/4HC to Master Data for Worker (CA-WFD)
- Issue & Activity Management (CA-IAM)
- Joint Venture und Production Sharing Accounting (CA-JVA)
- Landscape Transformation (CA-LT)
- Machine Learning (CA-ML)
- Manager Self-service (CA-MSS)
- Master Data Governance. (CA-MDG)
- Analysis and Remediation of Data Quality. (CA-MDG-ADQ)
- Analytics and Reporting (CA-MDG-ANR)
- Application Framework (CA-MDG-AF)
- Applications. (CA-MDG-APP)
- Consolidation & Mass Processing. (CA-MDG-CMP)
- Data Quality (CA-MDG-DQ)
- Data Replication Framework. (CA-MDG-DRF)
- Hierarchy Processing. (CA-MDG-HP)
- Key Mapping. (CA-MDG-KM)
- Mass Load. (CA-MDG-ML)
- Replication Interface Framework. (CA-MDG-RIF)
- Transport Registry. (CA-MDG-TRR)
- Value Mapping. (CA-MDG-VM)
- Master Data Integration Services (CA-MDI)
- Notifications (Support Feedback) (CA-NO)
- Open Information Warehouse (CA-OIW)
- PLM Audit Management (CA-AUD)
- Prepayment agreements (CA-PPA)
- Processes and Tools for Enterprise Applications (CA-EPT)
- Production Volume Capture (CA-PVL)
- Resource Scheduling (CA-RSH)
- SAP UI development toolkit for HTML5 - Rendering library (CA-UI5)
- SAP UI for Decoupled Innovations (CA-UI2)
- SAP Visual Enterprise (CA-VE)
- Situation handling across applications, generic (CA-SIT)
- Test Automation Tool for S/4HANA Cloud (CA-CTT)
- Time Sheet (CA-TS)
- Web Survey (CA-SUR)
- WebClient UI (CA-WUI)
- Cross-Application Components (CA)
- Archiving (CA-ARC)
- Asset Retirement Obligation Management for Oil & Gas (CA-ARO)
- Available to Promise (ATP) (CA-ATP)
- Bank (CA-BK)
- Business Framework Architecture (CA-BFA)
- CA-VCM: Value Chain Management (CA-VCM)
- CAD Integration (CA-CAD)
- Classification (CA-CL)
- Commercial Project Management (CA-CPD)
- Cross Application Field Length Extension (CA-FLE)
- Cross functional developments in Asset Intell. N/W (CA-AIN)
- Cross-Application Objects in HR (CA-HR)
- Data Transformation (CA-DT)
- Digital Signature (CA-DSG)
- Document Management System (CA-DMS)
- Employee Self-Service (CA-ESS)
- Enterprise SOA (CA-SOA)
- European Monetary Union: Euro (CA-EUR)
- Field Logistics (CA-FL)
- Financial Mathematics/Conditions (CA-FIM)
- Financial Services (CA-FS)
- General Application Functions (CA-GTF)
- Global Organization Customizing (CA-CUS)
- IDoc Interfaces for EDI (CA-EDI)
- Integration from S/4HC to Master Data for Worker (CA-WFD)
- Issue & Activity Management (CA-IAM)
- Joint Venture und Production Sharing Accounting (CA-JVA)
- Landscape Transformation (CA-LT)
- Machine Learning (CA-ML)
- Manager Self-service (CA-MSS)
- Master Data Governance. (CA-MDG)
- Analysis and Remediation of Data Quality. (CA-MDG-ADQ)
- Analytics and Reporting (CA-MDG-ANR)
- Application Framework (CA-MDG-AF)
- Applications. (CA-MDG-APP)
- Consolidation & Mass Processing. (CA-MDG-CMP)
- Data Quality (CA-MDG-DQ)
- Data Replication Framework. (CA-MDG-DRF)
- Hierarchy Processing. (CA-MDG-HP)
- Key Mapping. (CA-MDG-KM)
- Mass Load. (CA-MDG-ML)
- Replication Interface Framework. (CA-MDG-RIF)
- Transport Registry. (CA-MDG-TRR)
- Value Mapping. (CA-MDG-VM)
- Master Data Integration Services (CA-MDI)
- Notifications (Support Feedback) (CA-NO)
- Open Information Warehouse (CA-OIW)
- PLM Audit Management (CA-AUD)
- Prepayment agreements (CA-PPA)
- Processes and Tools for Enterprise Applications (CA-EPT)
- Production Volume Capture (CA-PVL)
- Resource Scheduling (CA-RSH)
- SAP UI development toolkit for HTML5 - Rendering library (CA-UI5)
- SAP UI for Decoupled Innovations (CA-UI2)
- SAP Visual Enterprise (CA-VE)
- Situation handling across applications, generic (CA-SIT)
- Test Automation Tool for S/4HANA Cloud (CA-CTT)
- Time Sheet (CA-TS)
- Web Survey (CA-SUR)
- WebClient UI (CA-WUI)
- Customer Relationship Management (CRM)
- Customer Service (CS)
- Discrete Industries (DI)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise Performance Management (EPM)
- Enterprise Portal (EP)
- Enterprise Portal (EP)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Financials (FIN)
- Global Trade Services (SLL)
- Governance, Risk and Compliance (GRC)
- Incentive and Commission Management (ICM) (ICM)
- Investment Management (IM)
- Knowledge Management (KM)
- LOD Components (LOD)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Obsolete Product: mySAP.com Workplace (WP)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Personnel Time Management (PT)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP HANA (HAN)
- SAP NetWeaver Master Data Management (MDM)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Training and Event Management (PE)
- Transportation Management (TM)
- Treasury (TR)
- Web Channel (WEC)
BUT000_ACT
Master Data Consolidation: Best Record Table for BUT000
|
#masterdata
|
Component: Business Partner.
- 🔑 Keys (2)
- 💰 Amounts
- ∑ Quantities
- 📅 Dates (8)
- ☰ Categorical (14)
- Other (43)
- 🔗 Relations (25)
| Column Name | Description | |
|---|---|---|
| CLIENT | Client | |
| PARTNER | Business Partner Number |
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| FOUND_DAT | Date organization founded | |
| LIQUID_DAT | Liquidation date of organization | |
| BIRTHDT | Date of Birth of Business Partner | |
| DEATHDT | Date of death of business partner | |
| CRDAT | Date on which the object was created | |
| CRTIM | Time at which the object was created | |
| CHDAT | Date when object was last changed | |
| CHTIM | Time at which object was last changed |
| Column Name | Description | |
|---|---|---|
| TYPE | Business Partner Category | Show values |
| XDELE | Central Archiving Flag | Show values |
| XBLCK | Central Block for Business Partner | Show values |
| CONTACT | Business Partner: Contact Permission | Show values |
| NOT_RELEASED | Indicator: Not Released | Show values |
| NOT_LG_COMPETENT | Indicator: Not Legally Competent | Show values |
| PRINT_MODE | Business Partner Print Format | Show values |
| XSEXM | Selection: Business partner is male | Show values |
| XSEXF | Selection: Business partner is female | Show values |
| XSEXU | Selection: Sex of business partner is not known | Show values |
| BIRTHDT_STATUS | Date of Birth: Status | Show values |
| IS_ORG_CENTRE | Indicator: Business Partner Is Also an Organizational Center | Show values |
| XPCPT | Business Purpose Completed Flag | Show values |
| NATPERS | Business Partner Is a Natural Person Under the Tax Laws | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| BPEXT | Business Partner Number in External System | CHAR20 | |
| BU_SORT1 | Search Term 1 for Business Partner | BU_SORT1 | |
| BU_SORT2 | Search Term 2 for Business Partner | BU_SORT1 | |
| AUGRP | Authorization Group | BU_AUGRP | |
| TITLE_LET | Salutation | TEXT50 | |
| BP_EEW_DUMMY | Dummy function in length 1 | DUMMY | |
| NAME_ORG1 | Name 1 of organization | BU_NAME | |
| NAME_ORG2 | Name 2 of organization | BU_NAME | |
| NAME_ORG3 | Name 3 of organization | BU_NAME | |
| NAME_ORG4 | Name 4 of organization | BU_NAME | |
| LOCATION_1 | International location number (part 1) | NUM07 | |
| LOCATION_2 | International location number (Part 2) | NUM05 | |
| LOCATION_3 | Check digit for the international location number | NUM01 | |
| NAME_LAST | Last name of business partner (person) | BU_NAME | |
| NAME_FIRST | First name of business partner (person) | BU_NAME | |
| NAME_LST2 | Other Last Name of a Person | BU_NAME | |
| NAME_LAST2 | Name at birth of business partner | BU_NAME | |
| NAMEMIDDLE | Middle name or second forename of a person | BU_NAME | |
| NAME1_TEXT | Full Name | TEXT80 | |
| NICKNAME | Nickname of Business Partner (Person) | BU_NAME | |
| INITIALS | "Middle Initial" or personal initials | CHAR10 | |
| BIRTHPL | Birthplace of business partner | TEXT40 | |
| EMPLO | Name of Employer of a Natural Person | BU_EMPLO | |
| CNTAX | Obsolete Field | LAND1 | |
| PERSNUMBER | Person Number | AD_PERSNUM | |
| PERNO | Personnel Number | PERSONID | |
| CHILDREN | Obsolete Field | NUMC2 | |
| MEM_HOUSE | Obsolete Field | DEC2 | |
| NAME_GRP1 | Name 1 (group) | BU_NAME | |
| NAME_GRP2 | Name 2 (group) | BU_NAME | |
| MC_NAME1 | Search Help Field 1 (Name 1/Last Name) | CHAR35 | |
| MC_NAME2 | Search Help Field 2 (Name 2/First Name) | CHAR35 | |
| CRUSR | User who created the object | USNAM | |
| CHUSR | Last user to change object | USNAM | |
| PARTNER_GUID | Business Partner GUID | SYSUUID | |
| ADDRCOMM | Address Number | AD_ADDRNUM | |
| TD_SWITCH | Planned Change Documents for Partner Were Converted | CHAR1 | |
| DB_KEY | UUID in X form (binary) | SYSUUID | |
| VALID_FROM | Validity Start BUT000 BP Data | TZNTSTMPS | |
| VALID_TO | Validity End BUT000 BP Data | TZNTSTMPS | |
| RECENCY | Master Data Consolidation: Recency | TZNTSTMPS | |
| FILTER | Master Data Change Process Source Filter | ||
| SOURCE_RECENCY | Master Data Consolidation: Recency | TZNTSTMPS |
| Master Data Relations | Join Conditions |
|---|---|
| Business Partner Type | |
| Business Partner Grouping | |
| Language | BUT000_ACT.BU_LANGU == T002.SPRAS |
| Logical system | BUT000_ACT.BU_LOGSYS == TBDLS.LOGSYS |
Country/Region of Origin: Non-Resident Companies
| |
| Sex of business partner (person) | BUT000_ACT.GENDER == TB995.GENDER |
| Occupation/group | |
| Correspondence Language | BUT000_ACT.LANGU_CORR == T002.SPRAS |
BP: Legal form of organization
| |
| Legal Entity of Organization | |
| Marital Status of Business Partner | |
Country/Region for Name Format Rule
| |
Nationality
| |
Group type
| |
Name Prefix (Key)
| |
2nd name prefix (key)
| |
| Cost Rate/Revenue Rate for Project Costing | |
Data Origin Types
| |
Form-of-Address Key
| |
| Academic Title: Key | |
| Second academic title (key) | |
| Name supplement, e.g. noble title (key) | |
| Obsolete Field |
| Other Relations | to Master Data Relations ↑ | Join Conditions |
|---|---|
Name format
|