EAM_PLNGBKT
Maintenance Planning Bucket
EAM_PLNGBKT is an SAP database table in S/4HANA. Maintenance Planning Bucket. It contains 21 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_MaintPlanningBucket | view_entity | from | EXTENSION | Maintenance Planning Bucket - Extension |
| I_MaintenancePlanningBucket_2 | view_entity | from | BASIC | Maintenance Planning Bucket |
| I_MaintPlanningBucket | view | from | BASIC | Maintenance Planning Bucket |
| I_MaintPlngBucketWithRespyData | view | from | BASIC | Maintenance Planning Bucket RSP Data |
Fields (21)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | maintplanningbucketuuid | SYSUUID_X | UUID | |||
| maintplanningbuckettype | EAM_PLNGBKTTYPE | Type | ||||
| maintenanceplanningplant | IWERK | Planning Plant | ||||
| maintplngbucketlabel | EAM_PLNGBKTLABEL | Label | ||||
| maintplanningbucketdescription | EAM_PLNGBKTDESC | Description | ||||
| nrofmaintplngbucketsinadvance | EAM_NMBROFBUCKETSINADVANCE | Number of Buckets in Advance | ||||
| maintplngbucketstartdatetime | EAM_PLNGBKTSTARTDATETIME | Start Date and Time | ||||
| maintplngbucketenddatetime | EAM_PLNGBKTENDDATETIME | End Date and Time | ||||
| lastchangedatetime | EAM_LASTCHANGEDAT | Last Changed | ||||
| maintplngbucketgenerationdate | EAM_GENERATIONBASEDATE | Base Date | ||||
| refmaintplanningbucket | SYSUUID_X | UUID | ||||
| maintplngbucketlabelpattern | EAM_PLNGBKTLABELPATTERN | Label Template | ||||
| maintplngbucketsortfield | EAM_PLNGBKTSORTFIELD | Sort Field | ||||
| maintplngbucketrecurrencetype | EAM_PLNGBKTRECURRENCETYPE | Recurrence | ||||
| maintplngbucketduration | EAM_PLNGBKTDURATION | Duration | ||||
| maintplngbucketdurationunit | EAM_PLNGBKTDURATIONUNIT | Unit for Duration | ||||
| maintplngbcktrcrrcinterval | EAM_PLNGBKTRECUREVERY | Recurs Every | ||||
| personresponsible | EAM_PERSONRESP_CHAR8 | Person Responsible | ||||
| maintenanceevent | REVNI | Revision | ||||
| maintorderforadministration | AUFNR | Order |
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.
-- Maintenance Planning Bucket
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EAM_PLNGBKT (
MANDT, -- Client [MANDT]
MAINTPLANNINGBUCKETUUID, -- UUID [SYSUUID_X]
MAINTPLANNINGBUCKETTYPE, -- Type [EAM_PLNGBKTTYPE]
MAINTENANCEPLANNINGPLANT, -- Planning Plant [IWERK]
MAINTPLNGBUCKETLABEL, -- Label [EAM_PLNGBKTLABEL]
MAINTPLANNINGBUCKETDESCRIPTION, -- Description [EAM_PLNGBKTDESC]
NROFMAINTPLNGBUCKETSINADVANCE, -- Number of Buckets in Advance [EAM_NMBROFBUCKETSINADVANCE]
MAINTPLNGBUCKETSTARTDATETIME, -- Start Date and Time [EAM_PLNGBKTSTARTDATETIME]
MAINTPLNGBUCKETENDDATETIME, -- End Date and Time [EAM_PLNGBKTENDDATETIME]
LASTCHANGEDATETIME, -- Last Changed [EAM_LASTCHANGEDAT]
MAINTPLNGBUCKETGENERATIONDATE, -- Base Date [EAM_GENERATIONBASEDATE]
REFMAINTPLANNINGBUCKET, -- UUID [SYSUUID_X]
MAINTPLNGBUCKETLABELPATTERN, -- Label Template [EAM_PLNGBKTLABELPATTERN]
MAINTPLNGBUCKETSORTFIELD, -- Sort Field [EAM_PLNGBKTSORTFIELD]
MAINTPLNGBUCKETRECURRENCETYPE, -- Recurrence [EAM_PLNGBKTRECURRENCETYPE]
MAINTPLNGBUCKETDURATION, -- Duration [EAM_PLNGBKTDURATION]
MAINTPLNGBUCKETDURATIONUNIT, -- Unit for Duration [EAM_PLNGBKTDURATIONUNIT]
MAINTPLNGBCKTRCRRCINTERVAL, -- Recurs Every [EAM_PLNGBKTRECUREVERY]
PERSONRESPONSIBLE, -- Person Responsible [EAM_PERSONRESP_CHAR8]
MAINTENANCEEVENT, -- Revision [REVNI]
MAINTORDERFORADMINISTRATION, -- Order [AUFNR]
PRIMARY KEY (MANDT, MAINTPLANNINGBUCKETUUID)
);
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