I_TrdgContrOverfillFixQtyDets

DDL: I_TRDGCONTROVERFILLFIXQTYDETS SQL: ICONOVRFILFIXQTY Type: view BASIC

Trading Contract Overfill Fixation Qty

I_TrdgContrOverfillFixQtyDets is a Basic CDS View that provides data about "Trading Contract Overfill Fixation Qty" in SAP S/4HANA. It reads from 2 data sources (/accgo/t_prasp, /accgo/t_pr_asp) and exposes 8 fields with key fields ContractNum, TradingContractItem, Side, ACMPricingAspect, ACMPricingAspectValue.

Data Sources (2)

SourceAliasJoin Type
/accgo/t_prasp OverfillType inner
/accgo/t_pr_asp PricingAspect from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICONOVRFILFIXQTY view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Trading Contract Overfill Fixation Qty view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ContractNum /accgo/t_pr_asp tkonn Trading Contract
KEY TradingContractItem /accgo/t_pr_asp tposn Item Number
KEY Side /accgo/t_pr_asp side Side
KEY ACMPricingAspect /accgo/t_pr_asp pr_aspect Pricing Aspect
KEY ACMPricingAspectValue /accgo/t_pr_asp pr_count Aspect Counter
TrdgContrPrcgAspectSrceLotID /accgo/t_pr_asp src_lt_id Src. Lot ID
ContrOverFillFixationQuantity /accgo/t_pr_asp tradeqty Qty In Trade UoM
TrdgContractItemUnitOfMeasure /accgo/t_pr_asp tradeuom UoM of Trade Qty

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 I_TrdgContrOverfillFixQtyDets.
-- 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: ICONOVRFILFIXQTY

CREATE VIEW I_TrdgContrOverfillFixQtyDets AS
SELECT
  PricingAspect.tkonn AS ContractNum,
  PricingAspect.tposn AS TradingContractItem,
  PricingAspect.side AS Side,
  PricingAspect.pr_aspect AS ACMPricingAspect,
  PricingAspect.pr_count AS ACMPricingAspectValue,
  PricingAspect.src_lt_id AS TrdgContrPrcgAspectSrceLotID,
  PricingAspect.tradeqty AS ContrOverFillFixationQuantity,
  PricingAspect.tradeuom AS TrdgContractItemUnitOfMeasure
FROM /accgo/t_pr_asp AS PricingAspect
INNER JOIN /accgo/t_prasp AS OverfillType ON /* join condition not captured in parsed metadata */
;