DFS_ASSGMT_SB1_D

Transparent Table Application Table
18 Fields 1 CDS Views

I_DFS_UNIVERSALASSIGNMENTTP I_DFS_UNIVERSALASSIGNMENTSB1TP

DFS_ASSGMT_SB1_D is an SAP database table in S/4HANA. I_DFS_UNIVERSALASSIGNMENTTP I_DFS_UNIVERSALASSIGNMENTSB1TP. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_DFS_UniversalAssgmtSubDrft1 view from BASIC Intf for accprt product drft data

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY dfsassgmtsubuuid DFS_ASSIGNMENT_UUID Assigment GUID
dfsassgmtuuid DFS_ASSIGNMENT_UUID Assigment GUID
flxblmatlplngobjvariantuuid DFS_VARIANTUUID Variant UUID
flxblmatlplngobjectuuid DFS_FMPOUUID FMPO UUID
flxmtplobjvaraccogpartassgmt DFS_ASGMNTINDICATOR Assignment Indicator
flxmtplobjvaraccogpartitem DFS_ACCPARTSID Accompaniment ID
flxmtplobjvariantaccogprtuuid DFS_ACCPARTSUUID Accompaniment Guid
product MATNR Material
flxmtplobjvaraccogprtinitqty DFS_INIT_REQ Initial Requirement
reorderthresholdquantity MINBE Reorder Point
activeuuid /BOBF/UUID Key
hasactiveentity SDRAFT_HAS_ACTIVE Has active
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code

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.

-- I_DFS_UNIVERSALASSIGNMENTTP I_DFS_UNIVERSALASSIGNMENTSB1TP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFS_ASSGMT_SB1_D (
    MANDT,                          -- Client [MANDT]
    DFSASSGMTSUBUUID,               -- Assigment GUID [DFS_ASSIGNMENT_UUID]
    DFSASSGMTUUID,                  -- Assigment GUID [DFS_ASSIGNMENT_UUID]
    FLXBLMATLPLNGOBJVARIANTUUID,    -- Variant UUID [DFS_VARIANTUUID]
    FLXBLMATLPLNGOBJECTUUID,        -- FMPO UUID [DFS_FMPOUUID]
    FLXMTPLOBJVARACCOGPARTASSGMT,   -- Assignment Indicator [DFS_ASGMNTINDICATOR]
    FLXMTPLOBJVARACCOGPARTITEM,     -- Accompaniment ID [DFS_ACCPARTSID]
    FLXMTPLOBJVARIANTACCOGPRTUUID,  -- Accompaniment Guid [DFS_ACCPARTSUUID]
    PRODUCT,                        -- Material [MATNR]
    FLXMTPLOBJVARACCOGPRTINITQTY,   -- Initial Requirement [DFS_INIT_REQ]
    REORDERTHRESHOLDQUANTITY,       -- Reorder Point [MINBE]
    ACTIVEUUID,                     -- Key [/BOBF/UUID]
    HASACTIVEENTITY,                -- Has active [SDRAFT_HAS_ACTIVE]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,   -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    PRIMARY KEY (MANDT, DFSASSGMTSUBUUID)
);

Learn More