I_AssignmentData

DDL: I_ASSIGNMENTDATA SQL: IASSIGNMENT Type: view BASIC
12 Fields 1 Data Sources

ACM Qty: Assignment Data

I_AssignmentData is a Basic CDS View that provides data about "ACM Qty: Assignment Data" in SAP S/4HANA. It reads from 1 data source (wb2_d_assgmt) and exposes 12 fields with key fields DocumentFrom, ACMFromDocumentNumber, ACMFromDocumentItemNumber, ContractNum, ContractItem.

Data Sources (1)

SourceAliasJoin Type
wb2_d_assgmt wb2_d_assgmt from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IASSIGNMENT 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 ACM Qty: Assignment Data view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY DocumentFrom type_from Document Type
ReferenceDocumentType
KEY ACMFromDocumentNumber document_from DocNum
ApplicationDocument
KEY ACMFromDocumentItemNumber item_from Item Number
ApplicationDocumentItem
KEY ContractNum tkonn Trading Contract
KEY ContractItem tposn Item Number
KEY ContractCommodityItem tposn_com Com. item num.
ContractItemAssignmentUUID a_guid Assignment GUID
AssignmentQuantity assgd_quan_orig AssignedQuanOrig
TrdgContractItemUnitOfMeasure assgd_uom Assigned UoM

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_AssignmentData.
-- 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: IASSIGNMENT

CREATE VIEW I_AssignmentData AS
SELECT
  type_from AS DocumentFrom,
  document_from AS ACMFromDocumentNumber,
  item_from AS ACMFromDocumentItemNumber,
  tkonn AS ContractNum,
  tposn AS ContractItem,
  tposn_com AS ContractCommodityItem,
  a_guid AS ContractItemAssignmentUUID,
  assgd_quan_orig AS AssignmentQuantity,
  assgd_uom AS TrdgContractItemUnitOfMeasure
FROM wb2_d_assgmt
;

Learn More