SAP Table V_T811IA (Generated Table for View V_T811IA)

SAP table V_T811IA has 6 primary key fields being MANDT,TAB,CYCLE,ALART,IPKNZ,FIELD.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
TAB Table Name CHAR 30 0 DBNAM
CYCLE Allocation/cycle CHAR 10 0 CYCLE
ALART Type of Allocation CHAR 1 0 ALART
B Process assessment
C Cross Company Assessment
F JV assessment
G JV distribution
K Top Down Distribution
L Indirect activity allocation
M ABC indirect activity allocation
P Periodic reposting
R Resource assessment
T Top down planning
U Assessment
V Distribution
IPKNZ Actual/plan indicator CHAR 1 0 IPKNZ
I Actual
P Plan
FIELD DB Field Name CHAR 30 0 FDNAM
CACT Is the allocation field active in the cycle? CHAR 1 0 CYACTIV
CSCACT Is the Allocation Field Active in Cycle Sender Control? CHAR 1 0 CSCACTIV
SCACT Is the allocation field active in the sender tracing factor? CHAR 1 0 SCACTIV
SACT Is the allocation field active in the sender? CHAR 1 0 SEACTIV
RACT Is the allocation field active in the receiver? CHAR 1 0 RACTIV
RCACT Is the allocation field active in receiver tracing factor? CHAR 1 0 RCACTIV
CSET Indicator: Allocation field ready for input as group CHAR 1 0 CSET
CSCSET Indicator: Allocation field ready for input as group CHAR 1 0 CSET
SCSET Indicator: Allocation field ready for input as group CHAR 1 0 CSET
SSET Indicator: Allocation field ready for input as group CHAR 1 0 CSET
RSET Indicator: Allocation field ready for input as group CHAR 1 0 CSET
RCSET Indicator: Allocation field ready for input as group CHAR 1 0 CSET
CSING Indicator: Allocation field ready for input as single value CHAR 1 0 CSING
CSCSING Indicator: Allocation field ready for input as single value CHAR 1 0 CSING
SCSING Indicator: Allocation field ready for input as single value CHAR 1 0 CSING
SSING Indicator: Allocation field ready for input as single value CHAR 1 0 CSING
RSING Indicator: Allocation field ready for input as single value CHAR 1 0 CSING
RCSING Indicator: Allocation field ready for input as single value CHAR 1 0 CSING
CINT Indicator:Allocation field is ready for input as an interval CHAR 1 0 CINT
CSCINT Indicator:Allocation field is ready for input as an interval CHAR 1 0 CINT
SCINT Indicator:Allocation field is ready for input as an interval CHAR 1 0 CINT
SINT Indicator:Allocation field is ready for input as an interval CHAR 1 0 CINT
RINT Indicator:Allocation field is ready for input as an interval CHAR 1 0 CINT
RCINT Indicator:Allocation field is ready for input as an interval CHAR 1 0 CINT

V_T811IA foreign key relationships

Table Field Check Table Check Field
0 V_T811IA MANDT T000 Clients MANDT