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 | |||
|---|---|---|---|---|---|---|---|---|
| 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 | BEZUGGRD_VRVENDE | TJK87 | Sales Documents: Purchase Reasons | BEZUGGRD |
| TJKWE | BEZUGGRD_VRVENDE | TJKWE | MANDT | TJK87 | Sales Documents: Purchase Reasons | MANDT |
| 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 | MANDT | TJK83 | Sales Documents: Reasons for Cancellation of Delivery | MANDT |
| TJKWE | KUENDGRD | TJKWE | KUENDGRD | TJK83 | Sales Documents: Reasons for Cancellation of Delivery | KUENDGRD |
| TJKWE | KUENDGRD_KNAT | TJKWE | KUENDGRD_KNAT | TJK83 | Sales Documents: Reasons for Cancellation of Delivery | KUENDGRD |
| TJKWE | KUENDGRD_KNAT | TJKWE | MANDT | TJK83 | Sales Documents: Reasons for Cancellation of Delivery | MANDT |
| TJKWE | MANDT | TJKWE | MANDT | T000 | Clients | MANDT |
| TJKWE | STORNOGRD | TJKWE | MANDT | TJK91 | Sales Documents: Reversal Reasons | MANDT |
| TJKWE | STORNOGRD | TJKWE | STORNOGRD | TJK91 | Sales Documents: Reversal Reasons | STORNOGRD |
| 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 | MANDT | TJWAR | IS-M/SD: Sales Source | MANDT |
| TJKWE | WERBEART | TJKWE | WERBEART | TJWAR | IS-M/SD: Sales Source | WERBEART |
