T5FDSNOPSID

List of OPS (Social Protection Agencies) | #other | Component: France
Column Name Description
MANDT Client
OPSID Identifier of an OPS (Social Protection Agency)
ENDDA End Date
Column Name Description
Column Name Description
Column Name Description
ENDDA End Date
BEGDA Start Date
Column Name Description
VEMOD Payment type Show values
Column Name Description Domain name
SHORT Text for an OPS (Social Protection Agency) P06_DSN_OPS_TYPE_COURT
DESCR Description of an OPS (Social Protection Agency) P06_DSN_OPS_TYPE_DESCR
SIREN SIREN number
NUMIC NIC CHAR5
CODIN Internal indicator of an OPS (Social Protection Agency)
NUMEM National Sender No. (NNE) of an OPS (Soc.Protection Agency)
ADDR1 Street and House Number TEXT30
ADDR2 Street and House Number TEXT30
PSTLZ Postal Code PSTLZ
ORT01 City TEXT25
ORG_GEST Delegatee management code CHAR17
CIBTP Operation assignment entity S21.G00.20.002
VEENT Operation assignment entity S21.G00.20.002
UIDPM OPS: Unique ID of payment (attributes) P06_OPS_UNIQUE_ID_PAYMENT
DSNID "DSN" ID for soc.protect.agency (OPS) (field 20.001/81.002)
MOPER Frequency modifier grouping CHAR4
IBAN IBAN (International Bank Account Number) IBAN
Master Data Relations Join Conditions
Pension agency indicator
  • T5FDSNOPSID.MANDT == T5F1AF.MANDT
  • T5FDSNOPSID.ORG_PREV == T5F1AF.ORG_CODE
Other Relations Join Conditions
Type of OPS (Social Protection Agency)
  • Type of OPS (Social Protection Agency)
  • ?