C_ACMSpotAccumulateToOwnTP

DDL: C_ACMSPOTACCUMULATETOOWNTP Type: view_entity CONSUMPTION
49 Fields 1 Data Sources

Projection for ACM Accumulate To Own

C_ACMSpotAccumulateToOwnTP is a Consumption CDS View that provides data about "Projection for ACM Accumulate To Own" in SAP S/4HANA. It reads from 1 data source (R_ACMSpotAccumulateToOwnTP) and exposes 49 fields with key field ACMSpotID.

Data Sources (1)

SourceAliasJoin Type
R_ACMSpotAccumulateToOwnTP R_ACMSpotAccumulateToOwnTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Projection for ACM Accumulate To Own view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
VDM.viewType #CONSUMPTION view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY ACMSpotID ACMSpotID
Counterparty Counterparty Supplier
CounterpartyFullName CounterpartyFullName
CustomerName CustomerName Name of Customer
ACMCounterpartyFirstName ACMCounterpartyFirstName
ACMCounterpartyLastName ACMCounterpartyLastName
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
Plant Plant Valuation Area
PlantName _PlantName PlantName Plant Name
Material Material Vehicle Model
ProductDescription _MaterialText ProductDescription Description
ContractMaterial ContractMaterial
ACMContractMaterialDescription _ContractMaterialText ProductDescription Description
DeliveryDate DeliveryDate Delivery Date
ACMApplicationStatus ACMApplicationStatus
ACMApplicationStatusText ACMApplicationStatusText Short Description
ACMHedgeFlag ACMHedgeFlag
ACMPriceTypeFlag ACMPriceTypeFlag
ACMSpotScenario ACMSpotScenario
TradingContract TradingContract
TradingContractItem TradingContractItem Item Number
Side Side Side
ACMSpotTemplateID ACMSpotTemplateID
ACMSpotTemplateItem ACMSpotTemplateItem
ACMAppliedQuantity ACMAppliedQuantity
ACMAppliedQuantityUoM ACMAppliedQuantityUoM
ACMSpotRequestIsReadyToPrice ACMSpotRequestIsReadyToPrice
ACMReadyToPriceStsCriticality ACMReadyToPriceStsCriticality
ACMReadyToPriceApproved ACMReadyToPriceApproved
ACMApprovedStatusCriticality ACMApprovedStatusCriticality
TSWLocationID TSWLocationID Location ID
DiscPremQtyScheduleUniqueID DiscPremQtyScheduleUniqueID Schedule ID
DiscPremQtyScheduleName _DPQS DiscPremQtyScheduleName Schedule Name
ACMSpotPriceStatus ACMSpotPriceStatus
ModeOfTransport ModeOfTransport Mode of Transp.
ModeOfTransportDesc _ModeText ModeOfTransportDesc
ACMContrOptionsMnsOfTransport ACMContrOptionsMnsOfTransport
ACMApplTransCtpty ACMApplTransCtpty
ACMTransCounterpartyFullName ACMTransCounterpartyFullName Name of Customer
ACMTransCounterpartyFirstName ACMTransCounterpartyFirstName
ACMTransCounterpartyLastName ACMTransCounterpartyLastName
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreatedByName _CreatedByName UserDescription Full Name
ChangedBy ChangedBy User Name
ACMSpotRequestChangedOnDate ACMSpotRequestChangedOnDate
ChangedByName _ChangedByName UserDescription Full Name
_CreatedByName _CreatedByName
_ChangedByName _ChangedByName

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 C_ACMSpotAccumulateToOwnTP.
-- 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.

CREATE VIEW C_ACMSpotAccumulateToOwnTP AS
SELECT
  ACMSpotID,
  Counterparty,
  CounterpartyFullName,
  CustomerName,
  ACMCounterpartyFirstName,
  ACMCounterpartyLastName,
  IsBusinessPurposeCompleted,
  Plant,
  _PlantName.PlantName AS PlantName,
  Material,
  _MaterialText.ProductDescription AS ProductDescription,
  ContractMaterial,
  _ContractMaterialText.ProductDescription AS ACMContractMaterialDescription,
  DeliveryDate,
  ACMApplicationStatus,
  ACMApplicationStatusText,
  ACMHedgeFlag,
  ACMPriceTypeFlag,
  ACMSpotScenario,
  TradingContract,
  TradingContractItem,
  Side,
  ACMSpotTemplateID,
  ACMSpotTemplateItem,
  ACMAppliedQuantity,
  ACMAppliedQuantityUoM,
  ACMSpotRequestIsReadyToPrice,
  ACMReadyToPriceStsCriticality,
  ACMReadyToPriceApproved,
  ACMApprovedStatusCriticality,
  TSWLocationID,
  DiscPremQtyScheduleUniqueID,
  _DPQS.DiscPremQtyScheduleName AS DiscPremQtyScheduleName,
  ACMSpotPriceStatus,
  ModeOfTransport,
  _ModeText.ModeOfTransportDesc AS ModeOfTransportDesc,
  ACMContrOptionsMnsOfTransport,
  ACMApplTransCtpty,
  ACMTransCounterpartyFullName,
  ACMTransCounterpartyFirstName,
  ACMTransCounterpartyLastName,
  CreatedByUser,
  CreationDate,
  _CreatedByName.UserDescription AS CreatedByName,
  ChangedBy,
  ACMSpotRequestChangedOnDate,
  _ChangedByName.UserDescription AS ChangedByName
FROM R_ACMSpotAccumulateToOwnTP
;

Learn More