VTBLS

Limits: Mapping Logical - Physical Keys | #masterdata | Component: Limit Management
Column Name Description
MANDT FK Client
SLA FK Limit Type
RLV Number of Limit Record
SLH Hierarchy Level of Limit Record
Column Name Description
Column Name Description
Column Name Description
LLOCK Lock Date
Column Name Description
NOTES_EXIST Flag Showing if Notes Exist Show values
Column Name Description Domain name
CONTROL01 Monitoring Unit CHAR10
Master Data Relations Join Conditions
Company Code
  • VTBLS.MANDT == T001.MANDT
  • VTBLS.BUKRS == T001.BUKRS
Country/Region Key
  • Country/Region Key
  • Client
  • VTBLS.COUNTRY == T005.LAND1
  • VTBLS.MANDT == T005.MANDT
Rating Country/Region
Internal Organizational Unit
Limit Locked By
  • VTBLS.MANDT == USR02.MANDT
  • VTBLS.LLUSER == USR02.BNAME
Client VTBLS.MANDT == T000.MANDT
Rating
  • VTBLS.MANDT == TP06.MANDT
  • VTBLS.RATING == TP06.RATING
Group Country/Region
  • ?
  • Group Country/Region
Maturity Band in Credit Limit
  • ?
  • Maturity Band in Credit Limit
Free Characteristic 03
  • ?
  • Free Characteristic 03
Free Characteristic 04
  • ?
  • Free Characteristic 04
Free Characteristic 05
  • ?
  • Free Characteristic 05
Free Characteristic 06
  • ?
  • Free Characteristic 06
Free Characteristic 07
  • ?
  • Free Characteristic 07
Free Characteristic 08
  • ?
  • Free Characteristic 08
Free Characteristic 09
  • ?
  • Free Characteristic 09
Free Characteristic 10
  • ?
  • Free Characteristic 10
Free Characteristic 11
  • ?
  • Free Characteristic 11
Free Characteristic 12
  • ?
  • Free Characteristic 12
Free Characteristic 13
  • ?
  • Free Characteristic 13
Free Characteristic 14
  • ?
  • Free Characteristic 14
Free Characteristic 15
  • ?
  • Free Characteristic 15
Relevant Country/Region for Country/Region Risk
  • Relevant Country/Region for Country/Region Risk
  • Client
  • VTBLS.RCOUNTRY == T005.LAND1
  • VTBLS.MANDT == T005.MANDT
Portfolio
  • Company Code
  • Portfolio
  • Client
  • VTBLS.BUKRS == TWPOB.BUKRS
  • VTBLS.RPORTB == TWPOB.RPORTB
  • VTBLS.MANDT == TWPOB.MANDT
Industry of Business Partner
  • ?
  • Industry of Business Partner
  • Client
  • VTBLS.[column in domain "BU_ISTYPE"] == TB038A.ISTYPE
  • VTBLS.SECTOR == TB038A.IND_SECTOR
  • VTBLS.MANDT == TB038A.CLIENT
Limit Type
  • Limit Type
  • Client
  • VTBLS.SLA == ATLA.SLA
  • VTBLS.MANDT == ATLA.MANDT
Limit Product Group
  • Limit Product Group
  • Client
  • VTBLS.SLPG == ATLPG.SLPG
  • VTBLS.MANDT == ATLPG.MANDT
Currency as Limit Characteristic
  • VTBLS.MANDT == TCURC.MANDT
  • VTBLS.WAERS == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Trader
  • Company Code
  • Trader
  • Client
  • VTBLS.BUKRS == TZDEA.BUKRS
  • VTBLS.RDEALER == TZDEA.RDEALER
  • VTBLS.MANDT == TZDEA.MANDT