C_PosRepPremiumDayOverDay
ACM Position Report Premium - DoD
C_PosRepPremiumDayOverDay (Consumption)
Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.
Sales
C_PosRepPremiumDayOverDay is a Consumption CDS View that provides data about "ACM Position Report Premium - DoD" in SAP S/4HANA. It reads from 1 data source (I_PosRepCube) and exposes 76 fields with key fields PricingKey, Version, PricingDocumentItem, ConditionType, SubConditionType.
SAP API Hub
| State | C1 |
|---|---|
| Line of Business | Sales |
| Application Component | LO-AGR |
| Package | Sales for SAP S/4HANA Cloud Private Edition |
Documentation
- Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
- CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
- Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
- Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
- Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
- SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
- SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
- VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
- View Browser — Search, browse and tag CDS Views
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_PosRepCube | I_PosRepCube | from |
Parameters (3)
| Name | Type | Default |
|---|---|---|
| P_MTMDataSelectionType | cds_cmm_consumptiontype | |
| P_DisplayUnitOfMeasure | cds_view_uom | |
| P_EndOfDaySnapshotFromDate | cds_accgo_eval_date_compar |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CPSOREPPRDOD | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #PRIVILEGED_ONLY | view | |
| EndUserText.label | ACM Position Report Premium - DoD | view | |
| Analytics.query | true | view | |
| VDM.viewType | #CONSUMPTION | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view |
Fields (76)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PricingKey | vlogp | PricingKey | A key required to access versioned pricing data |
| KEY | Version | vlogp | Version | Version of an MtM Valuation Record |
| KEY | PricingDocumentItem | vlogp | PricingDocumentItem | Condition item number |
| KEY | ConditionType | vlogp | ConditionType | Condition type |
| KEY | SubConditionType | vlogp | SubConditionType | The key of a sub-condition type |
| KEY | EvaluationDate | vlogp | EvaluationDate | Latest Evaluation Date |
| KEY | PriceQuotationDate | vlogp | PriceQuotationDate | Date of Price Quotation |
| EndOfDaySnapshotFromDate | vlogp | EndOfDaySnapshotFromDate | Snapshot Start Date | |
| EndOfDaySnapshotToDate | vlogp | EndOfDaySnapshotToDate | Snapshot End Date | |
| MTMDataSelectionType | vlogp | MTMDataSelectionType | VLOGP Data Selection Type | |
| MTMDataSourceType | vlogp | MTMDataSourceType | Type of Data Record | |
| ValidityStartDate | vlogp | ValidityStartDate | Validity Start Date | |
| ValidityStartDateTime | vlogp | ValidityStartDateTime | Valid From Timestamp | |
| ValidityEndDate | vlogp | ValidityEndDate | Valid-To Date | |
| ValidityEndDateTime | vlogp | ValidityEndDateTime | Valid To Timestamp | |
| EndOfDaySnapshotDateTimeFrom | vlogp | EndOfDaySnapshotDateTimeFrom | Timestamp defining a End-of-day snapshot | |
| EndOfDaySnapshotDateTimeTo | vlogp | EndOfDaySnapshotDateTimeTo | Timestamp defining a End-of-day snapshot | |
| EndOfDaySnapshotDate | vlogp | EndOfDaySnapshotDate | Snapshot Date | |
| CompanyCode | Company Code | |||
| SalesOrganization | vlogp | SalesOrganization | Sales Organization | |
| DistributionChannel | vlogp | DistributionChannel | Distribution Channel | |
| Division | vlogp | Division | Internal Division ID | |
| Creditor | vlogp | Creditor | Supplier's Account Number | |
| SoldToParty | vlogp | SoldToParty | Sold-to Party | |
| Commodity | vlogp | Commodity | Pricing Commodity | |
| PhysicalCommodity | vlogp | PhysicalCommodity | Physical Commodity | |
| Material | vlogp | Material | Material Number | |
| Plant | vlogp | Plant | Valuation Area | |
| StorageLocation | vlogp | StorageLocation | Storage Location | |
| Batch | vlogp | Batch | Batch Number | |
| IncotermsClassification | vlogp | IncotermsClassification | Incoterms (Part 1) | |
| IncotermsTransferLocation | vlogp | IncotermsTransferLocation | Incoterms (Part 2) | |
| ConditionApplication | vlogp | ConditionApplication | Application | |
| SourceDocument | vlogp | SourceDocument | Document | |
| SourceDocumentBusObjType | vlogp | SourceDocumentBusObjType | Document Type | |
| OriginReferenceDocument | vlogp | OriginReferenceDocument | Root Document | |
| OriginReferenceDocumentItem | vlogp | OriginReferenceDocumentItem | Root Document Item | |
| OriginReferenceDocBusObjType | vlogp | OriginReferenceDocBusObjType | Root (BOR) Obj. Type | |
| ReferenceDocument | vlogp | ReferenceDocument | Predecessor Document | |
| ReferenceDocumentItem | vlogp | ReferenceDocumentItem | Predecessor Document Item | |
| ReferenceDocBusObjType | vlogp | ReferenceDocBusObjType | Predecessor Document Type | |
| DeliveryDate | vlogp | DeliveryDate | Delivery Date | |
| ExpectedPaymentDate | vlogp | ExpectedPaymentDate | Payment Date | |
| ProfitCenter | vlogp | ProfitCenter | Profit Center | |
| BusinessArea | vlogp | BusinessArea | Business Area | |
| PurchasingOrganization | vlogp | PurchasingOrganization | Purchasing Organization | |
| MaterialGroup | vlogp | MaterialGroup | Material Group | |
| IsIntercompanyTransfer | vlogp | IsIntercompanyTransfer | Intercompany Transfer | |
| DerivativeContractMaturityCode | vlogp | DerivativeContractMaturityCode | Contract Maturity Code | |
| MTMConditionGroupCategory | Categorization of Condition Group | |||
| MTMConditionGroup | vlogp | MTMConditionGroup | MtM Condition Group | |
| MTMCalculationGroup | vlogp | MTMCalculationGroup | MtM Calculation Group | |
| MTMAdjustmentType | vlogp | MTMAdjustmentType | Type of adjustment for the MtM or TPL calculation | |
| MTMCalcGrpMarketPriceCondition | vlogp | MTMCalcGrpMarketPriceCondition | Market Price Condition within a calculation group | |
| CommodityUnit | vlogp | CommodityUnit | Unit of Measure for Commodity | |
| PriceIsRealized | vlogp | PriceIsRealized | Indicates that the MtM value is realized | |
| ImplicitFixationIsRelevant | vlogp | ImplicitFixationIsRelevant | Implicit Fixation Relevant | |
| ConditionTermRateIsFixed | vlogp | ConditionTermRateIsFixed | Indicates that the term is fixed | |
| MaterialStockPriceExposureUnit | MaterialStockPriceExposureUnit | Material Stock Unit of Measure | ||
| RealizedMaterialStkPrcExpsrQty | RealizedMaterialStkPrcExpsrQty | Realized Stock Quantity | ||
| UnRealflatApplicationQty | UnRealflatApplicationQty | Exposure on Application - FLAT Contracts | ||
| NoFutureEsDelContractQty | NoFutureEsDelContractQty | Exposure on Application - NFE Contracts | ||
| RealizedMatStkPrcExpsrQty | RealizedMatStkPrcExpsrQty | Realized Stock Quantity | ||
| FlatPricedUNDeliverContrQty | FlatPricedUNDeliverContrQty | FLAT Contracts Quantity | ||
| NoFutureEstUNDeliverContrQty | NoFutureEstUNDeliverContrQty | NFE Contracts Quantity | ||
| SubTotPremiumPosInv | Sub-Total Premium Position Inventory | |||
| FlatPricedUNDelContractQty | FlatPricedUNDelContractQty | Un-Applied FLAT Contracts | ||
| NoFutureEsUNDelContractQty | NoFutureEsUNDelContractQty | Un-Applied NFE Contracts | ||
| SubTotPremiumPosContracts | Sub-Total Premium Pos - Open Contractss | |||
| SubTotPremiumPos | Premium Positions | |||
| ReportingDate | vlogp | ReportingDate | Reporting Date | |
| ReportingYear | ReportingYear | Reporting Year | ||
| ReportingMonth | ReportingMonth | Reporting Period | ||
| AdjustedReportingDate | vlogp | AdjustedReportingDate | Adjusted Reporting Date | |
| AdjustedReportingYear | vlogp | AdjustedReportingYear | Abjusted Reporting Year | |
| AdjustedReportingMonth | vlogp | AdjustedReportingMonth | Adjusted Reporting Month |
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_PosRepPremiumDayOverDay.
-- 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: CPSOREPPRDOD
-- Parameters: P_MTMDataSelectionType : cds_cmm_consumptiontype, P_DisplayUnitOfMeasure : cds_view_uom, P_EndOfDaySnapshotFromDate : cds_accgo_eval_date_compar
CREATE VIEW C_PosRepPremiumDayOverDay AS
SELECT
vlogp.PricingKey AS PricingKey,
vlogp.Version AS Version,
vlogp.PricingDocumentItem AS PricingDocumentItem,
vlogp.ConditionType AS ConditionType,
vlogp.SubConditionType AS SubConditionType,
vlogp.EvaluationDate AS EvaluationDate,
vlogp.PriceQuotationDate AS PriceQuotationDate,
vlogp.EndOfDaySnapshotFromDate AS EndOfDaySnapshotFromDate,
vlogp.EndOfDaySnapshotToDate AS EndOfDaySnapshotToDate,
vlogp.MTMDataSelectionType AS MTMDataSelectionType,
vlogp.MTMDataSourceType AS MTMDataSourceType,
vlogp.ValidityStartDate AS ValidityStartDate,
vlogp.ValidityStartDateTime AS ValidityStartDateTime,
vlogp.ValidityEndDate AS ValidityEndDate,
vlogp.ValidityEndDateTime AS ValidityEndDateTime,
vlogp.EndOfDaySnapshotDateTimeFrom AS EndOfDaySnapshotDateTimeFrom,
vlogp.EndOfDaySnapshotDateTimeTo AS EndOfDaySnapshotDateTimeTo,
vlogp.EndOfDaySnapshotDate AS EndOfDaySnapshotDate,
vlogp.SalesOrganization AS SalesOrganization,
vlogp.DistributionChannel AS DistributionChannel,
vlogp.Division AS Division,
vlogp.Creditor AS Creditor,
vlogp.SoldToParty AS SoldToParty,
vlogp.Commodity AS Commodity,
vlogp.PhysicalCommodity AS PhysicalCommodity,
vlogp.Material AS Material,
vlogp.Plant AS Plant,
vlogp.StorageLocation AS StorageLocation,
vlogp.Batch AS Batch,
vlogp.IncotermsClassification AS IncotermsClassification,
vlogp.IncotermsTransferLocation AS IncotermsTransferLocation,
vlogp.ConditionApplication AS ConditionApplication,
vlogp.SourceDocument AS SourceDocument,
vlogp.SourceDocumentBusObjType AS SourceDocumentBusObjType,
vlogp.OriginReferenceDocument AS OriginReferenceDocument,
vlogp.OriginReferenceDocumentItem AS OriginReferenceDocumentItem,
vlogp.OriginReferenceDocBusObjType AS OriginReferenceDocBusObjType,
vlogp.ReferenceDocument AS ReferenceDocument,
vlogp.ReferenceDocumentItem AS ReferenceDocumentItem,
vlogp.ReferenceDocBusObjType AS ReferenceDocBusObjType,
vlogp.DeliveryDate AS DeliveryDate,
vlogp.ExpectedPaymentDate AS ExpectedPaymentDate,
vlogp.ProfitCenter AS ProfitCenter,
vlogp.BusinessArea AS BusinessArea,
vlogp.PurchasingOrganization AS PurchasingOrganization,
vlogp.MaterialGroup AS MaterialGroup,
vlogp.IsIntercompanyTransfer AS IsIntercompanyTransfer,
vlogp.DerivativeContractMaturityCode AS DerivativeContractMaturityCode,
vlogp.MTMConditionGroup AS MTMConditionGroup,
vlogp.MTMCalculationGroup AS MTMCalculationGroup,
vlogp.MTMAdjustmentType AS MTMAdjustmentType,
vlogp.MTMCalcGrpMarketPriceCondition AS MTMCalcGrpMarketPriceCondition,
vlogp.CommodityUnit AS CommodityUnit,
vlogp.PriceIsRealized AS PriceIsRealized,
vlogp.ImplicitFixationIsRelevant AS ImplicitFixationIsRelevant,
vlogp.ConditionTermRateIsFixed AS ConditionTermRateIsFixed,
MaterialStockPriceExposureUnit,
RealizedMaterialStkPrcExpsrQty,
UnRealflatApplicationQty,
NoFutureEsDelContractQty,
RealizedMatStkPrcExpsrQty,
FlatPricedUNDeliverContrQty,
NoFutureEstUNDeliverContrQty,
( RealizedMatStkPrcExpsrQty + UnRealflatApplicationQty + NoFutureEsDelContractQty ) AS SubTotPremiumPosInv,
FlatPricedUNDelContractQty,
NoFutureEsUNDelContractQty,
( FlatPricedUNDeliverContrQty + NoFutureEstUNDeliverContrQty ) AS SubTotPremiumPosContracts,
( RealizedMatStkPrcExpsrQty + UnRealflatApplicationQty + NoFutureEsDelContractQty + FlatPricedUNDeliverContrQty + NoFutureEstUNDeliverContrQty ) AS SubTotPremiumPos,
vlogp.ReportingDate AS ReportingDate,
ReportingYear,
ReportingMonth,
vlogp.AdjustedReportingDate AS AdjustedReportingDate,
vlogp.AdjustedReportingYear AS AdjustedReportingYear,
vlogp.AdjustedReportingMonth AS AdjustedReportingMonth
FROM I_PosRepCube
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- 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
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA