SAP ABAP View CACS00_V_DOCSD (Settlement Items and Line Item Detail Lines)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ ICM (Application Component) Incentive and Commission Management (ICM)
     ⤷ CACSCC (Package) ICM: Commission Case 'Light'

Basic Data

View Type	D	Database View
Database View	CACS00_V_DOCSD
Short Description	Settlement Items and Line Item Detail Lines
Root table	CACS00_DOCSE	Commission Document, Settlement

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CACS00_DOCSE	CACS00_DOCSE
2	CACS00_DOCSEDT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CACS00_DOCSE	MANDT	JL	EQ				0	0
2	CACS00_DOCSEDT	MANDT	JR	EQ			AND	0	0
3	CACS00_DOCSE	POST_YEAR	JL	EQ				0	0
4	CACS00_DOCSEDT	POST_YEAR	JR	EQ			AND	0	0
5	CACS00_DOCSE	DOC_ID	JL	EQ				0	0
6	CACS00_DOCSEDT	DOC_ID	JR	EQ			AND	0	0
7	CACS00_DOCSE	SETTL_POS	JL	EQ				0	0
8	CACS00_DOCSEDT	SETTL_POS	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	CACS00_DOCSE	MANDT		☐	MANDT	☐	Client
2	POST_YEAR	CACS00_DOCSE	POST_YEAR		☐	CACSPSTYEAR	☐	Assignment Year of Commission Case/Document
3	DOC_ID	CACS00_DOCSE	DOC_ID		☐	CACSDOCID	☐	Document Identification
4	SETTL_POS	CACS00_DOCSE	SETTL_POS		☐	CACSSETTLPOS	☐	Identification of a Settlement Item
5	DETAIL_POS	CACS00_DOCSEDT	DETAIL_POS		☐	CACSSETTLDTPOS	☐	Number of Detail Line in Settlement Item
6	FLG_REVERSED	CACS00_DOCSE	FLG_REVERSED		☐	CACSFLGREV	☐	Indicator: Row/Object/Subobject is Invalid or Reversed
7	STATUS_POS	CACS00_DOCSE	STATUS_POS		☐	CACSSTATUSPOS	☐	Status of Object/Subobject
8	STATUS_WORK	CACS00_DOCSE	STATUS_WORK		☐	CACSSTATUSWORKP	☐	Object Processing Status (Replica)
9	CTRTBU_ID	CACS00_DOCSE	CTRTBU_ID		☐	CACS_CTRTBU_ID	☐	Commission Contract Number
10	GPART	CACS00_DOCSE	GPART		☐	CACS_GPART_INV	☐	Business Partner to Receive Commission
11	DUE_DATE	CACS00_DOCSE	DUE_DATE		☐	CACSDUEDAT	☐	Due Date of Line Item
12	DUE_YEAR	CACS00_DOCSE	DUE_YEAR		☐	CACSDUEYEAR	☐	Year Due: Document Item
13	DUE_MONTH	CACS00_DOCSE	DUE_MONTH		☐	CACSDUEMON	☐	Period in Year Due
14	STMTYPE_ID	CACS00_DOCSE	STMTYPE_ID		☐	CACS_STMTYPE_ID	☐	Identification of Settlement Type
15	REMUNERATION	CACS00_DOCSE	REMUNERATION		☐	CACSREM	☐	Remuneration Type
16	SETTLE_GROUP	CACS00_DOCSE	SETTLE_GROUP		☐	CACSSETTLEGROUP	☐	Settlement Item Grouping in Document
17	FLG_INTSETTLE	CACS00_DOCSE	FLG_INTSETTLE		☐	CACSINTSETTLEMENT	☐	Settlement Item Serves Immediate Clearing
18	DET_GRP	CACS00_DOCSE	DET_GRP		☐	CACSSETTLEDETGRP	☐	Grouping of Due Line Item Detail in Document
19	CON_CURR	CACS00_DOCSE	CON_CURR		☐	CACSCONCURR	☐	Contract Currency Key
20	DUE_CONAMNT	CACS00_DOCSE	DUE_CONAMNT		☐	CACSDUECONAMNT	☐	Remuneration Amount Ready for Disbursement in Contr Currency
21	LED_CURR	CACS00_DOCSE	LED_CURR		☐	CACSLEDCURR	☐	Currency Key
22	DUE_LEDAMNT	CACS00_DOCSE	DUE_LEDAMNT		☐	CACSDUELEDAMNT	☐	Disbursable Partial Remuner.Amount in Comm. Model Currency
23	REM_UNIT	CACS00_DOCSE	REM_UNIT		☐	CACSREMUUNIT	☐	Remuneration Unit
24	DUE_QUAN	CACS00_DOCSE	DUE_QUAN		☐	CACSDUEQUAN	☐	Remuneration Quantity Ready for Disbursement
25	SETTLE_DATE	CACS00_DOCSE	SETTLE_DATE		☐	CACSSETTLEDATE	☐	Settlement Date
26	SETTLE_POST_YEAR	CACS00_DOCSE	SETTLE_POST_YEAR		☐	CACSDOCYEARSETTLE	☐	Posting Year of Settlement Document
27	SETTLE_DOC_ID	CACS00_DOCSE	SETTLE_DOC_ID		☐	CACSDOCIDSETTLE	☐	Settlement Document Number
28	PMNT_BLOCK	CACS00_DOCSE	PMNT_BLOCK		☐	DZLSPR	☐	Payment Block Key
29	REM_CASE_TXT	CACS00_DOCSE	REM_CASE_TXT		☐	CACSSETTLCASETXT	☐	Short Text for Settlement Item
30	REV_POS	CACS00_DOCSE	REV_POS		☐	CACSREVPOS	☐	Reversing Row of Related Reversal Document
31	SETT_LOCK	CACS00_DOCSE	SETT_LOCK		☐	CACSSETTLOCK	☐	Indicator: Item Waiting for Subsequent Process
32	RE_POST_YEAR	CACS00_DOCSEDT	RE_POST_YEAR		☐	CACSPSTYEAR	☐	Assignment Year of Commission Case/Document
33	RE_DOC_ID	CACS00_DOCSEDT	RE_DOC_ID		☐	CACSDOCID	☐	Document Identification
34	RE_REMUN_POS	CACS00_DOCSEDT	RE_REMUN_POS		☐	CACSREMUNPOS	☐	ID of Remuneration Row for Referenced Document

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

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