FCO_COST_EST_ACDOCP_SDM

DDL: FCO_COST_EST_ACDOCP_SDM SQL: FCOCOSTESTSDM1 Type: view
6 Fields 2 Data Sources

Cost Estimate with group acdocp fields

FCO_COST_EST_ACDOCP_SDM is a CDS View that provides data about "Cost Estimate with group acdocp fields" in SAP S/4HANA. It reads from 2 data sources (I_MfgOrdPlngCat, acdocp) and exposes 6 fields with key fields pmatnr, werks, budat, kdauf, kdpos.

Data Sources (2)

SourceAliasJoin Type
I_MfgOrdPlngCat _MfgOrdPlngCat inner
acdocp _PlanItem from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FCOCOSTESTSDM1 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Cost Estimate with group acdocp fields view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY pmatnr pmatnr Product
KEY werks werks Receiving Plant
KEY budat budat Posting Date
KEY kdauf kdauf SD Document
KEY kdpos kdpos Sales Ord. Item
KEY category category Violation Category

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view FCO_COST_EST_ACDOCP_SDM.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: FCOCOSTESTSDM1

CREATE VIEW FCO_COST_EST_ACDOCP_SDM AS
SELECT
  pmatnr,
  werks,
  budat,
  kdauf,
  kdpos,
  category
FROM acdocp AS _PlanItem
INNER JOIN I_MfgOrdPlngCat AS _MfgOrdPlngCat ON /* join condition not captured in parsed metadata */
;

Learn More