| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BBYNR | Bonus buy | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | CRDATE | Created on | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | CRNAME | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 5 | CHDATE | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | CHNAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 7 | CATEG | Bonus buy category | char | 1 | 0 | | | | Allow NULL? |
| 8 | TYPE | Bonus buy type | char | 1 | 0 | | | | Allow NULL? |
| 9 | POINT | Condition target type | char | 1 | 0 | | | | Allow NULL? |
| 10 | MAXCOUNT | Indicates that condition is granted once only | char | 1 | 0 | | | | Allow NULL? |
| 11 | BPROF | Bonus Buy: Bonus buy profile | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | DATAB | Valid-From Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | DATBI | Valid To Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | AKTNR | Promotion | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | BUYCON | Link Category Line Items of "Buy" Side | char | 1 | 0 | | | | Allow NULL? |
| 16 | GETCON | Link Category for Line Items of "Get" Side | char | 1 | 0 | | | | Allow NULL? |
| 17 | CRAPPL | Bonus Buy: Application That Created the Bonus Buy | char | 1 | 0 | | | | Allow NULL? |
| 18 | CRDOCN | Bonus Buy: Document That Created the Bonus Buy | nvarchar | 10 | 0 | | | | Allow NULL? |
| 19 | STATUS | Bonus Buy Status | char | 1 | 0 | | | | Allow NULL? |
| 20 | BBYCURH | Bonus buy currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 21 | OFFER_ID | Offer ID for Promotion | nvarchar | 36 | 0 | | | | Allow NULL? |
| 22 | NEWMAIN | Bonus Buy: Flag for "New Maintenance" | char | 1 | 0 | | | | Allow NULL? |
| 23 | LIMITNR | Bonus Buy - Limit Number | decimal | 9 | 0 | | | | |
| 24 | BUY_PRQVAL_MIN | Minimum Value | decimal | 15 | 2 | | | | |
| 25 | BUY_PRQCUR | Prerequisite Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 26 | SYNCH_TO_PROMO | Synchronize Bonus Buy to Promotion | char | 1 | 0 | | | | Allow NULL? |