SAP ABAP Table CRMS_MKTPL_EXKN (Account Assignement Data)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ MM-PUR (Application Component) Purchasing
     ⤷ CRM_MKTPL_PURCHASE_INTEGRATION (Package) Purchase process integration for marketing objects

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_EXKN	Table Relationship Diagram
Short Description	Account Assignement Data

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	.INCLUDE	☐				0	0	Key of purchase assignment item
2	PROJECT_GUID	☐	GUID		RAW	16	0	Globally Unique Identifier
3	PHEAD_ASSIG_GUID	☐	GUID		RAW	16	0	Globally Unique Identifier
4	PITEM_ASSIG_GUID	☐	GUID		RAW	16	0	Globally Unique Identifier
5	.INCLUDE	☐				0	0	Acct Assgt Structure for Ext. Purch. Docs (and Requisitions)
6	ZEXKN	☐	DZEKKN	NUM02	NUMC	2	0	Sequential Number of Account Assignment
7	LOEKZ	☐	KLOEK	XFELD	CHAR	1	0	Deletion Indicator: Purchasing Document Account Assignment
8	AEDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
9	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
10	VPROZ	☐	VPROZ	VPROZ	DEC	3	1	Distribution percentage in the case of multiple acct assgt
11	NETWR	☐	BWERT	WERT7	CURR	13	2	Net Order Value in PO Currency
12	SAKTO	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKA1
13	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
14	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
15	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
16	VBELP	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
17	VETEN	☐	ETENR	ETENR	NUMC	4	0	Schedule line	*
18	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
19	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
20	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
21	WEMPF	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
22	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
23	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
24	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	*
25	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
26	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
27	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
28	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
29	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
30	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
31	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
32	VPTNR	☐	JV_PART	KUNNR	CHAR	10	0	Partner account number	*
33	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
34	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	*
35	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
36	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
37	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
38	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
39	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
40	AUFPL_ORD	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
41	APLZL_ORD	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	*
42	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
43	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
44	NAVNW	☐	NAVNW	WERT7	CURR	13	2	Non-deductible input tax
45	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
46	PRZNR	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	*
47	.INCLUDE	☐				0	0	Include for the Reduction of Funds Reservations (FM)
48	KBLNR	☐	KBLNR	KBLNR	CHAR	10	0	Document Number for Earmarked Funds	*
49	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
50	.INCLUDE	☐				0	0
51	.INCLUDE	☐				0	0	Include RE Accounting Fields (External,without IMKEY, DABRZ)
52	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	*
53	SGENR	☐	SGENR	SGENR	CHAR	8	0	Building Number	*
54	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	*
55	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	*
56	SMIVE	☐	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
57	SNKSL	☐	SNKSL	SNKSL	CHAR	4	0	Service Charge Key	*
58	SEMPSL	☐	SEMPSL	SEMPSL	CHAR	5	0	Settlement Unit	*
59	SVWNR	☐	VVSVWNR	VVSVWNR	CHAR	13	0	Management Contract Number	*
60	RECNNR	☐	RECNNR	RECNNR	CHAR	13	0	Real Estate Contract Number
61	SBERI	☐	SBERI	SBERI	CHAR	10	0	Correction item number	*
62	TCNO	☐	VVREITTCNO	VVREITTCNO	CHAR	16	0	RE-FX: Number of Correction Object
63	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
64	PSP_PNR	☐	PSP_PNR	CHAR24	CHAR	24	0	Work breakdown structure element (WBS element)
65	SRV_UPDKZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)
66	.INCLUDE	☐				0	0	PSM Fields used in multiple account splitting
67	FM_SPLIT_BATCH	☐	FMSP_SPLIT_BATCH	NUMC3	NUMC	3	0	Batch to group results from an PSM assignment distribution
68	FM_SPLIT_BEGRU	☐	FMSP_SPLIT_AUTG	FMSP_SPLIT_AUTG	CHAR	4	0	Authorization group for PSM account assignment distribution	*
69	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
70	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
71	.INCLUDE	☐				0	0	MAA - Final Account Assignment Indicator
72	AA_FINAL_IND	☐	AA_FINAL_IND	XFELD	CHAR	1	0	Final Account Assignment Indicator
73	AA_FINAL_REASON	☐	AA_FINAL_REASON	CHAR02	CHAR	2	0	Final Account Assignment Reason Code	T163RC
74	AA_FINAL_QTY	☐	AA_FINAL_QTY	MENG13	QUAN	13	3	Final Account Assignment Quantity
75	AA_FINAL_QTY_F	☐	AA_FINAL_QTY_F		FLTP	16	16	Final Account Assignment Quantity (Floating Point Number)
76	MENGE_F	☐	MENGE_F		FLTP	16	16	Quantity (Floating Point Number - Internal Field)
77	.INCLU--AP	☐				0	0	Joint venture data
78	EGRUP	☐	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group	*
79	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
80	.INCLU--AP	☐				0	0	Vorsteuerkorrektur
81	.INCLUDE	☐				0	0	VstBerichtigung: Zusatzfelder
82	TCOBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
83	DATEOFSERVICE	☐	VVBEACTDATE	DATUM	DATS	8	0	Date of Service
84	NOTAXCORR	☐	VVREITNOTAXCORR	BOOLE	CHAR	1	0	Do Not Consider Item in Input Tax Correction
85	DIFFOPTRATE	☐	POPTSATZ	POPTSATZ	DEC	9	6	Real Estate Option Rate
86	HASDIFFOPTRATE	☐	VVREITUSEDIFFOPTRATE	BOOLE	CHAR	1	0	Use Different Option Rate

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMS_MKTPL_EXKN	AA_FINAL_REASON	T163RC	AA_FINAL_REASON	REF	1	N
2	CRMS_MKTPL_EXKN	SAKTO	SKA1	SAKNR

History

Last changed by/on	SAP	20130529
SAP Release Created in	604