DFS_ALLWNC_PLAN

Transparent Table Application Table
30 Fields 2 CDS Views

Allowance Plan

DFS_ALLWNC_PLAN is an SAP database table in S/4HANA. Allowance Plan. It contains 30 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_DFS_AllwncPlanBasic view from EXTENSION Ext. View for Allowance Plan
I_DFS_AllwncPlanBasic view from BASIC Basic Interface View Allowance Plan

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY dfsallwncplanuuid DFS_ALLWNC_PLAN_UUID Allowance Plan UUID
dfsallwncplanid DFS_ALLWNC_PLAN_ID Plan ID
dfsallwncplandescription DFS_ALLWNC_PLAN_DESC Plan Description
dfsallwncplanvaldtystrtdate DFS_VALID_START_DATE Valid From (Date)
dfsallwncplanvaldtyenddate 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
dfsallwncplanbasetype DFS_ALLWNC_PLAN_BASE_TYPE Base Type
dfsallwncplanstatusprofile J_STSMA Status Profile
dfsallwncplanstatusobject DFS_OBJNR Object Number
dfsallwncplanstatuscode J_STATUS Status
forceelementorguuid /ISDFPS/FORCE_ID GUID 32
forceelementorgid HROBJID Object ID
dfsallwncplanallowedquantity DFS_ALLWNC_PLAN_ALLWD_QTY Allowed Quantity
dfsallwncplanquantityunit MEINS Base Unit
frcelmntorgusagetype /ISDFPS/CASE_TYPE Usage Type
dfsallwncplanmultilevel DFS_ALLWNCPLNMULTILVL Level for Plan
dfsallwncplanpreviousplanuuid DFS_ALLWNCPLAN_PREVPLAN_UUID Previous Plan
dfsallwncplaniscompleted DFS_ALLWNCPLAN_COMPLETED Plan Completed
dfsallwncplancomment DFS_COMMENT Comment
dfsallwncrequuid DFS_ALLWNC_REQ_UUID Allowance Req UUID
dfsallwncplancreationdatetime TIMESTAMPL Time Stamp
dfsallwncplancreatedbyuser DFS_CREATEDBY Created By
dfsallwncplanchangedatetime TIMESTAMPL Time Stamp
dfsallwncplanlastchgdbyuser DFS_CHANGEDBY Changed By
dummy_allwnc_plan_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 Plan
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFS_ALLWNC_PLAN (
    CLIENT,                         -- Client [MANDT]
    DFSALLWNCPLANUUID,              -- Allowance Plan UUID [DFS_ALLWNC_PLAN_UUID]
    DFSALLWNCPLANID,                -- Plan ID [DFS_ALLWNC_PLAN_ID]
    DFSALLWNCPLANDESCRIPTION,       -- Plan Description [DFS_ALLWNC_PLAN_DESC]
    DFSALLWNCPLANVALDTYSTRTDATE,    -- Valid From (Date) [DFS_VALID_START_DATE]
    DFSALLWNCPLANVALDTYENDDATE,     -- 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]
    DFSALLWNCPLANBASETYPE,          -- Base Type [DFS_ALLWNC_PLAN_BASE_TYPE]
    DFSALLWNCPLANSTATUSPROFILE,     -- Status Profile [J_STSMA]
    DFSALLWNCPLANSTATUSOBJECT,      -- Object Number [DFS_OBJNR]
    DFSALLWNCPLANSTATUSCODE,        -- Status [J_STATUS]
    FORCEELEMENTORGUUID,            -- GUID 32 [/ISDFPS/FORCE_ID]
    FORCEELEMENTORGID,              -- Object ID [HROBJID]
    DFSALLWNCPLANALLOWEDQUANTITY,   -- Allowed Quantity [DFS_ALLWNC_PLAN_ALLWD_QTY]
    DFSALLWNCPLANQUANTITYUNIT,      -- Base Unit [MEINS]
    FRCELMNTORGUSAGETYPE,           -- Usage Type [/ISDFPS/CASE_TYPE]
    DFSALLWNCPLANMULTILEVEL,        -- Level for Plan [DFS_ALLWNCPLNMULTILVL]
    DFSALLWNCPLANPREVIOUSPLANUUID,  -- Previous Plan [DFS_ALLWNCPLAN_PREVPLAN_UUID]
    DFSALLWNCPLANISCOMPLETED,       -- Plan Completed [DFS_ALLWNCPLAN_COMPLETED]
    DFSALLWNCPLANCOMMENT,           -- Comment [DFS_COMMENT]
    DFSALLWNCREQUUID,               -- Allowance Req UUID [DFS_ALLWNC_REQ_UUID]
    DFSALLWNCPLANCREATIONDATETIME,  -- Time Stamp [TIMESTAMPL]
    DFSALLWNCPLANCREATEDBYUSER,     -- Created By [DFS_CREATEDBY]
    DFSALLWNCPLANCHANGEDATETIME,    -- Time Stamp [TIMESTAMPL]
    DFSALLWNCPLANLASTCHGDBYUSER,    -- Changed By [DFS_CHANGEDBY]
    DUMMY_ALLWNC_PLAN_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (CLIENT, DFSALLWNCPLANUUID)
);

Learn More