EAM_PLNGBKTSCPD

Transparent Table Application Table

Draft Table for EAM_PLNGBKTSCP

EAM_PLNGBKTSCPD is an SAP database table in S/4HANA. Draft Table for EAM_PLNGBKTSCP. It contains 44 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_MaintPlngBucketScopeDraft view_entity from EXTENSION Maint Planning Bucket Scope Value - Extn
R_MaintPlngBcktScopeValueDraft view_entity from BASIC Maint plng bckt scope name draft data

Fields (44)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY maintplanningbucketscopeuuid SYSUUID_X UUID
maintplanningbucketuuid SYSUUID_X UUID
maintplngbcktscprangefieldname FIELDNAME Field Name
maintplngbucketscopergsg TVARV_SIGN INCL/EXCL
maintplngbucketscopergop TVARV_OPTI Option
maintplngbucketscopergfr RVARI_VAL_255 Field Value
maintplngbucketscopergto RVARI_VAL_255 Field Value
maintenanceplanningplant IWERK Planning Plant
maintenanceplannergroup EAM_PLANNER_GROUP Planner Group
maintenanceplannergroupname EAM_PLANNER_GROUP_NAME Planner Group Name
maintenanceplant EAMS_MAINTPLANT Maint. Plant
plantsection BEBER Plant Section
plantsectionpersonrespname FING GrpResp.
mainworkcenter EAM_MAIN_WORK_CENTER Main Work Center
workcenterinternalid CR_OBJID Object ID
mainworkcentertext WORKCENTERTEXT Work Center Text
equipment EQUNR Equipment
equipmentname EAMS_TEC_OBJ_DES Tech. Obj. Desc
functionallocation VDM_EAM_TPLNR Functional Location
functionallocationname PLTXT Description
abcindicator ABCKZ ABC Indic.
assetlocation STORT Location
maintenanceactivitytype EAM_MAINT_ACTIVITY_TYPE Activity Type
operationsystemcondition ANLZU SystemCondition
locationname LOCATIONNAME Location Name
operationsystemconditiontext ANLZUX Text
assetmanufacturername HERST Manufacturer
costcenter KOSTL Cost Center
workcenter PPH_ARBPL Work Center
wbselement PS_POSID_EDIT WBS Element
wbselementinternalid PS_S4_PSPNR WBS Internal ID
technicalobjecttype EQART Object Type
functionallocationlabelname ILOM_STRNO Functional Loc.
mainworkcenterplant WERKS_D Plant
maintorderprocessingcontext MAINTORDERPROCESSINGCONTEXT Processing Context
soldtoparty KUNAG Sold-to Party
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes
dummy_mpbkt_sc_val_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.

-- Draft Table for EAM_PLNGBKTSCP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EAM_PLNGBKTSCPD (
    MANDT,                           -- Client [MANDT]
    MAINTPLANNINGBUCKETSCOPEUUID,    -- UUID [SYSUUID_X]
    MAINTPLANNINGBUCKETUUID,         -- UUID [SYSUUID_X]
    MAINTPLNGBCKTSCPRANGEFIELDNAME,  -- Field Name [FIELDNAME]
    MAINTPLNGBUCKETSCOPERGSG,        -- INCL/EXCL [TVARV_SIGN]
    MAINTPLNGBUCKETSCOPERGOP,        -- Option [TVARV_OPTI]
    MAINTPLNGBUCKETSCOPERGFR,        -- Field Value [RVARI_VAL_255]
    MAINTPLNGBUCKETSCOPERGTO,        -- Field Value [RVARI_VAL_255]
    MAINTENANCEPLANNINGPLANT,        -- Planning Plant [IWERK]
    MAINTENANCEPLANNERGROUP,         -- Planner Group [EAM_PLANNER_GROUP]
    MAINTENANCEPLANNERGROUPNAME,     -- Planner Group Name [EAM_PLANNER_GROUP_NAME]
    MAINTENANCEPLANT,                -- Maint. Plant [EAMS_MAINTPLANT]
    PLANTSECTION,                    -- Plant Section [BEBER]
    PLANTSECTIONPERSONRESPNAME,      -- GrpResp. [FING]
    MAINWORKCENTER,                  -- Main Work Center [EAM_MAIN_WORK_CENTER]
    WORKCENTERINTERNALID,            -- Object ID [CR_OBJID]
    MAINWORKCENTERTEXT,              -- Work Center Text [WORKCENTERTEXT]
    EQUIPMENT,                       -- Equipment [EQUNR]
    EQUIPMENTNAME,                   -- Tech. Obj. Desc [EAMS_TEC_OBJ_DES]
    FUNCTIONALLOCATION,              -- Functional Location [VDM_EAM_TPLNR]
    FUNCTIONALLOCATIONNAME,          -- Description [PLTXT]
    ABCINDICATOR,                    -- ABC Indic. [ABCKZ]
    ASSETLOCATION,                   -- Location [STORT]
    MAINTENANCEACTIVITYTYPE,         -- Activity Type [EAM_MAINT_ACTIVITY_TYPE]
    OPERATIONSYSTEMCONDITION,        -- SystemCondition [ANLZU]
    LOCATIONNAME,                    -- Location Name [LOCATIONNAME]
    OPERATIONSYSTEMCONDITIONTEXT,    -- Text [ANLZUX]
    ASSETMANUFACTURERNAME,           -- Manufacturer [HERST]
    COSTCENTER,                      -- Cost Center [KOSTL]
    WORKCENTER,                      -- Work Center [PPH_ARBPL]
    WBSELEMENT,                      -- WBS Element [PS_POSID_EDIT]
    WBSELEMENTINTERNALID,            -- WBS Internal ID [PS_S4_PSPNR]
    TECHNICALOBJECTTYPE,             -- Object Type [EQART]
    FUNCTIONALLOCATIONLABELNAME,     -- Functional Loc. [ILOM_STRNO]
    MAINWORKCENTERPLANT,             -- Plant [WERKS_D]
    MAINTORDERPROCESSINGCONTEXT,     -- Processing Context [MAINTORDERPROCESSINGCONTEXT]
    SOLDTOPARTY,                     -- Sold-to Party [KUNAG]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_MPBKT_SC_VAL_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, MAINTPLANNINGBUCKETSCOPEUUID)
);