SAP ABAP View V_CACS_TGSTAGTF4 (Tgt Agmts: Help View for Standard Agreements)
Hierarchy
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ICM (Application Component) Incentive and Commission Management (ICM)
     CACST3 (Package) ICM: Target Agreements Persistence
Basic Data
View Type D Database View 
Database View V_CACS_TGSTAGTF4  
Short Description Tgt Agmts: Help View for Standard Agreements    
Root table CACS_STCAGR   Standard agreement for commission contract 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 CACS_STCAGR CACS_STCAGR
2 CACS_STCAGRT  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 CACS_STCAGR MANDT JL EQ 0 0
2 CACS_STCAGRT MANDT JR EQ AND 0 0
3 CACS_STCAGR APPL JL EQ 0 0
4 CACS_STCAGRT APPL JR EQ AND 0 0
5 CACS_STCAGR AGR_TYP JL EQ 0 0
6 CACS_STCAGRT AGR_TYP JR EQ AND 0 0
7 CACS_STCAGR STCAGR_ID JL EQ 0 0
8 CACS_STCAGRT STCAGR_ID JR EQ AND 0 0
9 CACS_STCAGR AGR_TYP EQ '26' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT CACS_STCAGR MANDT   MANDT Client
2 APPL CACS_STCAGR APPL   CACSAPPL Commission Application (ICM)
3 AGR_TYP CACS_STCAGR AGR_TYP   CACS_AGR_TYP Agreement Type
4 STCAGR_ID CACS_STCAGR STCAGR_ID   CACS_STCAGR_ID Standard Agreement Number
5 VERSION CACS_STCAGR VERSION   CACSVERSION Version of Master Data or Customizing Object
6 FLG_FIRST CACS_STCAGR FLG_FIRST   CACS_FLG_FIRST Priority of Global Agreement
7 BUSI_BEGIN CACS_STCAGR BUSI_BEGIN   CACS_BUSITIME_B Effective from
8 BUSI_END CACS_STCAGR BUSI_END   CACS_BUSITIME_E Effective Until (Time Stamp: YYYY.MM.DD hh:mm:ss)
9 TECH_BEGIN CACS_STCAGR TECH_BEGIN   CACS_TECHTIME_B Technically Valid From
10 TECH_END CACS_STCAGR TECH_END   CACS_TECHTIME_E Technically Valid To (Time Stamp: JJJJ.MM.TT hh:mm:ss)
11 FLG_CANCEL_OBJ CACS_STCAGR FLG_CANCEL_OBJ   CACSCANCOBJ Indicator: Object is Invalid
12 FLG_CANCEL_VERS CACS_STCAGR FLG_CANCEL_VERS   CACSCANCVERS Indicator: Version is Invalid
13 CHG_TCODE CACS_STCAGR CHG_TCODE   CACSCDTC Transaction in Which the Change Was Made
14 CHG_USR CACS_STCAGR CHG_USR   CACSCHUSR Last user to change object
15 TRI_METH_TYP CACS_STCAGR TRI_METH_TYP   CACSTRIMETHTYP Triggering Method
16 TRI_METH_TARGET CACS_STCAGR TRI_METH_TARGET   CACSTRIMETHTAR Processing Target of Triggering Method
17 STATUS_VERSION CACS_STCAGR STATUS_VERSION   CACSSTATUSVERS Object Version Status
18 STATUS_WORK CACS_STCAGR STATUS_WORK   CACSSTATUSWORK Object Version Processing Status
19 COMBTP_ID CACS_STCAGR COMBTP_ID   CACS_COMBTP_ID Number of Characteristics Combination Type
20 STCAGR_ID_XL CACS_STCAGR STCAGR_ID_XL   CACS_CTRTID_XL Obsolete: Agreement Number Including Contract Type Indicator
21 NAME CACS_STCAGRT NAME   CACSSTCAGRTX Name of Standard Agreement
22 SPRAS CACS_STCAGRT SPRAS   SPRAS Language Key
23 UNIVERSAL CACS_STCAGR UNIVERSAL   CACS_STD_UNIVERSAL Indicator: Agreement is Universally Valid
                 
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 600