SAP table TCSPF (Cross-Selling: Profile Determination)
SAP table TCSPF has 6 primary key fields being MANDT,VKORG,VTWEG,SPART,CSKSM,CSBSM.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | * | MANDT | |
| VKORG | Sales Organization | CHAR | 4 | 0 | TVKO | VKORG | |
| VTWEG | Distribution Channel | CHAR | 2 | 0 | TVKOV | VTWEG | |
| SPART | Division | CHAR | 2 | 0 | TVTA | SPART | |
| CSKSM | Cross-selling customer procedure | CHAR | 2 | 0 | TPVD | CSKSM | |
| CSBSM | Cross-selling document procedure | CHAR | 2 | 0 | TPVV | CSBSM | |
| CRSPL | Cross-selling profile | CHAR | 6 | 0 | TCSP | CRSPL |
TCSPF foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TCSPF | CRSPL | TCSP | Cross-Selling Profile: Definition | MANDT |
| 1 TCSPF | CSBSM | TPVV | Product Proposal: Definition of Transaction Procedure | PVBSM |
| 0 TCSPF | CSKSM | TPVD | Product Proposal: Definition of Customer Procedure | PVKSM |
| 1 TCSPF | SPART | TVTA | Organizational Unit: Sales Area(s) | MANDT |
| 1 TCSPF | SPART | TVTA | Organizational Unit: Sales Area(s) | VKORG |
| 1 TCSPF | SPART | TVTA | Organizational Unit: Sales Area(s) | VTWEG |
| 1 TCSPF | SPART | TVTA | Organizational Unit: Sales Area(s) | SPART |
| 0 TCSPF | VKORG | TVKO | Organizational Unit: Sales Organizations | MANDT |
| 0 TCSPF | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| 1 TCSPF | VTWEG | TVKOV | Org. Unit: Distribution Channels per Sales Organization | MANDT |
| 1 TCSPF | VTWEG | TVKOV | Org. Unit: Distribution Channels per Sales Organization | VKORG |
| 1 TCSPF | VTWEG | TVKOV | Org. Unit: Distribution Channels per Sales Organization | VTWEG |