SAP table TWCP (Coupons: Profile for Distributing Discounts in POS Inbound)
SAP table TWCP has 2 primary key fields being MANDT,CNPRO.
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 | |
| CNPRO | Profile for distribution of coupon discounts in POS inbound | CHAR | 4 | 0 | WCNPRO | ||
| SHARE1 | Share of coupon discount | NUMC | 3 | 0 | WCNSH | ||
| SHARE2 | Share of coupon discount | NUMC | 3 | 0 | WCNSH | ||
| SHARE3 | Share of coupon discount | NUMC | 3 | 0 | WCNSH | ||
| CONDTYPE1 | Condition type for coupon discount share | CHAR | 4 | 0 | T685 | WCONDTYPE | |
| CONDTYPE2 | Condition type for coupon discount share | CHAR | 4 | 0 | T685 | WCONDTYPE | |
| CONDTYPE3 | Condition type for coupon discount share | CHAR | 4 | 0 | T685 | WCONDTYPE | |
| ACCKEY1 | Coupons: Account key for discount share | CHAR | 3 | 0 | T687 | WACCKEY | |
| ACCKEY2 | Coupons: Account key for discount share | CHAR | 3 | 0 | T687 | WACCKEY | |
| ACCKEY3 | Coupons: Account key for discount share | CHAR | 3 | 0 | T687 | WACCKEY | |
| MARGEFF1 | Flag: Coupon discount affects margins | CHAR | 1 | 0 | WMARGEFF | ||
| MARGEFF2 | Flag: Coupon discount affects margins | CHAR | 1 | 0 | WMARGEFF | ||
| MARGEFF3 | Flag: Coupon discount affects margins | CHAR | 1 | 0 | WMARGEFF |
TWCP foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TWCP | ACCKEY1 | T687 | Account Determination: Account Key | KAPPL |
| 1 TWCP | ACCKEY2 | T687 | Account Determination: Account Key | KAPPL |
| 0 TWCP | ACCKEY3 | T687 | Account Determination: Account Key | KAPPL |
| 1 TWCP | CONDTYPE1 | T685 | Conditions: Types | KAPPL |
| 1 TWCP | CONDTYPE1 | T685 | Conditions: Types | KSCHL |
| 0 TWCP | CONDTYPE2 | T685 | Conditions: Types | KAPPL |
| 0 TWCP | CONDTYPE2 | T685 | Conditions: Types | KSCHL |
| 1 TWCP | CONDTYPE3 | T685 | Conditions: Types | KAPPL |
| 1 TWCP | CONDTYPE3 | T685 | Conditions: Types | KSCHL |