| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | TKONN | Trading Contract: Trading Contract Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | TKONN | Allow NULL? |
| 3 | TPOSN | Trading Contract: Item Number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | * | TPOSN | Allow NULL? |
| 4 | SIDE | Side | nvarchar | 2 | 0 | CHAR | (N' ') | No | | WLF_PR_SIDE | Allow NULL? |
| 5 | TPOSN_COM | Commodity Subitem Number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | * | WLF_TPOSN_COM | Allow NULL? |
| 6 | PR_ASPECT | Pricing Aspect | nvarchar | 4 | 0 | CHAR | (N' ') | No | WB2_C_PR | WLF_PR_ASPECT | Allow NULL? |
| 7 | PR_COUNT | Pricing Aspect Counter | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | WLF_PR_COUNT | Allow NULL? |
| 8 | QUANTITY | Pricing Quantity | varbinary | 16 | 0 | | | Yes | | WLF_PR_QUANTITY | |
| 9 | UNIT | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | WLF_UNIT | Allow NULL? |
| 10 | PR_DATE | Fixing Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WLF_PR_DATE | Allow NULL? |
| 11 | COND_TYPE | Condition Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T685 | WLF_CONDTYPE | Allow NULL? |
| 12 | KBETR | Rate (condition amount or percentage) where no scale exists | decimal | 11 | 2 | CURR | ((0)) | Yes | | KBETR_KOND | |
| 13 | KONWA | Rate unit (currency or percentage) | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | KONWA | Allow NULL? |
| 14 | KPEIN | Condition pricing unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | KPEIN | |
| 15 | KMEIN | Condition unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | KMEIN | Allow NULL? |
| 16 | KRECH | Calculation type for condition | char | 1 | 0 | CHAR | (N' ') | Yes | | KRECH | Allow NULL? |
| 17 | PRASP_GUID | Pricing aspect GUID | varbinary | 16 | 0 | RAW | | Yes | | WLF_PRASP_GUID | |
| 18 | CR_NAME | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 19 | CR_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 20 | CR_TIME | Time, at Which Record Was Added | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERZEIT | Allow NULL? |
| 21 | CH_NAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 22 | CH_DATE | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 23 | CH_TIME | Time of Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AEZEIT | Allow NULL? |
| 24 | COM_GUID | commodity GUID | varbinary | 16 | 0 | RAW | | Yes | | WLF_COM_GUID | |
| 25 | COND_TYPE2 | 2. Condition Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T685 | WLF_CONDTYPE2 | Allow NULL? |
| 26 | KBETR2 | Rate (condition amount or percentage) where no scale exists | decimal | 11 | 2 | CURR | ((0)) | Yes | | KBETR_KOND | |
| 27 | KONWA2 | Rate unit (currency or percentage) | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | KONWA | Allow NULL? |
| 28 | KPEIN2 | Condition pricing unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | KPEIN | |
| 29 | KMEIN2 | Condition unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | KMEIN | Allow NULL? |
| 30 | KRECH2 | Calculation type for condition | char | 1 | 0 | CHAR | (N' ') | Yes | | KRECH | Allow NULL? |
| 31 | COND_TYPE3 | 3. Condition Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T685 | WLF_CONDTYPE3 | Allow NULL? |
| 32 | KBETR3 | Rate (condition amount or percentage) where no scale exists | decimal | 11 | 2 | CURR | ((0)) | Yes | | KBETR_KOND | |
| 33 | KONWA3 | Rate unit (currency or percentage) | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | KONWA | Allow NULL? |
| 34 | KPEIN3 | Condition pricing unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | KPEIN | |
| 35 | KMEIN3 | Condition unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | KMEIN | Allow NULL? |
| 36 | KRECH3 | Calculation type for condition | char | 1 | 0 | CHAR | (N' ') | Yes | | KRECH | Allow NULL? |
| 37 | COND_TYPE4 | 4. Condition Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T685 | WLF_CONDTYPE4 | Allow NULL? |
| 38 | KBETR4 | Rate (condition amount or percentage) where no scale exists | decimal | 11 | 2 | CURR | ((0)) | Yes | | KBETR_KOND | |
| 39 | KONWA4 | Rate unit (currency or percentage) | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | KONWA | Allow NULL? |
| 40 | KPEIN4 | Condition pricing unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | KPEIN | |
| 41 | KMEIN4 | Condition unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | KMEIN | Allow NULL? |
| 42 | KRECH4 | Calculation type for condition | char | 1 | 0 | CHAR | (N' ') | Yes | | KRECH | Allow NULL? |
| 43 | ASSGMT_REL | Assignment Relevant | char | 1 | 0 | CHAR | (N' ') | Yes | | WLF_ASSGMT_REL | Allow NULL? |
| 44 | FUTURE | Future | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | WLF_FUTURE | Allow NULL? |
| 45 | EXT_REF | External Identifier for Pricing Aspect | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | WLF_EXT_IDENTIFIER_PRASP | Allow NULL? |
| 46 | PLACE_HOLDER | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
