DFS_ALLWNC_REQ

Transparent Table Application Table
24 Fields 2 CDS Views

Allowance Request

DFS_ALLWNC_REQ is an SAP database table in S/4HANA. Allowance Request. It contains 24 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_DFS_AllwncReqBasic view from EXTENSION Ext. View for Allowance Request
I_DFS_AllwncReqBasic view from BASIC Interface View Allowance Request

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY dfsallwncrequuid DFS_ALLWNC_REQ_UUID Allowance Req UUID
dfsallwncreqid DFS_ALLWNC_REQ_ID Request ID
dfsallwncreqdescription DFS_ALLWNC_REQ_DESC Request Description
dfsallwncreqvaldtystrtdate DFS_VALID_START_DATE Valid From (Date)
dfsallwncreqvaldtyenddate DFS_VALID_END_DATE Valid To (Date)
flxblmatlplngobjectuuid DFS_FMPOUUID FMPO UUID
flxblmatlplngobjectid DFS_FMPOID FMPO ID
flxblmatlplngobjvariantuuid DFS_VARIANTUUID Variant UUID
flxblmatlplngobjvariantid DFS_VARIANTID Variant ID
product PRODUCTNUMBER Product
forceelementorguuid /ISDFPS/FORCE_ID GUID 32
forceelementorgid HROBJID Object ID
dfsallwncreqcreationdatetime TIMESTAMPL Time Stamp
dfsallwncreqcreatedbyuser DFS_CREATEDBY Created By
dfsallwncreqchangedatetime TIMESTAMPL Time Stamp
dfsallwncreqlastchgdbyuser DFS_CHANGEDBY Changed By
dfsallwncreqcomment DFS_COMMENT Comment
dfsallwncreqquantityunit MEINS Base Unit
dfsallwncreqreqdquantity DFS_ALLWNC_REQ_REQD_QTY Requested Quantity
dfsallwncreqbasetype DFS_ALLWNC_REQ_BASE_TYPE Base Type
frcelmntorgusagetype /ISDFPS/CASE_TYPE Usage Type
dfsallwncreqduedate DFS_VALID_DUE_DATE Due By
dummy_allwnc_req_incl_eew_ps CFD_DUMMY Dummy

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.

-- Allowance Request
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFS_ALLWNC_REQ (
    CLIENT,                        -- Client [MANDT]
    DFSALLWNCREQUUID,              -- Allowance Req UUID [DFS_ALLWNC_REQ_UUID]
    DFSALLWNCREQID,                -- Request ID [DFS_ALLWNC_REQ_ID]
    DFSALLWNCREQDESCRIPTION,       -- Request Description [DFS_ALLWNC_REQ_DESC]
    DFSALLWNCREQVALDTYSTRTDATE,    -- Valid From (Date) [DFS_VALID_START_DATE]
    DFSALLWNCREQVALDTYENDDATE,     -- Valid To (Date) [DFS_VALID_END_DATE]
    FLXBLMATLPLNGOBJECTUUID,       -- FMPO UUID [DFS_FMPOUUID]
    FLXBLMATLPLNGOBJECTID,         -- FMPO ID [DFS_FMPOID]
    FLXBLMATLPLNGOBJVARIANTUUID,   -- Variant UUID [DFS_VARIANTUUID]
    FLXBLMATLPLNGOBJVARIANTID,     -- Variant ID [DFS_VARIANTID]
    PRODUCT,                       -- Product [PRODUCTNUMBER]
    FORCEELEMENTORGUUID,           -- GUID 32 [/ISDFPS/FORCE_ID]
    FORCEELEMENTORGID,             -- Object ID [HROBJID]
    DFSALLWNCREQCREATIONDATETIME,  -- Time Stamp [TIMESTAMPL]
    DFSALLWNCREQCREATEDBYUSER,     -- Created By [DFS_CREATEDBY]
    DFSALLWNCREQCHANGEDATETIME,    -- Time Stamp [TIMESTAMPL]
    DFSALLWNCREQLASTCHGDBYUSER,    -- Changed By [DFS_CHANGEDBY]
    DFSALLWNCREQCOMMENT,           -- Comment [DFS_COMMENT]
    DFSALLWNCREQQUANTITYUNIT,      -- Base Unit [MEINS]
    DFSALLWNCREQREQDQUANTITY,      -- Requested Quantity [DFS_ALLWNC_REQ_REQD_QTY]
    DFSALLWNCREQBASETYPE,          -- Base Type [DFS_ALLWNC_REQ_BASE_TYPE]
    FRCELMNTORGUSAGETYPE,          -- Usage Type [/ISDFPS/CASE_TYPE]
    DFSALLWNCREQDUEDATE,           -- Due By [DFS_VALID_DUE_DATE]
    DUMMY_ALLWNC_REQ_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (CLIENT, DFSALLWNCREQUUID)
);

Learn More