T5FDSNOPSID - List of OPS (Social Protection Agencies)

List of OPS (Social Protection Agencies) information is stored in SAP table T5FDSNOPSID.
It is part of development package P06_DSN in software component PY-FR. This development package consists of objects that can be grouped under "Package for Nominative Social Declaration (DSN)".

Fields for table T5FDSNOPSID

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
OPSIDIdentifier of an OPS (Social Protection Agency)XP06_DSN_OPS_IDNUMC10
ENDDAEnd DateXENDDADATS16
BEGDAStart DateBEGDADATS16
TYPIDType of OPS (Social Protection Agency)P06_DSN_OPS_TYPE_IDCHAR6T5FDSNOPSTY
SHORTText for an OPS (Social Protection Agency)P06_DSN_OPS_ID_COURTCHAR40
DESCRDescription of an OPS (Social Protection Agency)P06_DSN_OPS_ID_DESCRCHAR100
SIRENSIREN numberP06_SIRENCHAR18
NUMICNICP06_NUMICCHAR10
CODINInternal indicator of an OPS (Social Protection Agency)P06_DSN_OPS_CODE_INTCHAR8
NUMEMNational Sender No. (NNE) of an OPS (Soc.Protection Agency)P06_DSN_OPS_NUM_EMETTEURNUMC12
ADDR1Street and House NumberSTRASCHAR60
ADDR2Street and House NumberSTRASCHAR60
PSTLZPostal CodePSTLZCHAR20
ORT01CityORT01CHAR50
ORG_PREVPension agency indicatorP06DAD_ORG_PRVCHAR18T5F1AF
ORG_GESTDelegatee management codeP06DAD_ODESTCHAR34
CIBTPOperation assignment entity S21.G00.20.002P06_DSN_VEENTCHAR28
VEENTOperation assignment entity S21.G00.20.002P06_DSN_VEENTCHAR28
VEMODPayment typeP06_DSN_PAYMENT_MODE_VCHAR4
UIDPMOPS: Unique ID of payment (attributes)P06_OPS_UNIQUE_ID_PAYMENTCHAR60
DSNID"DSN" ID for soc.protect.agency (OPS) (field 20.001/81.002)P06_DSN_OPS_DSN_IDCHAR28
MOPERFrequency modifier groupingP06_DSN_PAYMENT_GROUPINGCHAR8
IBANIBAN (International Bank Account Number)IBANCHAR68
Privacy Policy