P_ACMTrdgContrItmLinkedQty
P_ACMTrdgContrItmLinkedQty is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_TrdgContrItmQtyLinkdUnion) and exposes 63 fields with key fields ContractNum, ContractItem. It has 11 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| P_TrdgContrItmQtyLinkdUnion | TrdgContrQtyAll | from |
Associations (11)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_TrdgContrItemCommonQty | _commonQty | TrdgContrQtyAll.ContractNum = _commonQty.ContractNum and TrdgContrQtyAll.ContractItem = _commonQty.TradingContractItem and TrdgContrQtyAll.TrdgContrQtyLinkType = '01' |
| [0..*] | I_TrdgContItemApplQtyDetsData | _applQty | TrdgContrQtyAll.ContractNum = _applQty.ContractNum and TrdgContrQtyAll.ContractItem = _applQty.ContractItem and TrdgContrQtyAll.TrdgContrQtyLinkType = '02' |
| [0..*] | I_TrdgContrItemCancQty | _cancQty | TrdgContrQtyAll.ContractNum = _cancQty.ContractNum and TrdgContrQtyAll.ContractItem = _cancQty.TradingContractItem and TrdgContrQtyAll.TrdgContrQtyLinkType = '03' |
| [0..*] | I_TrdgContrWashoutQuantityDets | _wshoutQty | TrdgContrQtyAll.ContractNum = _wshoutQty.ContractNum and TrdgContrQtyAll.ContractItem = _wshoutQty.TradingContractItem and TrdgContrQtyAll.TrdgContrQtyLinkType = '04' |
| [0..*] | I_TrdgContrItemReturnQtyDets | _returnQty | TrdgContrQtyAll.ContractNum = _returnQty.ContractNum and TrdgContrQtyAll.ContractItem = _returnQty.ContractItem and TrdgContrQtyAll.TrdgContrQtyLinkType = '05' |
| [0..*] | I_TrdgContrOverfillFixQtyDets | _ovrfilFixQty | TrdgContrQtyAll.ContractNum = _ovrfilFixQty.ContractNum and TrdgContrQtyAll.ContractItem = _ovrfilFixQty.TradingContractItem and TrdgContrQtyAll.TrdgContrQtyLinkType = '06' |
| [0..*] | I_TrdgContrNumberOfPlanVehicle | _nomItem | TrdgContrQtyAll.ContractNum = _nomItem.ContractNum and TrdgContrQtyAll.ContractItem = _nomItem.TradingContractItem and TrdgContrQtyAll.TrdgContrQtyLinkType = '07' |
| [0..*] | I_TrdgContrItmFnlSetldQtyDets | _fnlStlQty | TrdgContrQtyAll.ContractNum = _fnlStlQty.ContractNum and TrdgContrQtyAll.ContractItem = _fnlStlQty.ContractItem and TrdgContrQtyAll.TrdgContrQtyLinkType = '08' |
| [0..*] | I_TrdgContrPrvsnlSetldQtyDets | _prvStlQty | TrdgContrQtyAll.ContractNum = _prvStlQty.ContractNum and TrdgContrQtyAll.ContractItem = _prvStlQty.ContractItem and TrdgContrQtyAll.TrdgContrQtyLinkType = '09' |
| [0..*] | I_TrdgContrPlannedQtyDets | _plannedQty | TrdgContrQtyAll.ContractNum = _plannedQty.ContractNum and TrdgContrQtyAll.ContractItem = _plannedQty.TradingContractItem and TrdgContrQtyAll.TrdgContrQtyLinkType = '10' |
| [0..*] | I_TrdgContrPlannedQtyDets | _planTradQty | TrdgContrQtyAll.ACMRelatedTradeIdentifier = _planTradQty.ContractNum and TrdgContrQtyAll.ContractItem = _planTradQty.TradingContractItem and TrdgContrQtyAll.TrdgContrQtyLinkType = '10' |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PCONITMALLNKDQTY | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| VDM.private | true | view | |
| VDM.viewType | #COMPOSITE | view |
Fields (63)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ContractNum | P_TrdgContrItmQtyLinkdUnion | ContractNum | |
| KEY | ContractItem | P_TrdgContrItmQtyLinkdUnion | ContractItem | Purchase Contract Item |
| TradingContractItemQuantity | _commonQty | TradingContractItemQuantity | ||
| ContractItemConsumedQuantity | _commonQty | ContractItemConsumedQuantity | ||
| NumberOfConsumedVehicles | _commonQty | NumberOfConsumedVehicles | ||
| TradingContractItemOpenQty | _commonQty | TradingContractItemOpenQty | ||
| NumberOfOpenVehicles | _commonQty | NumberOfOpenVehicles | ||
| TrdgContrItemOverFillQuantity | _commonQty | TrdgContrItemOverFillQuantity | ||
| LogisticallyAdjustedQuantity | _applQty | LogisticallyAdjustedQuantity | ||
| ReferenceApplicationDocument | _applQty | ReferenceApplicationDocument | Ref Preceeding Doc | |
| ReferenceApplicationItem | _applQty | ReferenceApplicationItem | ||
| ContractApplicationUUID | _applQty | ContractApplicationUUID | ||
| ContractApplicationVersion | _applQty | ContractApplicationVersion | ||
| ProvisionalApplicationQuantity | _applQty | ProvisionalApplicationQuantity | ||
| ContrItmProvisionalOverFillQty | _applQty | ContrItmProvisionalOverFillQty | ||
| ACMContrItmPrvsnlUnderFillQty | _applQty | ACMContrItmPrvsnlUnderFillQty | ||
| FinalApplicationQuantity | _applQty | FinalApplicationQuantity | ||
| ContrItmPerDeliveryOverFillQty | _applQty | TrdgContrItemOverFillQuantity | ||
| OverfillIDendasOverfillID | ||||
| TrdgContrItemUnderFillQuantity | _applQty | TrdgContrItemUnderFillQuantity | ||
| ContrOverFillSettledQuantity | _applQty | ContrOverFillSettledQuantity | ||
| RevenueRecognizedQuantity | _applQty | RevenueRecognizedQuantity | ||
| InvoiceNumber | _applQty | InvoiceNumber | Invoice Number | |
| ContrItemSoftAssignedQuantity | _applQty | ContrItemSoftAssignedQuantity | ||
| FinalSettledQuantity | _fnlStlQty | FinalSettledQuantity | ||
| TotalFinalSettledQuantity | _fnlStlQty | TotalFinalSettledQuantity | ||
| ACMPaidQtyendasACMPaidQty | ||||
| ProvisionalSettledQuantity | _prvStlQty | ProvisionalSettledQuantity | ||
| NonAppliedPrvsnlSettledQty | _prvStlQty | NonAppliedPrvsnlSettledQty | ||
| TrdgContrItemReturnQuantity | _returnQty | TrdgContrItemReturnQuantity | ||
| PlannedNominationNumber | _plannedQty | NominationNumber | ||
| PlannedNominationItem | _plannedQty | NominationItem | ||
| ACMToleranceTypeID | _applQty | ACMToleranceTypeID | ||
| ConsumedNominationNumber | _applQty | NominationNumber | ||
| ConsumedNominationItem | _applQty | NominationItem | ||
| SettlementUnitUUID | _fnlStlQty | SettlementUnitUUID | ||
| SettlementGroupId | _fnlStlQty | SettlementGroupId | ||
| SettlmtDoc | _fnlStlQty | SettlmtDoc | Settlement Doc. | |
| SettlmtDocYear | _fnlStlQty | SettlmtDocYear | ||
| ProvSettlementUnitUUID | _prvStlQty | SettlementUnitUUID | ||
| ProvSettlmtGroup | _prvStlQty | SettlementGroupId | ||
| ProvSettlmtDoc | _prvStlQty | SettlmtDoc | Settlement Doc. | |
| ProvSettlmtYear | _prvStlQty | SettlmtDocYear | ||
| ReturnApplicationDocument | _returnQty | ReturnApplicationDocument | ||
| ReturnApplicationItem | _returnQty | ReturnApplicationItem | ||
| ContractReturnApplicationUUID | _returnQty | ContractReturnApplicationUUID | ||
| ContractReturnApplVersion | _returnQty | ContractReturnApplVersion | ||
| ReturnSettlementUnitUUID | _returnQty | ReturnSettlementUnitUUID | ||
| ReturnSettlementGroup | _returnQty | ReturnSettlementGroup | ||
| ReturnSettlmtUnit | _returnQty | ReturnSettlmtUnit | ||
| ReturnSettlmtDocYear | _returnQty | ReturnSettlmtDocYear | ||
| RetSettlmtInvoiceNumber | _returnQty | RetSettlmtInvoiceNumber | ||
| TrdgContrItemCancelledQuantity | _cancQty | TrdgContrItemCancelledQuantity | ||
| TrdgContrItemClosedQty | _cancQty | TrdgContrItemClosedQty | ||
| ACMPricingLotCancellationID | _cancQty | ACMPricingLotCancellationID | ||
| TrdgContrItemWashoutQuantity | _wshoutQty | TrdgContrItemWashoutQuantity | ||
| ACMWashoutID | _wshoutQty | ACMWashoutID | ||
| ContrOverFillFixationQuantity | _ovrfilFixQty | ContrOverFillFixationQuantity | ||
| TrdgContrPrcgAspectSrceLotID | _ovrfilFixQty | TrdgContrPrcgAspectSrceLotID | ||
| NumberOfPlannedVehicles | _nomItem | NumberOfPlannedVehicles | ||
| NumberOfTotalPlannedVehicles | _nomItem | NumberOfTotalPlannedVehicles | ||
| ConfirmedNominationNumber | _nomItem | NominationNumber | ||
| ConfirmedNominationItem | _nomItem | NominationItem |
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 P_ACMTrdgContrItmLinkedQty.
-- 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: PCONITMALLNKDQTY
CREATE VIEW P_ACMTrdgContrItmLinkedQty AS
SELECT
TrdgContrQtyAll.ContractNum AS ContractNum,
TrdgContrQtyAll.ContractItem AS ContractItem,
_commonQty.TradingContractItemQuantity AS TradingContractItemQuantity,
_commonQty.ContractItemConsumedQuantity AS ContractItemConsumedQuantity,
_commonQty.NumberOfConsumedVehicles AS NumberOfConsumedVehicles,
_commonQty.TradingContractItemOpenQty AS TradingContractItemOpenQty,
_commonQty.NumberOfOpenVehicles AS NumberOfOpenVehicles,
_commonQty.TrdgContrItemOverFillQuantity AS TrdgContrItemOverFillQuantity,
_applQty.LogisticallyAdjustedQuantity AS LogisticallyAdjustedQuantity,
_applQty.ReferenceApplicationDocument AS ReferenceApplicationDocument,
_applQty.ReferenceApplicationItem AS ReferenceApplicationItem,
_applQty.ContractApplicationUUID AS ContractApplicationUUID,
_applQty.ContractApplicationVersion AS ContractApplicationVersion,
_applQty.ProvisionalApplicationQuantity AS ProvisionalApplicationQuantity,
_applQty.ContrItmProvisionalOverFillQty AS ContrItmProvisionalOverFillQty,
_applQty.ACMContrItmPrvsnlUnderFillQty AS ACMContrItmPrvsnlUnderFillQty,
_applQty.FinalApplicationQuantity AS FinalApplicationQuantity,
_applQty.TrdgContrItemOverFillQuantity AS ContrItmPerDeliveryOverFillQty,
case when _applQty.OverfillID is not initial and _applQty.OverfillID <> '' then _applQty.OverfillID end as OverfillID AS OverfillIDendasOverfillID,
_applQty.TrdgContrItemUnderFillQuantity AS TrdgContrItemUnderFillQuantity,
_applQty.ContrOverFillSettledQuantity AS ContrOverFillSettledQuantity,
_applQty.RevenueRecognizedQuantity AS RevenueRecognizedQuantity,
_applQty.InvoiceNumber AS InvoiceNumber,
_applQty.ContrItemSoftAssignedQuantity AS ContrItemSoftAssignedQuantity,
_fnlStlQty.FinalSettledQuantity AS FinalSettledQuantity,
_fnlStlQty.TotalFinalSettledQuantity AS TotalFinalSettledQuantity,
case when _fnlStlQty.SettlmtCat = 'F' then _fnlStlQty.ACMPaidQty when _prvStlQty.SettlmtCat = 'P' then _prvStlQty.ACMPaidQty end as ACMPaidQty AS ACMPaidQtyendasACMPaidQty,
_prvStlQty.ProvisionalSettledQuantity AS ProvisionalSettledQuantity,
_prvStlQty.NonAppliedPrvsnlSettledQty AS NonAppliedPrvsnlSettledQty,
_returnQty.TrdgContrItemReturnQuantity AS TrdgContrItemReturnQuantity,
_plannedQty.NominationNumber AS PlannedNominationNumber,
_plannedQty.NominationItem AS PlannedNominationItem,
_applQty.ACMToleranceTypeID AS ACMToleranceTypeID,
_applQty.NominationNumber AS ConsumedNominationNumber,
_applQty.NominationItem AS ConsumedNominationItem,
_fnlStlQty.SettlementUnitUUID AS SettlementUnitUUID,
_fnlStlQty.SettlementGroupId AS SettlementGroupId,
_fnlStlQty.SettlmtDoc AS SettlmtDoc,
_fnlStlQty.SettlmtDocYear AS SettlmtDocYear,
_prvStlQty.SettlementUnitUUID AS ProvSettlementUnitUUID,
_prvStlQty.SettlementGroupId AS ProvSettlmtGroup,
_prvStlQty.SettlmtDoc AS ProvSettlmtDoc,
_prvStlQty.SettlmtDocYear AS ProvSettlmtYear,
_returnQty.ReturnApplicationDocument AS ReturnApplicationDocument,
_returnQty.ReturnApplicationItem AS ReturnApplicationItem,
_returnQty.ContractReturnApplicationUUID AS ContractReturnApplicationUUID,
_returnQty.ContractReturnApplVersion AS ContractReturnApplVersion,
_returnQty.ReturnSettlementUnitUUID AS ReturnSettlementUnitUUID,
_returnQty.ReturnSettlementGroup AS ReturnSettlementGroup,
_returnQty.ReturnSettlmtUnit AS ReturnSettlmtUnit,
_returnQty.ReturnSettlmtDocYear AS ReturnSettlmtDocYear,
_returnQty.RetSettlmtInvoiceNumber AS RetSettlmtInvoiceNumber,
_cancQty.TrdgContrItemCancelledQuantity AS TrdgContrItemCancelledQuantity,
_cancQty.TrdgContrItemClosedQty AS TrdgContrItemClosedQty,
_cancQty.ACMPricingLotCancellationID AS ACMPricingLotCancellationID,
_wshoutQty.TrdgContrItemWashoutQuantity AS TrdgContrItemWashoutQuantity,
_wshoutQty.ACMWashoutID AS ACMWashoutID,
_ovrfilFixQty.ContrOverFillFixationQuantity AS ContrOverFillFixationQuantity,
_ovrfilFixQty.TrdgContrPrcgAspectSrceLotID AS TrdgContrPrcgAspectSrceLotID,
_nomItem.NumberOfPlannedVehicles AS NumberOfPlannedVehicles,
_nomItem.NumberOfTotalPlannedVehicles AS NumberOfTotalPlannedVehicles,
_nomItem.NominationNumber AS ConfirmedNominationNumber,
_nomItem.NominationItem AS ConfirmedNominationItem
FROM P_TrdgContrItmQtyLinkdUnion AS TrdgContrQtyAll
LEFT OUTER JOIN I_TrdgContrItemCommonQty AS _commonQty ON TrdgContrQtyAll.ContractNum = _commonQty.ContractNum AND TrdgContrQtyAll.ContractItem = _commonQty.TradingContractItem AND TrdgContrQtyAll.TrdgContrQtyLinkType = '01' -- association [0..*]
LEFT OUTER JOIN I_TrdgContItemApplQtyDetsData AS _applQty ON TrdgContrQtyAll.ContractNum = _applQty.ContractNum AND TrdgContrQtyAll.ContractItem = _applQty.ContractItem AND TrdgContrQtyAll.TrdgContrQtyLinkType = '02' -- association [0..*]
LEFT OUTER JOIN I_TrdgContrItemCancQty AS _cancQty ON TrdgContrQtyAll.ContractNum = _cancQty.ContractNum AND TrdgContrQtyAll.ContractItem = _cancQty.TradingContractItem AND TrdgContrQtyAll.TrdgContrQtyLinkType = '03' -- association [0..*]
LEFT OUTER JOIN I_TrdgContrWashoutQuantityDets AS _wshoutQty ON TrdgContrQtyAll.ContractNum = _wshoutQty.ContractNum AND TrdgContrQtyAll.ContractItem = _wshoutQty.TradingContractItem AND TrdgContrQtyAll.TrdgContrQtyLinkType = '04' -- association [0..*]
LEFT OUTER JOIN I_TrdgContrItemReturnQtyDets AS _returnQty ON TrdgContrQtyAll.ContractNum = _returnQty.ContractNum AND TrdgContrQtyAll.ContractItem = _returnQty.ContractItem AND TrdgContrQtyAll.TrdgContrQtyLinkType = '05' -- association [0..*]
LEFT OUTER JOIN I_TrdgContrOverfillFixQtyDets AS _ovrfilFixQty ON TrdgContrQtyAll.ContractNum = _ovrfilFixQty.ContractNum AND TrdgContrQtyAll.ContractItem = _ovrfilFixQty.TradingContractItem AND TrdgContrQtyAll.TrdgContrQtyLinkType = '06' -- association [0..*]
LEFT OUTER JOIN I_TrdgContrNumberOfPlanVehicle AS _nomItem ON TrdgContrQtyAll.ContractNum = _nomItem.ContractNum AND TrdgContrQtyAll.ContractItem = _nomItem.TradingContractItem AND TrdgContrQtyAll.TrdgContrQtyLinkType = '07' -- association [0..*]
LEFT OUTER JOIN I_TrdgContrItmFnlSetldQtyDets AS _fnlStlQty ON TrdgContrQtyAll.ContractNum = _fnlStlQty.ContractNum AND TrdgContrQtyAll.ContractItem = _fnlStlQty.ContractItem AND TrdgContrQtyAll.TrdgContrQtyLinkType = '08' -- association [0..*]
LEFT OUTER JOIN I_TrdgContrPrvsnlSetldQtyDets AS _prvStlQty ON TrdgContrQtyAll.ContractNum = _prvStlQty.ContractNum AND TrdgContrQtyAll.ContractItem = _prvStlQty.ContractItem AND TrdgContrQtyAll.TrdgContrQtyLinkType = '09' -- association [0..*]
LEFT OUTER JOIN I_TrdgContrPlannedQtyDets AS _plannedQty ON TrdgContrQtyAll.ContractNum = _plannedQty.ContractNum AND TrdgContrQtyAll.ContractItem = _plannedQty.TradingContractItem AND TrdgContrQtyAll.TrdgContrQtyLinkType = '10' -- association [0..*]
LEFT OUTER JOIN I_TrdgContrPlannedQtyDets AS _planTradQty ON TrdgContrQtyAll.ACMRelatedTradeIdentifier = _planTradQty.ContractNum AND TrdgContrQtyAll.ContractItem = _planTradQty.TradingContractItem AND TrdgContrQtyAll.TrdgContrQtyLinkType = '10' -- association [0..*]
;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