P05FBN_DLVR_EIG

Characteristics of Target Variants | #other | Component: Netherlands

🔑 Keys (6)
💰 Amounts (3)
∑ Quantities
📅 Dates (2)
☰ Categorical
Other (3)
🔗 Relations (5)

Column Name	Description
MANDT FK	Client
BAREA FK	Benefit area
DOEL FK	Note
DLVRT FK	Target Variant
BSTGR FK	Spending Group
ENDDA	End Date

Column Name	Description
💲 Currency Key (T500C.WAERS):
VASTB	Fixed Amount
MINTB	Minimum Amount
MAXTB	Maximum Amount

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date

Column Name	Description

Column Name	Description	Domain name
VASTA	Fixed Number	DEC3_2
MINTA	Minimum Number	DEC3_2
MAXTA	Maximum Number	DEC3_2

Master Data Relations	Join Conditions
Benefit area Benefit area Client	`P05FBN_DLVR_EIG.BAREA == T5UB3.BAREA` `P05FBN_DLVR_EIG.MANDT == T5UB3.MANDT`
Spending Group Spending Group Benefit area	`P05FBN_DLVR_EIG.MANDT == P05FBN_BSTGRP.MANDT` `P05FBN_DLVR_EIG.BSTGR == P05FBN_BSTGRP.BSTGR` `P05FBN_DLVR_EIG.BAREA == P05FBN_BSTGRP.BAREA`
Target Variant Note Target Variant Benefit area	`P05FBN_DLVR_EIG.MANDT == P05FBN_DOELVRT.MANDT` `P05FBN_DLVR_EIG.DOEL == P05FBN_DOELVRT.DOEL` `P05FBN_DLVR_EIG.DLVRT == P05FBN_DOELVRT.DLVRT` `P05FBN_DLVR_EIG.BAREA == P05FBN_DOELVRT.BAREA`
Note Note Benefit area Client ?	`P05FBN_DLVR_EIG.DOEL == T5UBA.BPLAN` `P05FBN_DLVR_EIG.BAREA == T5UBA.BAREA` `P05FBN_DLVR_EIG.MANDT == T5UBA.MANDT` `P05FBN_DLVR_EIG.[column in domain "ENDDA"] == T5UBA.ENDDA`
Client	`P05FBN_DLVR_EIG.MANDT == T000.MANDT`