P_QuantityContractAcctAssgmt

DDL: P_QUANTITYCONTRACTACCTASSGMT SQL: PQTYCONTRACCT Type: view CONSUMPTION
25 Fields 1 Data Sources

Quantity Contract Account Assignment

P_QuantityContractAcctAssgmt is a Consumption CDS View that provides data about "Quantity Contract Account Assignment" in SAP S/4HANA. It reads from 1 data source (P_QuantityContractWithPOCount) and exposes 25 fields with key fields PurchaseContract, PurchaseContractItem, AccountAssignmentNumber, ReleaseOrder, ReleaseOrderItem.

Data Sources (1)

SourceAliasJoin Type
P_QuantityContractWithPOCount P_QuantityContractWithPOCount from

Parameters (3)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate vdm_validitystart
P_EndDate vdm_validitystart

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.sqlViewName PQTYCONTRACCT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
VDM.private true view
AbapCatalog.preserveKey true view
EndUserText.label Quantity Contract Account Assignment view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContractItem PurchaseContract Purchasing Doc.
KEY PurchaseContractItem PurchaseContractItem PurchaseContractItem Item
KEY AccountAssignmentNumber AccountAssignmentNumber Account Assgmt No.
KEY ReleaseOrder ReleaseOrder Purchasing Doc.
KEY ReleaseOrderItem ReleaseOrderItem Item
FormattedPurchaseContractItem FormattedPurchaseContractItem Char15
Supplier Supplier Supplier
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingOrganization PurchasingOrganization Purchasing Organization
CompanyCode CompanyCode Receiver Company Code
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurchaseContractType PurchaseContractType Order Type
PurchasingDocumentItemCategory PurchasingDocumentItemCategory Item Category
Material PurchaseContractItem Material Vehicle Model
MaterialGroup PurchaseContractItem MaterialGroup Product Group
Plant PurchaseContractItem Plant Valuation Area
CostCenter AccountAssignment CostCenter Cost Center
CreatedByUser CreatedByUser User Name
ValidityEndDate ValidityEndDate ValidTo
ReleaseOrderDate ReleaseOrderDate PO Date
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution Distribution
ReleaseOrderItemNetAmount ReleaseOrderItemNetAmount Net Value
DisplayCurrency DisplayCurrency Display Currency
ContractNetPriceAmount ContractNetPriceAmount Net Price
OrderQuantityUnit PurchaseContractItem OrderQuantityUnit Sales Unit

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_QuantityContractAcctAssgmt.
-- 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: PQTYCONTRACCT
-- Parameters: P_DisplayCurrency : displaycurrency, P_StartDate : vdm_validitystart, P_EndDate : vdm_validitystart

CREATE VIEW P_QuantityContractAcctAssgmt AS
SELECT
  PurchaseContractItem.PurchaseContract AS PurchaseContract,
  PurchaseContractItem.PurchaseContractItem AS PurchaseContractItem,
  AccountAssignmentNumber,
  ReleaseOrder,
  ReleaseOrderItem,
  FormattedPurchaseContractItem,
  Supplier,
  PurchasingGroup,
  PurchasingOrganization,
  CompanyCode,
  PurchasingDocumentCategory,
  PurchaseContractType,
  PurchasingDocumentItemCategory,
  PurchaseContractItem.Material AS Material,
  PurchaseContractItem.MaterialGroup AS MaterialGroup,
  PurchaseContractItem.Plant AS Plant,
  AccountAssignment.CostCenter AS CostCenter,
  CreatedByUser,
  ValidityEndDate,
  ReleaseOrderDate,
  MultipleAcctAssgmtDistribution,
  ReleaseOrderItemNetAmount,
  DisplayCurrency,
  ContractNetPriceAmount,
  PurchaseContractItem.OrderQuantityUnit AS OrderQuantityUnit
FROM P_QuantityContractWithPOCount
;

Learn More