SAP AFWCH_STR_SP_CLD Analysis Structure: Template for Cloud Version Table
Overview
AFWCH_STR_SP_CLD is a standard SAP S/4HANA table that stores Analysis Structure: Template for Cloud Version data. There are total 11 fields in the AFWCH_STR_SP_CLD 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_CLD 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_CLD to other SAP tables and standard CDS views available based on AFWCH_STR_SP_CLD table in S/4HANA 2020.
Techincal Settings of AFWCH_STR_SP_CLD
Below are technical details of the table AFWCH_STR_SP_CLD
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AFWCH_STR_SP_CLD Fields
The following table gives you an overview of the fields available in AFWCH_STR_SP_CLD
| 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 |
| 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 |
| RPORTB | Portfolio | RPORTB | CHAR | 10 | |
| WYQ14S | Country/Region Key | LAND1 | T005 | CHAR | 3 |
| WYQ12S | Business Partner Number | BU_PARTNER | BUT000 | CHAR | 10 |
| WYQ01S | Financial Transaction | TB_RFHA | VTBFHA | CHAR | 13 |
| WYQ33S | Characteristics | TB_MERKM | CHAR | 25 |
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_CLD
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AFWCH_STR_SP_CLD | MANDT | 1: CN | T000 |
| AFWCH_STR_SP_CLD | OBJNR | 1: CN | ONR00 |
| AFWCH_STR_SP_CLD | WYQ01S | C: CN | VTBFHA |
| AFWCH_STR_SP_CLD | WYQ06S | C: CN | TZAF |
| AFWCH_STR_SP_CLD | WYQ07S | C: CN | TZPA |
| AFWCH_STR_SP_CLD | WYQ08S | C: CN | TCURC |
| AFWCH_STR_SP_CLD | WYQ12S | C: CN | BUT000 |
| AFWCH_STR_SP_CLD | WYQ14S | C: CN | T005 |