1. Home
  2. Resources
  3. SAP Tables
  4. KNEX - Customer Master: Legal Control - Sanctioned Party List

SAP Table KNEX

Customer Master: Legal Control - Sanctioned Party List

KNEX (Customer Master: Legal Control - Sanctioned Party List) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link KNEX to other SAP tables.

KNEX table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
LNDEX Country key for export control in customer master LNDEX T005 CHAR 3 0
TDOCO ID: TDO boycott list for export control TDOCO CHAR 1 0
X Yes
NULL No
TDODA Date of last check of TDO list for export control TDODA DATS 8 0
SDNCO ID: SDN boycott list for export control SDNCO CHAR 1 0
X Yes
NULL No
SDNDA Date of last check of SDN list for export control SDNDA DATS 8 0
DHRCO ID: Customer boycott list for export control DHRCO CHAR 1 0
X Yes
NULL No
DHRDA Date of last check in inter. boycott list for exp. control DHRDA DATS 8 0
BL1CO Indicator: Reserve boycott list 1 for legal control BL1CO CHAR 1 0
X Yes
NULL No
BL1DA Date of last BL1 check for legal control BL1DA DATS 8 0
BL2CO Indicator: Reserve boycott list 2 for legal control BL2CO CHAR 1 0
X Yes
NULL No
BL2DA Date of last BL2 check for legal control BL2DA DATS 8 0
SLSCO Indicator: Sanctioned party list in legal control SLSCO CHAR 1 0
X Yes
NULL No
SLDCK Date of last SLS check for sanctioned party list SLDCK DATS 8 0
SLDST Validity start date of entry in sanctioned party list SLDST DATS 8 0
SLDEN Validity end date of entry in sanctioned party list SLDEN DATS 8 0
TDOST Validity start date of entry in sanctioned party list SLDST DATS 8 0
TDOEN Validity end date of entry in sanctioned party list SLDEN DATS 8 0
SDNST Validity start date of entry in sanctioned party list SLDST DATS 8 0
SDNEN Validity end date of entry in sanctioned party list SLDEN DATS 8 0
DHRST Validity start date of entry in sanctioned party list SLDST DATS 8 0
DHREN Validity end date of entry in sanctioned party list SLDEN DATS 8 0
BL1ST Validity start date of entry in sanctioned party list SLDST DATS 8 0
BL1EN Validity end date of entry in sanctioned party list SLDEN DATS 8 0
BL2ST Validity start date of entry in sanctioned party list SLDST DATS 8 0
BL2EN Validity end date of entry in sanctioned party list SLDEN DATS 8 0

KNEX foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
KNEX KUNNR KNEX MANDT KNA1 General Data in Customer Master MANDT
KNEX KUNNR KNEX KUNNR KNA1 General Data in Customer Master KUNNR
KNEX LNDEX KNEX MANDT T005 Countries MANDT
KNEX LNDEX KNEX LNDEX T005 Countries LAND1
KNEX MANDT KNEX MANDT T000 Clients MANDT