SAP ABAP Table JSBW_SD_ORDER_ABO_JKPROM (IS-M/SD: BW Structure for Reading Data from JKPROM)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M-IS (Application Component) Information System
     ⤷ JSBW (Package) IS-M: Link to Business Information Warehouse

Basic Data

Table Category	INTTAB	Structure
Structure	JSBW_SD_ORDER_ABO_JKPROM	Table Relationship Diagram
Short Description	IS-M/SD: BW Structure for Reading Data from JKPROM

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	POSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
2	.INCLUDE	☐				0	0	Sales Order: Introduction Data
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	VBELN	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	JKAK
5	POSNR	☐	APNR_UR	APNR	NUMC	6	0	Original Item in Publishing Sales Order	JKAP
6	PROMNR	☐	JPROMNR	JPROMNR	NUMC	3	0	Sales order introduction	*
7	WERBEART	☐	WERBEART	WERBEART	CHAR	4	0	Sales Source	TJWAR
8	WERBEAKT	☐	WERBEAKT	WERBEAKT	CHAR	8	0	Sales Promotion	TJWAK
9	GUELTIGVON	☐	WERBVONDT	DATUM	DATS	8	0	Start of Validity of Campaign Framework
10	XAQUISITION	☐	XAQUISITION	XFELD	CHAR	1	0	IS-M/SD: Indicator - first introduction record
11	WERBTRAEG	☐	WERBTRAEG	WERBTRAEG	CHAR	10	0	Advertising Medium	*
12	MINDBEZUG	☐	MINDBEZUG	ISPMNG2	QUAN	2	0	Minimum Length of Subscription
13	MINDBEZEIN	☐	MINDBEZEIN	MEINS	UNIT	3	0	Time Unit for Minimum Length of Subscription	T006
14	LIEFUNTMAX	☐	LIEFUNTMAX	ISPMNG2	QUAN	2	0	Maximum Delivery Suspension
15	LIEFUMXEIN	☐	LIEFUMXEIN	MEINS	UNIT	3	0	Time unit for maximum delivery suspension	T006
16	GPRECH	☐	GPRECH	GPNR	CHAR	10	0	IS-M: Researcher	JGTGPNR
17	VSGRCHEUR	☐	VSGRCHEUR	GPNR	CHAR	10	0	Researcher's Service Company	JGTVSG
18	XRECHERZ	☐	XRECHERZ	XFELD	CHAR	1	0	IS-M: Research generated
19	KONTAKTNR	☐	KONTAKTNR	ERSATZNR	CHAR	10	0	IS-M: Business Partner Sales Activity	JWTWEKO
20	POSNR_BASE	☐	APNR	APNR	NUMC	6	0	Sales Order Item	JKAP
21	CYCLENR_BASE	☐	CYCLENR	CYCLENR	NUMC	3	0	IS-M/SD: Billing Cycle Number	JKACCOUNT
22	EVENT	☐	JK_EVENT	JK_EVENT	CHAR	4	0	IS-M/SD: Event in order processing	TJKEVENT
23	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
24	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
25	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
26	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
27	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
28	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
29	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JSBW_SD_ORDER_ABO_JKPROM	CYCLENR_BASE	JKACCOUNT	CYCLENR	REF	C	CN
2	JSBW_SD_ORDER_ABO_JKPROM	EVENT	TJKEVENT	EVENT	REF	C	CN
3	JSBW_SD_ORDER_ABO_JKPROM	GPRECH	JGTGPNR	GPNR	REF	C	CN
4	JSBW_SD_ORDER_ABO_JKPROM	KONTAKTNR	JWTWEKO	KONTAKTNR	REF	C	CN
5	JSBW_SD_ORDER_ABO_JKPROM	LIEFUMXEIN	T006	MSEHI	REF	C	CN
6	JSBW_SD_ORDER_ABO_JKPROM	MANDT	T000	MANDT	KEY	1	CN
7	JSBW_SD_ORDER_ABO_JKPROM	MINDBEZEIN	T006	MSEHI	REF	C	CN
8	JSBW_SD_ORDER_ABO_JKPROM	POSNR	JKAP	POSNR	KEY	1	CN
9	JSBW_SD_ORDER_ABO_JKPROM	POSNR_BASE	JKAP	POSNR	KEY	1	CN
10	JSBW_SD_ORDER_ABO_JKPROM	VBELN	JKAK	VBELN	KEY	1	CN
11	JSBW_SD_ORDER_ABO_JKPROM	VSGRCHEUR	JGTVSG	VERSERVGES	REF	C	CN
12	JSBW_SD_ORDER_ABO_JKPROM	WERBEAKT	TJWAK	WERBEAKT	REF	C	CN
13	JSBW_SD_ORDER_ABO_JKPROM	WERBEART	TJWAR	WERBEART	REF	C	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in	471