SAP AFWCH_STR_SP_N Sample Customizing Table
Overview
AFWCH_STR_SP_N is a standard SAP S/4HANA table that stores Sample Customizing data. There are total 22 fields in the AFWCH_STR_SP_N table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AFWCH_STR_SP_N belongs to Analyzer (FIN-FSCM-TRM-AN) module and is located in the package RDB: Analyzer Characteristic Management (CFM_AFWCH).
In addition, following links provide an overview of foreign key relationships, if any, that link AFWCH_STR_SP_N to other SAP tables and standard CDS views available based on AFWCH_STR_SP_N table in S/4HANA 2020.
Techincal Settings of AFWCH_STR_SP_N
Below are technical details of the table AFWCH_STR_SP_N
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AFWCH_STR_SP_N Fields
The following table gives you an overview of the fields available in AFWCH_STR_SP_N
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| OBJNR | Object Number for Financial Transactions | JBOBJNR | ONR00 | CHAR | 22 |
| WYQ03S | Security Class ID Number | VVRANLW | VWPANLA | CHAR | 13 |
| WYQ04S | Securities Account | VRLDEPO | TWD01 | CHAR | 10 |
| WYQ05S | Contract Type | RANTYP | CHAR | 1 | |
| WYQ06S | Product Category | SANLF | TZAF | NUMC | 3 |
| WYQ07S | Product Type | VVSART | TZPA | CHAR | 3 |
| WYQ08S | Position Currency/Transaction Currency | TB_BWHR | TCURC | CUKY | 5 |
| WYQ09S | Currency Borrowing/Sale | FTI_WGSCH1 | TCURC | CUKY | 5 |
| WYQ10S | Currency Investment/Purchase | FTI_WGSCH2 | TCURC | CUKY | 5 |
| RPORTB | Portfolio | RPORTB | CHAR | 10 | |
| WYQ11S | Trader | RDEALER | TZDEA | CHAR | 12 |
| WYQ14S | Country/Region Key | LAND1 | T005 | CHAR | 3 |
| WYQ15S | Rating | BP_RATING | TP06 | CHAR | 3 |
| WYQ16S | Futures Account for Listed Options and Futures | TPM_POS_ACCOUNT_FUT | TRFT_POS_ACCOUNT | CHAR | 10 |
| WYQ18S | Industry System | BU_ISTYPE | TB038 | CHAR | 4 |
| WYQ19S | Industry | BU_IND_SECTOR | TB038A | CHAR | 10 |
| WYQ30S | Financial Transaction Type | TB_SFHAART | CHAR | 3 | |
| WYQ20S | Treasury Valuation Area | TPM_VAL_AREA | TRGC_VAL_AREA | CHAR | 3 |
| WYQ21S | Valuation Class | TPM_VAL_CLASS | TRGC_VAL_CLASS | NUMC | 4 |
| WYQ22S | General Valuation Class | TPM_COM_VAL_CLASS | TRGC_COM_VALCL | NUMC | 4 |
| WYQ23S | Securities Account Group | TPM_SEC_ACCT_GRP | TRGT_SECACCGRP | CHAR | 10 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AFWCH_STR_SP_N
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AFWCH_STR_SP_N | MANDT | 1: CN | T000 |
| AFWCH_STR_SP_N | OBJNR | 1: CN | ONR00 |
| AFWCH_STR_SP_N | WYQ03S | C: CN | VWPANLA |
| AFWCH_STR_SP_N | WYQ04S | C: CN | TWD01 |
| AFWCH_STR_SP_N | WYQ06S | C: CN | TZAF |
| AFWCH_STR_SP_N | WYQ07S | C: CN | TZPA |
| AFWCH_STR_SP_N | WYQ08S | C: CN | TCURC |
| AFWCH_STR_SP_N | WYQ09S | C: CN | TCURC |
| AFWCH_STR_SP_N | WYQ10S | C: CN | TCURC |
| AFWCH_STR_SP_N | WYQ11S | C: CN | TZDEA |
| AFWCH_STR_SP_N | WYQ14S | C: CN | T005 |
| AFWCH_STR_SP_N | WYQ15S | C: CN | TP06 |
| AFWCH_STR_SP_N | WYQ16S | C: CN | TRFT_POS_ACCOUNT |
| AFWCH_STR_SP_N | WYQ18S | C: CN | TB038 |
| AFWCH_STR_SP_N | WYQ19S | C: CN | TB038A |
| AFWCH_STR_SP_N | WYQ20S | C: CN | TRGC_VAL_AREA |
| AFWCH_STR_SP_N | WYQ21S | C: CN | TRGC_VAL_CLASS |
| AFWCH_STR_SP_N | WYQ22S | C: CN | TRGC_COM_VALCL |
| AFWCH_STR_SP_N | WYQ23S | C: CN | TRGT_SECACCGRP |