SAP Table TJKWE
IS-M/SD: WBZ, Order Data for Inbound Processing
TJKWE (IS-M/SD: WBZ, Order Data for Inbound Processing) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TJKWE to other SAP tables.
TJKWE table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values |
|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |
|
VERTRKENNZ
IS-M: WBZ, VDZ Sales Code (Num. Share Postal Sales Code)
|
JWBZVKENNZ |
CHAR
|
5 | 0 | ||
|
VERLAGSNR
IS-M: VDZ Publisher Number
|
JWBZVRLGNR |
CHAR
|
5 | 0 | ||
|
AUART
IS-M/SD: Sales Document Types
|
AUART_ISP | TJAK |
CHAR
|
4 | 0 | |
|
DRERZ
Publication
|
DRERZ | TJKWV |
CHAR
|
8 | 0 | |
|
BEZPER
Service Type
|
BEZPER | TJD09 |
CHAR
|
5 | 0 | |
|
BEZUGGRD
Purchase Reason
|
BEZUGGRD | TJK87 |
CHAR
|
3 | 0 | |
|
WERBEART
Sales Source
|
WERBEART | TJWAR |
CHAR
|
4 | 0 | |
|
WERBEAKT
Sales Promotion
|
WERBEAKT | TJWAK |
CHAR
|
8 | 0 | |
|
KUENDGRD
Reason for end of delivery
|
KUENDGRD | TJK83 |
CHAR
|
3 | 0 | |
|
STORNOGRD
Reversal Reason
|
STORNOGRD | TJK91 |
CHAR
|
3 | 0 | |
|
MENGE_MAX
IS-M: Maximum number of copies for new WBZ subscriptions
|
JWBZMAXANZ |
NUMC
|
2 | 0 | ||
|
KUENDGRD_KNAT
IS-M/SD: Reason for end of delivery in customer no.exchange
|
JWBZKUENDGRD | TJK83 |
CHAR
|
3 | 0 | |
|
BEZUGGRD_VRVENDE
IS-M/SD: Purchase reason for subs.transfer bef.clawback Dln.
|
JWBZBEZUGGRD_VOR_RVENDE | TJK87 |
CHAR
|
3 | 0 | |
|
BEZUGGRD_NRVENDE
IS-M/SD: Purch.reason for subs.transfer after clawb.deadline
|
JWBZBEZUGGRD_NACH_RVENDE | TJK87 |
CHAR
|
3 | 0 |
TJKWE foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TJKWE | AUART | TJKWE | MANDT |
TJAK
IS-M/SD: Sales Document Type
|
MANDT |
| TJKWE | AUART | TJKWE | AUART |
TJAK
IS-M/SD: Sales Document Type
|
AUART |
| TJKWE | BEZPER | TJKWE | MANDT |
TJD09
IS-M/SD: Service Type
|
MANDT |
| TJKWE | BEZPER | TJKWE | BEZPER |
TJD09
IS-M/SD: Service Type
|
BEZPER |
| TJKWE | BEZUGGRD | TJKWE | MANDT |
TJK87
Sales Documents: Purchase Reasons
|
MANDT |
| TJKWE | BEZUGGRD | TJKWE | BEZUGGRD |
TJK87
Sales Documents: Purchase Reasons
|
BEZUGGRD |
| TJKWE | BEZUGGRD_NRVENDE | TJKWE | MANDT |
TJK87
Sales Documents: Purchase Reasons
|
MANDT |
| TJKWE | BEZUGGRD_NRVENDE | TJKWE | BEZUGGRD_NRVENDE |
TJK87
Sales Documents: Purchase Reasons
|
BEZUGGRD |
| TJKWE | BEZUGGRD_VRVENDE | TJKWE | MANDT |
TJK87
Sales Documents: Purchase Reasons
|
MANDT |
| TJKWE | BEZUGGRD_VRVENDE | TJKWE | BEZUGGRD_VRVENDE |
TJK87
Sales Documents: Purchase Reasons
|
BEZUGGRD |
| TJKWE | DRERZ | TJKWE | MANDT |
TJKWV
IS-M/SD: External Connection - Sales Area Determination
|
MANDT |
| TJKWE | DRERZ | TJKWE | DRERZ |
TJKWV
IS-M/SD: External Connection - Sales Area Determination
|
DRERZ |
| TJKWE | KUENDGRD | TJKWE | KUENDGRD |
TJK83
Sales Documents: Reasons for Cancellation of Delivery
|
KUENDGRD |
| TJKWE | KUENDGRD | TJKWE | MANDT |
TJK83
Sales Documents: Reasons for Cancellation of Delivery
|
MANDT |
| TJKWE | KUENDGRD_KNAT | TJKWE | MANDT |
TJK83
Sales Documents: Reasons for Cancellation of Delivery
|
MANDT |
| TJKWE | KUENDGRD_KNAT | TJKWE | KUENDGRD_KNAT |
TJK83
Sales Documents: Reasons for Cancellation of Delivery
|
KUENDGRD |
| TJKWE | MANDT | TJKWE | MANDT |
T000
Clients
|
MANDT |
| TJKWE | STORNOGRD | TJKWE | STORNOGRD |
TJK91
Sales Documents: Reversal Reasons
|
STORNOGRD |
| TJKWE | STORNOGRD | TJKWE | MANDT |
TJK91
Sales Documents: Reversal Reasons
|
MANDT |
| TJKWE | WERBEAKT | TJKWE | MANDT |
TJWAK
IS-M/SD: Sales Promotion
|
MANDT |
| TJKWE | WERBEAKT | TJKWE | WERBEAKT |
TJWAK
IS-M/SD: Sales Promotion
|
WERBEAKT |
| TJKWE | WERBEART | TJKWE | WERBEART |
TJWAR
IS-M/SD: Sales Source
|
WERBEART |
| TJKWE | WERBEART | TJKWE | MANDT |
TJWAR
IS-M/SD: Sales Source
|
MANDT |