C_NetPosRepPremium

DDL: C_NETPOSREPPREMIUM SQL: CNETPOSREPPR Type: view CONSUMPTION
85 Fields 1 Data Sources

ACM Position Report Premium

C_NetPosRepPremium is a Consumption CDS View that provides data about "ACM Position Report Premium" in SAP S/4HANA. It reads from 1 data source (I_NetPositionReportCube) and exposes 85 fields with key fields PricingKey, Version, PricingDocumentItem, ConditionType, SubConditionType.

Data Sources (1)

SourceAliasJoin Type
I_NetPositionReportCube I_NetPositionReportCube from

Parameters (2)

NameTypeDefault
P_MTMDataSelectionType cds_cmm_vlogp_consumptiontype
P_DisplayUnitOfMeasure cds_view_uom

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CNETPOSREPPR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label ACM Position Report Premium 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 (85)

KeyFieldSource TableSource FieldDescription
KEY PricingKey vlogp PricingKey Pricing Key
KEY Version vlogp Version XML Vers.
KEY PricingDocumentItem vlogp PricingDocumentItem Item
KEY ConditionType vlogp ConditionType Condition type
KEY SubConditionType vlogp SubConditionType
KEY VersStockRecordUUID vlogp VersStockRecordUUID
KEY EvaluationDate vlogp EvaluationDate
KEY PriceQuotationDate vlogp PriceQuotationDate
EndOfDaySnapshotFromDate vlogp EndOfDaySnapshotFromDate
EndOfDaySnapshotToDate vlogp EndOfDaySnapshotToDate
MTMDataSelectionType vlogp MTMDataSelectionType
MTMDataSourceType vlogp MTMDataSourceType Type of Data Record
ValidityStartDate vlogp ValidityStartDate Validity Start Date
ValidityStartDateTime vlogp ValidityStartDateTime Valid From Timestamp
ValidityEndDate vlogp ValidityEndDate ValidTo
ValidityEndDateTime vlogp ValidityEndDateTime Valid To Timestamp
EndOfDaySnapshotDateTimeFrom vlogp EndOfDaySnapshotDateTimeFrom
EndOfDaySnapshotDateTimeTo vlogp EndOfDaySnapshotDateTimeTo
EndOfDaySnapshotDate vlogp EndOfDaySnapshotDate
CompanyCode
SalesOrganization vlogp SalesOrganization Sales Organization
DistributionChannel vlogp DistributionChannel RefDistCh-Cust/Mat.
Division vlogp Division Internal Division ID
Creditor vlogp Creditor Supplier
SoldToParty vlogp SoldToParty Sold-to Party
Commodity vlogp Commodity DCS Commodity
PhysicalCommodity vlogp PhysicalCommodity
Material vlogp Material Vehicle Model
Plant vlogp Plant Valuation Area
StorageLocation vlogp StorageLocation StorageLocation
Batch vlogp Batch Lot No.
IncotermsClassification vlogp IncotermsClassification Incoterms
IncotermsTransferLocation vlogp IncotermsTransferLocation Incoterms 2
ConditionApplication vlogp ConditionApplication Application
SourceDocument vlogp SourceDocument Document
SourceDocumentBusObjType vlogp SourceDocumentBusObjType
OriginReferenceDocument vlogp OriginReferenceDocument Root Document
OriginReferenceDocumentItem vlogp OriginReferenceDocumentItem Root Document Item
OriginReferenceDocBusObjType vlogp OriginReferenceDocBusObjType Root (BOR) Obj. Type
ReferenceDocument vlogp ReferenceDocument Reference Document
ReferenceDocumentItem vlogp ReferenceDocumentItem Reference item
ReferenceDocBusObjType vlogp ReferenceDocBusObjType Pred(BOR) Object Typ
DeliveryDate vlogp DeliveryDate Delivery Date
ExpectedPaymentDate vlogp ExpectedPaymentDate
ProfitCenter vlogp ProfitCenter Profit Center
BusinessArea vlogp BusinessArea Business Area
PurchasingOrganization vlogp PurchasingOrganization Purchasing Organization
MaterialGroup vlogp MaterialGroup Product Group
IsIntercompanyTransfer vlogp IsIntercompanyTransfer
DerivativeContractMaturityCode vlogp DerivativeContractMaturityCode Contr. Maturity Code
MTMConditionGroupCategory
MTMConditionGroup vlogp MTMConditionGroup
MTMCalculationGroup vlogp MTMCalculationGroup
MTMAdjustmentType vlogp MTMAdjustmentType
MTMCalcGrpMarketPriceCondition vlogp MTMCalcGrpMarketPriceCondition
CommodityUnit vlogp CommodityUnit Order Unit
PriceIsRealized vlogp PriceIsRealized
ImplicitFixationIsRelevant vlogp ImplicitFixationIsRelevant
ConditionTermRateIsFixed vlogp ConditionTermRateIsFixed
MaterialStockPriceExposureUnit MaterialStockPriceExposureUnit
RealizedMaterialStkPrcExpsrQty RealizedMaterialStkPrcExpsrQty Inventory
UnRealflatApplicationQty UnRealflatApplicationQty Exposure on Application - FLAT Contracts
NoFutureEsDelContractQty NoFutureEsDelContractQty Exposure on Application - NFE Contracts
RealizedMatStkPrcExpsrQty RealizedMatStkPrcExpsrQty
FlatPricedUNDeliverContrQty FlatPricedUNDeliverContrQty
NoFutureEstUNDeliverContrQty NoFutureEstUNDeliverContrQty
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
ReportingYear ReportingYear
ReportingMonth ReportingMonth
AdjustedReportingDate vlogp AdjustedReportingDate
AdjustedReportingYear vlogp AdjustedReportingYear
AdjustedReportingMonth vlogp AdjustedReportingMonth
StorageBinHasNetDryError StorageBinHasNetDryError
PhysicalCmmdtyHasNetDryError PhysicalCmmdtyHasNetDryError
PhysicalCommodityErrorText PhysicalCommodityErrorText
GoodsMovement vlogp GoodsMovement
ACMGoodsMovementYear vlogp ACMGoodsMovementYear
ApplicationDocument vlogp ApplicationDocument
LoadDataCaptureObjectID LoadDataCaptureObjectID
LoadDataCaptureEventType LoadDataCaptureEventType

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_NetPosRepPremium.
-- 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: CNETPOSREPPR
-- Parameters: P_MTMDataSelectionType : cds_cmm_vlogp_consumptiontype, P_DisplayUnitOfMeasure : cds_view_uom

CREATE VIEW C_NetPosRepPremium AS
SELECT
  vlogp.PricingKey AS PricingKey,
  vlogp.Version AS Version,
  vlogp.PricingDocumentItem AS PricingDocumentItem,
  vlogp.ConditionType AS ConditionType,
  vlogp.SubConditionType AS SubConditionType,
  vlogp.VersStockRecordUUID AS VersStockRecordUUID,
  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,
  StorageBinHasNetDryError,
  PhysicalCmmdtyHasNetDryError,
  PhysicalCommodityErrorText,
  vlogp.GoodsMovement AS GoodsMovement,
  vlogp.ACMGoodsMovementYear AS ACMGoodsMovementYear,
  vlogp.ApplicationDocument AS ApplicationDocument,
  LoadDataCaptureObjectID,
  LoadDataCaptureEventType
FROM I_NetPositionReportCube
;

Learn More