SAP ABAP Table BAPIBUSISM008_AGENT_ASS_OUT (IS-M/AM: Sales agent assignment)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***

Basic Data

Table Category	INTTAB	Structure
Structure	BAPIBUSISM008_AGENT_ASS_OUT	Table Relationship Diagram
Short Description	IS-M/AM: Sales agent assignment

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	DOCUMENT_NO	☑	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
2	ITEM_NUMBER	☑	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
3	BILLING_DATASET_NO	☑	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	JHAGA
4	SALES_AGT_CONTRACT_NO	☑	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	JJTVV
5	SALES_AGT_CONTRACT_REQ_NO	☑	VM_BEDNR	VM_BEDNR	NUMC	6	0	IS-M: Number of Media Sales Agent Contract Requirement	JJTVB
6	COMMISSION_CATEGORY	☑	PROVTYP	PROVTYP	CHAR	1	0	IS-M/AM: Commission Category
7	SALES_AGT_ASSIGNMENT_NO	☑	JH_VZUONR	JH_VZUONR	NUMC	2	0	IS-M/AM: Sales Agent Assignment Number (Corrections)	*
8	SALES_AGENT	☐	VERM_MEDIA	GPNR	CHAR	10	0	IS-M: Media Sales Agent	JGTGPNR
9	SALES_AGENT_EXTERNAL	☐	BU_BPEXT	CHAR20	CHAR	20	0	Business Partner Number in External System
10	SALES_AGT_ASSIGNMENT_ORIGIN	☐	JH_GVZ_ORIGIN	JH_GVZ_ORIGIN	CHAR	1	0	IS-M/AM: Sales Agent Assignment Origin
11	SHARE_OF_CALCULATION_BASE	☐	VPROVBAS	DECV4_3	DEC	7	3	IS-M: Sales Agent Share of Calculation Base (in %)
12	SHARE_OF_COMMISSION	☐	VPROZP	DEC4_3	DEC	7	3	IS-M: Sales Agent Share of Commission (in %)
13	SHARE_MANUALLY_CHANGED	☐	JHPRAXMANU	XFELD	CHAR	1	0	IS-M: Sales Agent Share was Changed Manually Indicator
14	COMMISSION_KEY	☐	JPROVSCHL	PRSCHL	CHAR	5	0	IS-M/AM: Commission Key for Media Sales Agent	TJH23
15	COMMISSION_RATE	☐	PROV_SATZ	DECV4_3	DEC	7	3	IS-M: Commission Rate (Percent)
16	COMMISSION_AMOUNT	☐	ISM_PROV_SATZM	BAPICURR	DEC	23	4	IS-M: Commission Amount mm Commission (BAPICURR)
17	COMMISSION_AMOUNT_CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
18	COMMISSION_AMOUNT_CURRENCY_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
19	COMMISSION_AMOUNT_P_UNT	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
20	COMMISSION_AMOUNT_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
21	COMMISSION_AMOUNT_UOM_ISO	☐	KVMEI_ISO	ISOCD_UNIT	CHAR	3	0	Condition Unit in ISO Code	T006I
22	COMMISSION_AMOUNT_COND_REF	☐	JBEZKOND	JBEZKOND	CHAR	2	0	IS-M: Condition Reference	*
23	SALES_AGT_ASS_MANUALLY_CHANGED	☐	VZMANUAEND	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment was Changed Indicator
24	SALES_AGT_REQUIREMENT_GROUP	☐	BEDGR	BEDGR	CHAR	2	0	IS-M: Media Sales Agent Requirement Group	*
25	SALES_AGT_TYPE	☐	JVERMART	JVERMART	CHAR	2	0	IS-M: Media Sales Agent Type: General/City/Special Agent	*
26	EXTRA_COMMISSION	☐	ISM_EXTRA_COMMISSION	JVANR	CHAR	5	0	IS-M: Extra Commission
27	PREC_SALES_AGT_ASSIGNMENT_NO	☐	JH_REF_VZUONR	JH_VZUONR	NUMC	2	0	IS-M/AM: Reference Number of the Preceding Agent Assignmt	*
28	SUCC_SALES_AGT_ASSIGNMENT_NO	☐	JH_SUC_VZUONR	JH_VZUONR	NUMC	2	0	IS-M: Reference No.of Successor Sales Agent Assignment	*
29	CORRECTION_REASON	☐	JHVZCC	JHVZCC	CHAR	2	0	IS-M/AM: Reason for Correction to Sales Agent Assignment	*
30	CANCELLATION_REASON	☐	JHCANCELCC	JHVZCC	CHAR	2	0	IS-M: Reversal Correction Reason for Sales Agent Assignment	*
31	INCOMPLETE	☐	XUVVZ_GVZ	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment is Incomplete
32	INACTIVE	☐	XZUOINACT	XFELD	CHAR	1	0	IS-M: Indicator Sales Agent Assignment is Inactive
33	DELETED	☐	PR_XDEL	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment Deleted Manually Indicator
34	SETTLEMENT_PERFORMED	☐	XPROV_EE	XFELD	CHAR	1	0	IS-M: Settlement Performed (Sales Agent Payment) Indicator
35	STATUS_CHARACTERISTIC0	☐	MERK0_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 0 for Ind.Use (Sales Agent Assignment)
36	STATUS_CHARACTERISTIC1	☐	MERK1_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 1 for Ind.Use (Sales Agent Assignment)
37	STATUS_CHARACTERISTIC2	☐	MERK2_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 2 for Ind.Use (Sales Agent Assignment)
38	STATUS_CHARACTERISTIC3	☐	MERK3_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 3 for Ind.Use (Sales Agent Assignment)
39	STATUS_CHARACTERISTIC4	☐	MERK4_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 4 for Ind.Use (Sales Agent Assignment)
40	STATUS_CHARACTERISTIC5	☐	MERK5_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 5 for Ind.Use (Sales Agent Assignment)
41	STATUS_CHARACTERISTIC6	☐	MERK6_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 6 for Ind.Use (Sales Agent Assignment)
42	STATUS_CHARACTERISTIC7	☐	MERK7_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 7 for Ind.Use (Sales Agent Assignment)
43	STATUS_CHARACTERISTIC8	☐	MERK8_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 8 for Ind.Use (Sales Agent Assignment)
44	STATUS_CHARACTERISTIC9	☐	MERK9_VZ	XFELD	CHAR	1	0	CIS-M: Characteristic 9 for Ind.Use (Sales Agent Assignment)
45	STATUS	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPIBUSISM008_AGENT_ASS_OUT	BILLING_DATASET_NO	JHAGA	GRUPPABRNR	KEY	1	CN
2	BAPIBUSISM008_AGENT_ASS_OUT	COMMISSION_AMOUNT_CURRENCY	TCURC	WAERS	REF	1	CN
3	BAPIBUSISM008_AGENT_ASS_OUT	COMMISSION_AMOUNT_UOM	T006	MSEHI	REF	1	CN
4	BAPIBUSISM008_AGENT_ASS_OUT	COMMISSION_AMOUNT_UOM_ISO	T006I	ISOCODE	REF	1	CN
5	BAPIBUSISM008_AGENT_ASS_OUT	COMMISSION_KEY	TJH23	PRSCHL	REF	1	CN
6	BAPIBUSISM008_AGENT_ASS_OUT	DOCUMENT_NO	JHAK	AVM_NR	KEY	1	CN
7	BAPIBUSISM008_AGENT_ASS_OUT	ITEM_NUMBER	JHAP	POS_NR	KEY	1	CN
8	BAPIBUSISM008_AGENT_ASS_OUT	SALES_AGENT	JGTGPNR	GPNR	KEY	1	CN
9	BAPIBUSISM008_AGENT_ASS_OUT	SALES_AGT_CONTRACT_NO	JJTVV	VNR	KEY	1	CN
10	BAPIBUSISM008_AGENT_ASS_OUT	SALES_AGT_CONTRACT_REQ_NO	JJTVB	BEDNR	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	464