VDGPO

Loan: Relationship Partner/Role Object | #masterdata | Component: Loans Management
Column Name Description
MANDT FK Client
SNUMOBJ Key for number range object Show values
SOBJEKT Internal key for object for business partner table
PARTNR FK Business Partner Number
ROLETYP FK BP Role
DTRANS Flow data key: System date
Column Name Description
💲 Currency Key (SBBEZ):
BBEZ Relationship amount
Column Name Description
Column Name Description
DTRANS Flow data key: System date
DBEBEZ Date of start of relationship
DENBEZ Date of end of relationship
Column Name Description
SNUMOBJ Key for number range object Show values
SDUNNDOC Type of Dunning Letter Show values
SDUNNBUC Post Dunning Charges and Interest to This Partner Show values
Column Name Description Domain name
ADR_REF Address ID BU_ADRKIND
PBEZ Percentage rate of relationship DEC3_7
GZLSCH Payment method for credit memos ZLSCH
BVTYP Partner bank type BVTYP
ZLSCH Payment Method ZLSCH
NORDER Order Number NUM8
MNDID Unique Reference to Mandate for each Payee ID035
Master Data Relations Join Conditions
Business Partner: Application Area
  • VDGPO.MANDT == TPZ12.MANDT
  • VDGPO.APPL == TPZ12.APPL
Customer Number
  • VDGPO.MANDT == KNA1.MANDT
  • VDGPO.KUNNR == KNA1.KUNNR
Client VDGPO.MANDT == T000.MANDT
Correspondence Role Type in this Relationship
  • VDGPO.MANDT == TDPZ6.MANDT
  • VDGPO.ROLE == TDPZ6.ROLE
Currency Key
  • VDGPO.MANDT == TCURC.MANDT
  • VDGPO.SBBEZ == TCURC.WAERS