/SAPSLL/CLSNR

Transparent Table Application Table
14 Fields 3 CDS Views

Trade Classification Number

/SAPSLL/CLSNR is an SAP database table in S/4HANA. Trade Classification Number. It contains 14 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
CLS_C_T604 view from Proxy Object for T604
I_TrdClassfctnNmbr view from BASIC Number
nsdm_e_marc view left_outer MARC Compatibility View

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY nosct /SAPSLL/NOSCT No. Scheme Content
KEY ccngn /SAPSLL/CCNGN Number
KEY datab /SAPSLL/DATAB Valid From
datbi /SAPSLL/DATBI Valid To
tcnid /SAPSLL/TCNID Trade Cls. Number ID
bemeh BEMEH 1st Unit
beme2 /SAPSLL/BEME2 2nd Unit
cuom1 /SAPSLL/CUOM1 1st Customs Unit
cuom2 /SAPSLL/CUOM2 2nd Customs Unit
ernam /SAPSLL/ERNAM_ITR Created By
crtsp /SAPSLL/CRTSP_ITR Created At
aenam /SAPSLL/AENAM_ITR Changed By
chtsp /SAPSLL/CHTSP_ITR Changed At

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Trade Classification Number
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SAPSLL/CLSNR (
    MANDT,  -- Client [MANDT]
    NOSCT,  -- No. Scheme Content [/SAPSLL/NOSCT]
    CCNGN,  -- Number [/SAPSLL/CCNGN]
    DATAB,  -- Valid From [/SAPSLL/DATAB]
    DATBI,  -- Valid To [/SAPSLL/DATBI]
    TCNID,  -- Trade Cls. Number ID [/SAPSLL/TCNID]
    BEMEH,  -- 1st Unit [BEMEH]
    BEME2,  -- 2nd Unit [/SAPSLL/BEME2]
    CUOM1,  -- 1st Customs Unit [/SAPSLL/CUOM1]
    CUOM2,  -- 2nd Customs Unit [/SAPSLL/CUOM2]
    ERNAM,  -- Created By [/SAPSLL/ERNAM_ITR]
    CRTSP,  -- Created At [/SAPSLL/CRTSP_ITR]
    AENAM,  -- Changed By [/SAPSLL/AENAM_ITR]
    CHTSP,  -- Changed At [/SAPSLL/CHTSP_ITR]
    PRIMARY KEY (MANDT, NOSCT, CCNGN, DATAB)
);

Learn More