SAP Table JKPROM
Sales Order: Introduction Data
JKPROM (Sales Order: Introduction Data) 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 JKPROM to other SAP tables.
JKPROM table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| VBELN | IS-M/SD: Publishing Sales Order | AVNR | JKAK | CHAR | 10 | 0 | ||||||
| POSNR | Original Item in Publishing Sales Order | APNR_UR | JKAP | NUMC | 6 | 0 | ||||||
| PROMNR | Sales order introduction | JPROMNR | NUMC | 3 | 0 | |||||||
| WERBEART | Sales Source | WERBEART | TJWAR | CHAR | 4 | 0 | ||||||
| WERBEAKT | Sales Promotion | WERBEAKT | TJWAK | CHAR | 8 | 0 | ||||||
| GUELTIGVON | Start of Validity of Campaign Framework | WERBVONDT | DATS | 8 | 0 | |||||||
| XAQUISITION | IS-M/SD: Indicator - first introduction record | XAQUISITION | CHAR | 1 | 0 |
Possible values
|
||||||
| WERBTRAEG | Advertising Medium | WERBTRAEG | CHAR | 10 | 0 | |||||||
| MINDBEZUG | Minimum Length of Subscription | MINDBEZUG | QUAN | 2 | 0 | |||||||
| MINDBEZEIN | Time Unit for Minimum Length of Subscription | MINDBEZEIN | T006 | UNIT | 3 | 0 | ||||||
| LIEFUNTMAX | Maximum Delivery Suspension | LIEFUNTMAX | QUAN | 2 | 0 | |||||||
| LIEFUMXEIN | Time unit for maximum delivery suspension | LIEFUMXEIN | T006 | UNIT | 3 | 0 | ||||||
| GPRECH | IS-M: Researcher | GPRECH | JGTGPNR | CHAR | 10 | 0 | ||||||
| VSGRCHEUR | Researcher's Service Company | VSGRCHEUR | JGTVSG | CHAR | 10 | 0 | ||||||
| XRECHERZ | IS-M: Research generated | XRECHERZ | CHAR | 1 | 0 |
Possible values
|
||||||
| KONTAKTNR | IS-M: Business Partner Sales Activity | KONTAKTNR | JWTWEKO | CHAR | 10 | 0 | ||||||
| POSNR_BASE | Sales Order Item | APNR | JKAP | NUMC | 6 | 0 | ||||||
| CYCLENR_BASE | IS-M/SD: Billing Cycle Number | CYCLENR | JKACCOUNT | NUMC | 3 | 0 | ||||||
| EVENT | IS-M/SD: Event in order processing | JK_EVENT | TJKEVENT | CHAR | 4 | 0 | ||||||
| ERFUSER | Created By | ERFUSER | CHAR | 12 | 0 | |||||||
| ERFDATE | Created On | ERFDATE | DATS | 8 | 0 | |||||||
| ERFTIME | Time Created | ERFTIME | TIMS | 6 | 0 | |||||||
| AENUSER | Last Changed By | AENUSER | CHAR | 12 | 0 | |||||||
| AENDATE | Date of Last Change | AENDATE | DATS | 8 | 0 | |||||||
| AENTIME | Time of Last Change | AENTIME | TIMS | 6 | 0 | |||||||
JKPROM foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| JKPROM | CYCLENR_BASE | JKPROM | MANDT | JKACCOUNT | IS-M/SD: Liability Account for Subscription | MANDT |
| JKPROM | CYCLENR_BASE | JKPROM | VBELN | JKACCOUNT | IS-M/SD: Liability Account for Subscription | VBELN |
| JKPROM | CYCLENR_BASE | JKPROM | POSNR_BASE | JKACCOUNT | IS-M/SD: Liability Account for Subscription | POSNR_UR |
| JKPROM | CYCLENR_BASE | JKPROM | CYCLENR_BASE | JKACCOUNT | IS-M/SD: Liability Account for Subscription | CYCLENR |
| JKPROM | EVENT | JKPROM | EVENT | TJKEVENT | IS-M/SD: Events in Order Processing | EVENT |
| JKPROM | EVENT | JKPROM | MANDT | TJKEVENT | IS-M/SD: Events in Order Processing | MANDT |
| JKPROM | GPRECH | JKPROM | MANDT | JGTGPNR | IS-M: Central Business Partner Table | MANDT |
| JKPROM | GPRECH | JKPROM | GPRECH | JGTGPNR | IS-M: Central Business Partner Table | GPNR |
| JKPROM | KONTAKTNR | JKPROM | MANDT | JWTWEKO | IS-M/SD: Sales Activity for Business Partner | MANDT |
| JKPROM | KONTAKTNR | JKPROM | KONTAKTNR | JWTWEKO | IS-M/SD: Sales Activity for Business Partner | KONTAKTNR |
| JKPROM | LIEFUMXEIN | JKPROM | MANDT | T006 | Units of Measurement | MANDT |
| JKPROM | LIEFUMXEIN | JKPROM | LIEFUMXEIN | T006 | Units of Measurement | MSEHI |
| JKPROM | MANDT | JKPROM | MANDT | T000 | Clients | MANDT |
| JKPROM | MINDBEZEIN | JKPROM | MANDT | T006 | Units of Measurement | MANDT |
| JKPROM | MINDBEZEIN | JKPROM | MINDBEZEIN | T006 | Units of Measurement | MSEHI |
| JKPROM | POSNR | JKPROM | MANDT | JKAP | Sales Order - Item Data | MANDT |
| JKPROM | POSNR | JKPROM | VBELN | JKAP | Sales Order - Item Data | VBELN |
| JKPROM | POSNR | JKPROM | POSNR | JKAP | Sales Order - Item Data | POSNR |
| JKPROM | POSNR_BASE | JKPROM | VBELN | JKAP | Sales Order - Item Data | VBELN |
| JKPROM | POSNR_BASE | JKPROM | POSNR_BASE | JKAP | Sales Order - Item Data | POSNR |
| JKPROM | POSNR_BASE | JKPROM | MANDT | JKAP | Sales Order - Item Data | MANDT |
| JKPROM | VBELN | JKPROM | MANDT | JKAK | Sales Order Header Data | MANDT |
| JKPROM | VBELN | JKPROM | VBELN | JKAK | Sales Order Header Data | VBELN |
| JKPROM | VSGRCHEUR | JKPROM | VSGRCHEUR | JGTVSG | IS-M/SD: Service Companies | VERSERVGES |
| JKPROM | VSGRCHEUR | JKPROM | MANDT | JGTVSG | IS-M/SD: Service Companies | MANDT |
| JKPROM | WERBEAKT | JKPROM | MANDT | TJWAK | IS-M/SD: Sales Promotion | MANDT |
| JKPROM | WERBEAKT | JKPROM | WERBEAKT | TJWAK | IS-M/SD: Sales Promotion | WERBEAKT |
| JKPROM | WERBEART | JKPROM | MANDT | TJWAR | IS-M/SD: Sales Source | MANDT |
| JKPROM | WERBEART | JKPROM | WERBEART | TJWAR | IS-M/SD: Sales Source | WERBEART |
