EAM_PLNGBKTSCPD
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA