RSADD

Transparent Table Application Table
42 Fields 4 CDS Views

Additional fields for reservation

RSADD is an SAP database table in S/4HANA. Additional fields for reservation. It contains 42 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
E_ProjectMaterialComponent view from EXTENSION Project Material Component - Extension Include View
I_MaintenanceOrderComponent view left_outer BASIC Maintenance Order Component
I_ProjectMaterialComponent view left_outer BASIC Project Material Component Details
I_ProjMatCompAdditionalData view from BASIC Additional Data for Proj Material Comp

Fields (42)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY rsnum RSNUM Reservation
KEY rspos RSPOS Item no.
KEY rsart RSART Record type
afnam AFNAM Requisitioner
bednr BEDNR Tracking Number
kzfix CN_KZFIX Price_fixed
kunnr EKUNNR Customer
emlif EMLIF Supplier
adrn2 AD_ADDRNUM Address Number
kalnr CK_KALNR Cost EstimateNo
klvar CK_KLVAR Costing Variant
wkurs WKURS Exchange Rate
rscomp RSCOMP Spare part
mflic CN_MFLIC Procurement
fplnr FPLNR Bill. Plan No.
flief FLIEF Fixed Vendor
bstln STNUM BOM
bstlt STLTY BOM category
stkan STKAN Edge in tree
guid SYSUUID_22 UUID 22 char.
guid_16 GUID_16 GUID 16
ekorg EKORG Purchasing Org.
sobsl SOBSL Special Procur.
strecke STRECKE 3rd party order
creadat ERDAT Created On
creaby ERNAM Created By
ppe_extern_key CHAR63 char63
changeby AENAM Changed By
changedat AEDAT Changed On
brtdate BRUTR Fixed Key Date
idnlf IDNLF Supp. Mat. No.
mfrpn MFRPN Mfr Part Number
mfrnr MFRNR Manufacturer
catalogid KATALOGID Catalog ID
catalog_prod_id CATALOG_PROD_ID Product ID
overalllimitamount SUMLIMIT Overall Limit
expectedoveralllimitamount COMMITMENT Expected Value
eew_rsadd_ps_dummy DUMMY Dummy function in length 1
mcn33 CHAR1 Single-Character Flag
adpic_ref_rspos ADPIC_D_REF_RSPOS Ref. Item
ind_adr XFELD Checkbox

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.

-- Additional fields for reservation
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RSADD (
    MANDT,                       -- Client [MANDT]
    RSNUM,                       -- Reservation [RSNUM]
    RSPOS,                       -- Item no. [RSPOS]
    RSART,                       -- Record type [RSART]
    AFNAM,                       -- Requisitioner [AFNAM]
    BEDNR,                       -- Tracking Number [BEDNR]
    KZFIX,                       -- Price_fixed [CN_KZFIX]
    KUNNR,                       -- Customer [EKUNNR]
    EMLIF,                       -- Supplier [EMLIF]
    ADRN2,                       -- Address Number [AD_ADDRNUM]
    KALNR,                       -- Cost EstimateNo [CK_KALNR]
    KLVAR,                       -- Costing Variant [CK_KLVAR]
    WKURS,                       -- Exchange Rate [WKURS]
    RSCOMP,                      -- Spare part [RSCOMP]
    MFLIC,                       -- Procurement [CN_MFLIC]
    FPLNR,                       -- Bill. Plan No. [FPLNR]
    FLIEF,                       -- Fixed Vendor [FLIEF]
    BSTLN,                       -- BOM [STNUM]
    BSTLT,                       -- BOM category [STLTY]
    STKAN,                       -- Edge in tree [STKAN]
    GUID,                        -- UUID 22 char. [SYSUUID_22]
    GUID_16,                     -- GUID 16 [GUID_16]
    EKORG,                       -- Purchasing Org. [EKORG]
    SOBSL,                       -- Special Procur. [SOBSL]
    STRECKE,                     -- 3rd party order [STRECKE]
    CREADAT,                     -- Created On [ERDAT]
    CREABY,                      -- Created By [ERNAM]
    PPE_EXTERN_KEY,              -- char63 [CHAR63]
    CHANGEBY,                    -- Changed By [AENAM]
    CHANGEDAT,                   -- Changed On [AEDAT]
    BRTDATE,                     -- Fixed Key Date [BRUTR]
    IDNLF,                       -- Supp. Mat. No. [IDNLF]
    MFRPN,                       -- Mfr Part Number [MFRPN]
    MFRNR,                       -- Manufacturer [MFRNR]
    CATALOGID,                   -- Catalog ID [KATALOGID]
    CATALOG_PROD_ID,             -- Product ID [CATALOG_PROD_ID]
    OVERALLLIMITAMOUNT,          -- Overall Limit [SUMLIMIT]
    EXPECTEDOVERALLLIMITAMOUNT,  -- Expected Value [COMMITMENT]
    EEW_RSADD_PS_DUMMY,          -- Dummy function in length 1 [DUMMY]
    MCN33,                       -- Single-Character Flag [CHAR1]
    ADPIC_REF_RSPOS,             -- Ref. Item [ADPIC_D_REF_RSPOS]
    IND_ADR,                     -- Checkbox [XFELD]
    PRIMARY KEY (MANDT, RSNUM, RSPOS, RSART)
);

Learn More