S401 is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of S401 in SAP.
- Table description : RE standard analysis partner
- Module : CRM
- Parent Module : CRM
- Package : FVVI
- Software Component : BBPCRM
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP S401 Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| SSOUR | Statistic(s) origin | SSOUR | SSOUR |
| VRSIO | Version number in the information structure | VRSIO | VRSIO |
| SPMON | Period to analyze - month | SPMON | MCPERIOD |
| SPTAG | Period to analyze - current date | SPTAG | DATUM |
| SPWOC | Period to analyze - week | SPWOC | MCPERIOD |
| SPBUP | Period to analyze - posting period | SPBUP | MCPERIOD |
| PARTNR_01 | Business Partner Number | BP_PARTNR | BP_PARTNR |
| ROLE_02 | Business Partner Role Type | BP_ROLE | BP_ROLE |
| VWDAT | Pointer to administrative data | VWDAT | VWDAT |
| .INCLUDE | RE standard analysis partner | ||
| PARTNR | Business Partner Number | BP_PARTNR | BP_PARTNR |
| ROLE | Business Partner Role Type | BP_ROLE | BP_ROLE |
| BUKRS | Company Code | BUKRS | BUKRS |
| SWENR | Business Entity Number | SWENR | SWENR |
| SGRNR | Land Number for BE | SGRNR | SGRNR |
| SGENR | Building Number | SGENR | SGENR |
| SMENR | Number of Rental Unit | SMENR | SMENR |
| SMIVE | Lease-Out Number | SMIVE | VVSMIVE |
| E_SMIVE | Contract No. of Collective Lease-Outs | VVESMIVE | VVSMIVE |
| XWETEXT | Business entity identification | XWETEXT | XMBEZ |
| XGRTXT | Text for property | XGRTXT | XLBEZ |
| XGETXT | Building text | XGETXT | XLBEZ |
| XMETXT | Text for rental unit | VVXMETXT | XMBEZ |
| KUNNR | Customer Number | KUNNR | KUNNR |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | LIFNR |
| TYPE | Partner category | BP_TYPE | BP_TYPE |
| GROUP_ID | Business Partner Grouping | BP_GRP_ID | BP_GRP_ID |
| NAME1 | Name 1 (surname for persons, otherwise company name) | BP_NAME1 | TEXT40 |
| NAME2 | Name 2 (Continuation of NAME 1) | BP_NAME2 | TEXT40 |
| NAME_LAST | Last Name | BP_NAMLAST | TEXT40 |
| NAME_FIRST | First Name | BP_NAMFRST | TEXT40 |
| LANGU | Language Key | LANGU | SPRAS |
| TITLE | Form of Address (Key) | BP_TITLE | BP_TITLE |
| TITLE_LET | Salutation | BP_TITL_LT | BP_TITL_LT |
| XORT | Address: City | VVXORT | TEXT35 |
| XPLZ | Address: Postal code | VVXPLZ | PSTLZ |
| XSTRASSE | Address: Street/house number | VVXSTRASSE | TEXT35 |
| ANZPT | No. of partners | VVAPT | DEC5 |
| TITLE_AC | Academic Title | BP_TITL_AC | TEXT20 |
| N_PREFIX | Name Prefix | BP_PREFIX | TEXT20 |
| N_ADDITION | Name Affix | BP_ADDITN | TEXT20 |
| NICKNAME | Known As | BP_NICKNAM | TEXT20 |
| SEX | Gender of business partner | BP_SEX | BP_SEX |
| PROFESSION | Description of Occupation for Business Partner | BP_PROFESS | TEXT40 |
| NATION | Nationality | BP_CNTR_N | LAND1 |
| STATE | Citizenship | BP_CNTR_ST | LAND1 |
| PERS_NR | Personnel Number | BP_PERS_NR | CHAR15 |
| STAFF_GRP | Employee Group | BP_STAFF_G | BP_STAFF_G |
| HR_ORG_REF | HR Org. Link | HR_ORG_REF | XFELD |
| XUBNAME | User Name in User Master Record | XUBNAME | XUBNAME |
| STAFF_REF | Employee | BP_STAFF_R | XFELD |
| ADR_REF_K | Address ID | BP_ADR_REF | BP_ADR_REF |
| ADR_DAT | Business partner address relationship valid from | BP_ADR_DAT | DATUM |
| ADRNR | Address Number | BP_ADRNR | SADRNR |
| ADR_D_E | Business Partner Address Relationship Valid Until | BP_ADR_D_E | DATUM |
| ADR_LOC | Partner: Building | VV_ADR_LOC2 | CHAR20 |
| FLOOR | Partner: Storey | VV_FLOOR | CHAR10 |
| ROOM_NR | Partner: Room number | VV_ROOM_NR | CHAR10 |
| XOBJTXT | Text for Real Estate object | VVXOBJTXT | XMBEZ |
| DBEBEZ | Date of start of relationship | DBEBEZ | DATUM |
| DENBEZ | Date of end of relationship | DENBEZ | DATUM |
| ROLETYP | Business Partner Role Category | BP_ROLETYP | BP_ROLETYP |
| LAND1 | Country Key | LAND1 | LAND1 |
| XORT2 | District | ORT02_GP | TEXT35 |
| PSTBZ | Post delivery district | PSTBZ | PSTBZ |
| REGIO | Region (State, Province, County) | REGIO | REGIO |
| XSTRASSE2 | House number and street | STRAS_GP | TEXT35 |
S401 related tables
| Table | Note |
|---|---|
| S401 | RE standard analysis partner |
| CACS_STAGASS | Link of Standard Agreements to Standard Contracts |
| TCACS_STDCNTXT | Standard Contract: Context of Standard Contract Object |
| TMC9 | Standard Drill-Down in Standard Analyses |
| TMCEX | Non-Displayable Key Figures per Standard Analysis |
| ARDB_STA3T | Table Analysis: Analysis Variant - Description |
| ARDB_STA3TN | Table Analysis: Analysis Variant - Description (with TADIR) |
| ARDB_STAT3 | Table Analysis: Analysis Variants |
| ARDB_STAT3N | Table Analysis: Analysis Variant (with TADIR Connection) |
| ARDB_STAT4 | Table Analysis: Virtual Fields for Analysis Variants |
| BAMGROUPS | Application Analysis: Analysis Groups |
| BAMGROUPST | Application Analysis: Analysis Group Descriptions |
| CNVA_CCD_ANA_ACT | Active Analysis ID for CC Delete Analysis Package |
| CRMC_TSS_PROC | TSS Analysis: Customizing for Analysis Process Identifier |
| CRMC_TSS_PROCT | TSS Analysis: Customizing for Analysis Process Identifier |
Business partner standard address TablesSap business partner standard address TablesResults analysis key TablesResults analysis TablesAnalysis authorization TablesCharacteristics profitability analysis TablesAssignment of analysis structure to client TablesNumber of periods for trend analysis Tables
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP