FRCELMNTTOPROFITCOSTCTRUNION
FRCELMNTTOPROFITCOSTCTRUNION is an SAP database table in S/4HANA. It contains 30 fields.
Fields (30)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | DfsObjectDraftUUID | DfsObjectDraftUUID | 1 |
| KEY | DfsObjectID | DfsObjectID | 2 |
| KEY | DfsObjectPlngStatus | DfsObjectPlngStatus | 2 |
| KEY | DfsObjectRelatedObjectID | DfsObjectRelatedObjectID | 1 |
| KEY | DfsObjectValdtyEndDate | DfsObjectValdtyEndDate | 2 |
| KEY | DfsObjectValdtyStartDate | DfsObjectValdtyStartDate | 2 |
| KEY | DfsPositionRelatedObjectID | DfsObjectRelatedObjectID | 1 |
| Criticality | Criticality | 1 | |
| DfsAssgmtActiveDraft | DfsAssgmtActiveDraft | 1 | |
| DfsObjectConcatenatedID | DfsObjectConcatenatedID | 2 | |
| DfsObjectInfoType | DfsObjectInfoType | 2 | |
| DfsObjectPlanVersion | DfsObjectPlanVersion | 2 | |
| DfsObjectRelatedObjectType | DfsObjectRelatedObjectType | 1 | |
| DfsObjectRelshpBtwnObj | DfsObjectRelshpBtwnObj | 2 | |
| DfsObjectRelshpPriority | DfsObjectRelshpPriority | 2 | |
| DfsObjectRelshpSpec | DfsObjectRelshpSpec | 2 | |
| DfsObjectSubType | DfsObjectSubType | 2 | |
| DfsObjectType | DfsObjectType | 2 | |
| DfsObjRelshpLastChgdByUser | DfsObjRelshpLastChgdByUser | 2 | |
| DfsObjRelshpLastChgdByUserName | DfsObjRelshpLastChgdByUserName | 2 | |
| DfsObjRelshpLastChgdDate | DfsObjRelshpLastChgdDate | 2 | |
| DfsPositionDescRefSqncNmbr | NumberOfForceElementOrg | 1 | |
| DfsPositionRelatedObjectType | DfsObjectRelatedObjectType | 1 | |
| FrcElmntOrgControllingArea | ControllingArea,FrcElmntOrgControllingArea | 1 | |
| FrcElmntOrgCostCenter | FrcElmntOrgCostCenter | 1 | |
| FrcElmntOrgPlngStsCritlty | FrcElmntOrgPlngStsCritlty | 1 | |
| HasActiveEntity | HasActiveEntity | 1 | |
| HasDraftEntity | HasDraftEntity | 1 | |
| IsActiveEntity | IsActiveEntity | 1 | |
| NumberOfForceElementOrg | NumberOfForceElementOrg | 1 |
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.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FRCELMNTTOPROFITCOSTCTRUNION (
DFSOBJECTDRAFTUUID,
DFSOBJECTID,
DFSOBJECTPLNGSTATUS,
DFSOBJECTRELATEDOBJECTID,
DFSOBJECTVALDTYENDDATE,
DFSOBJECTVALDTYSTARTDATE,
DFSPOSITIONRELATEDOBJECTID,
CRITICALITY,
DFSASSGMTACTIVEDRAFT,
DFSOBJECTCONCATENATEDID,
DFSOBJECTINFOTYPE,
DFSOBJECTPLANVERSION,
DFSOBJECTRELATEDOBJECTTYPE,
DFSOBJECTRELSHPBTWNOBJ,
DFSOBJECTRELSHPPRIORITY,
DFSOBJECTRELSHPSPEC,
DFSOBJECTSUBTYPE,
DFSOBJECTTYPE,
DFSOBJRELSHPLASTCHGDBYUSER,
DFSOBJRELSHPLASTCHGDBYUSERNAME,
DFSOBJRELSHPLASTCHGDDATE,
DFSPOSITIONDESCREFSQNCNMBR,
DFSPOSITIONRELATEDOBJECTTYPE,
FRCELMNTORGCONTROLLINGAREA,
FRCELMNTORGCOSTCENTER,
FRCELMNTORGPLNGSTSCRITLTY,
HASACTIVEENTITY,
HASDRAFTENTITY,
ISACTIVEENTITY,
NUMBEROFFORCEELEMENTORG,
PRIMARY KEY (DFSOBJECTDRAFTUUID, DFSOBJECTID, DFSOBJECTPLNGSTATUS, DFSOBJECTRELATEDOBJECTID, DFSOBJECTVALDTYENDDATE, DFSOBJECTVALDTYSTARTDATE, DFSPOSITIONRELATEDOBJECTID)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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