DFS_RELOC_STEP

Transparent Table Application Table
38 Fields 2 CDS Views

Defense Relocation Steps

DFS_RELOC_STEP is an SAP database table in S/4HANA. Defense Relocation Steps. It contains 38 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_DFS_RelocationStepPlanning view_entity from EXTENSION Relocation Step Planning - Extension
I_DFS_RelocationStepPlngBsc view_entity from BASIC Basic List for Relocation Step Plan

Fields (38)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY defenserelocationstepplnguuid DFS_RELOC_STEP_PLNG_UUID Reloc Step Plng GUID
defenserelocationplanninguuid DFS_RELOC_PLNG_UUID Reloc Planning GUID
wbselementinternalid DFS_PSPNR WBS Internal ID
dfsrelocationnmbrofassgdmatl DFS_RELOC_QUANTITY Relocation Quantity
flxblmatlplngobjectuuid DFS_FMPOUUID FMPO UUID
flxblmatlplngobjvariantuuid DFS_VARIANTUUID Variant UUID
flxblmatlplngobjectid DFS_FMPOID FMPO ID
flxblmatlplngobjvariantid DFS_VARIANTID Variant ID
dfsassgmtuuid DFS_ASSIGNMENT_UUID Assigment GUID
dfsassgmtsubuuid DFS_ASSIGNMENT_UUID Assigment GUID
dfsrelocationisassgmtinactive DFS_BOOLE TRUE
dfsrelocationisassgmtdeleted DFS_BOOLE TRUE
product PRODUCTNUMBER Product
materialgroup MATKL Material Group
purchaserequisition BANFN Purchase Req.
dfsrelocationdocumenttype DFS_RELOC_DOCTYP Reloc. Doc. Type
dfsrelocationwbselementintid DFS_PSPNR WBS Internal ID
materialbaseunit MEINS Base Unit
forceelementorgsrceid HROBJID Object ID
forceelementorgsrceuuid /ISDFPS/FORCE_ID GUID 32
frcelmntorgstockplant WERKS_D Plant
frcelmntorgstockstorageloc LGORT_D Location
frcelmntorgmrpstockarea /ISDFPS/BERID_S MRP Stock Area
defenselogisticsadvice /ISDFPS/ADVCODE Advice Code
dfspurchaserequisitionstatus /ISDFPS/STACODE StatusCode
forceelementorgtargetuuid /ISDFPS/FORCE_ID GUID 32
forceelementorgtargetid HROBJID Object ID
plant WERKS_D Plant
storagelocation LGORT_D Location
mrpcontroller DISPO MRP Controller
dfslogisticsrqmturgency PRIO_URG Reqmt Urgency
batch CHARG_D Batch
creationdatetime DFS_CREATEDON Created On
createdbyuser DFS_CREATEDBY Created By
lastchangedatetime DFS_CHANGEDON Changed On
lastchangedbyuser DFS_CHANGEDBY Changed By
dummy_reloc_step_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.

-- Defense Relocation Steps
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFS_RELOC_STEP (
    CLIENT,                         -- Client [MANDT]
    DEFENSERELOCATIONSTEPPLNGUUID,  -- Reloc Step Plng GUID [DFS_RELOC_STEP_PLNG_UUID]
    DEFENSERELOCATIONPLANNINGUUID,  -- Reloc Planning GUID [DFS_RELOC_PLNG_UUID]
    WBSELEMENTINTERNALID,           -- WBS Internal ID [DFS_PSPNR]
    DFSRELOCATIONNMBROFASSGDMATL,   -- Relocation Quantity [DFS_RELOC_QUANTITY]
    FLXBLMATLPLNGOBJECTUUID,        -- FMPO UUID [DFS_FMPOUUID]
    FLXBLMATLPLNGOBJVARIANTUUID,    -- Variant UUID [DFS_VARIANTUUID]
    FLXBLMATLPLNGOBJECTID,          -- FMPO ID [DFS_FMPOID]
    FLXBLMATLPLNGOBJVARIANTID,      -- Variant ID [DFS_VARIANTID]
    DFSASSGMTUUID,                  -- Assigment GUID [DFS_ASSIGNMENT_UUID]
    DFSASSGMTSUBUUID,               -- Assigment GUID [DFS_ASSIGNMENT_UUID]
    DFSRELOCATIONISASSGMTINACTIVE,  -- TRUE [DFS_BOOLE]
    DFSRELOCATIONISASSGMTDELETED,   -- TRUE [DFS_BOOLE]
    PRODUCT,                        -- Product [PRODUCTNUMBER]
    MATERIALGROUP,                  -- Material Group [MATKL]
    PURCHASEREQUISITION,            -- Purchase Req. [BANFN]
    DFSRELOCATIONDOCUMENTTYPE,      -- Reloc. Doc. Type [DFS_RELOC_DOCTYP]
    DFSRELOCATIONWBSELEMENTINTID,   -- WBS Internal ID [DFS_PSPNR]
    MATERIALBASEUNIT,               -- Base Unit [MEINS]
    FORCEELEMENTORGSRCEID,          -- Object ID [HROBJID]
    FORCEELEMENTORGSRCEUUID,        -- GUID 32 [/ISDFPS/FORCE_ID]
    FRCELMNTORGSTOCKPLANT,          -- Plant [WERKS_D]
    FRCELMNTORGSTOCKSTORAGELOC,     -- Location [LGORT_D]
    FRCELMNTORGMRPSTOCKAREA,        -- MRP Stock Area [/ISDFPS/BERID_S]
    DEFENSELOGISTICSADVICE,         -- Advice Code [/ISDFPS/ADVCODE]
    DFSPURCHASEREQUISITIONSTATUS,   -- StatusCode [/ISDFPS/STACODE]
    FORCEELEMENTORGTARGETUUID,      -- GUID 32 [/ISDFPS/FORCE_ID]
    FORCEELEMENTORGTARGETID,        -- Object ID [HROBJID]
    PLANT,                          -- Plant [WERKS_D]
    STORAGELOCATION,                -- Location [LGORT_D]
    MRPCONTROLLER,                  -- MRP Controller [DISPO]
    DFSLOGISTICSRQMTURGENCY,        -- Reqmt Urgency [PRIO_URG]
    BATCH,                          -- Batch [CHARG_D]
    CREATIONDATETIME,               -- Created On [DFS_CREATEDON]
    CREATEDBYUSER,                  -- Created By [DFS_CREATEDBY]
    LASTCHANGEDATETIME,             -- Changed On [DFS_CHANGEDON]
    LASTCHANGEDBYUSER,              -- Changed By [DFS_CHANGEDBY]
    DUMMY_RELOC_STEP_INCL_EEW_PS,   -- Dummy [CFD_DUMMY]
    PRIMARY KEY (CLIENT, DEFENSERELOCATIONSTEPPLNGUUID)
);

Learn More