A_ProcOrderConfBatchCharc

DDL: A_PROCORDERCONFBATCHCHARC Type: view_entity COMPOSITE Package: ODATA_PP_API_PROCORDER_CONF_2
16 Fields 1 Data Sources 1 Associations 1 OData Services

Batch Characteristics for Material Movements

A_ProcOrderConfBatchCharc is a Composite CDS View that provides data about "Batch Characteristics for Material Movements" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderConfGRBatchCharc) and exposes 16 fields with key fields ConfirmationGroup, ConfirmationCount, MaterialDocument, MaterialDocumentItem, MaterialDocumentYear. It has 1 association to related views. It is exposed through 1 OData service (ASQL_F8950). Part of development package ODATA_PP_API_PROCORDER_CONF_2.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderConfGRBatchCharc I_MfgOrderConfGRBatchCharc from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_ProcOrdConfirmation_2 _ProcOrdConf $projection.ConfirmationGroup = _ProcOrdConf.ConfirmationGroup and $projection.ConfirmationCount = _ProcOrdConf.ConfirmationCount

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Batch Characteristics for Material Movements view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
OData.entitySet.name ProcOrderConfBatchCharc view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F8950 ASQL_F8950 C2 NOT_RELEASED

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ConfirmationGroup ConfirmationGroup
KEY ConfirmationCount ConfirmationCount
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
KEY Plant Plant Valuation Area
KEY Material Material Vehicle Model
KEY Batch Batch Lot No.
KEY CharcInternalID CharcInternalID Characteristic Internal ID
ManufacturingOrderCategory ManufacturingOrderCategory
Characteristic Characteristic Field Name
CharcValue CharcValue Char. Value
ClassType ClassType X Flag
_MatlDoc _MatlDoc
_ProcOrdConf _ProcOrdConf
_Characteristic _Characteristic

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 A_ProcOrderConfBatchCharc.
-- 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.

CREATE VIEW A_ProcOrderConfBatchCharc AS
SELECT
  ConfirmationGroup,
  ConfirmationCount,
  MaterialDocument,
  MaterialDocumentItem,
  MaterialDocumentYear,
  Plant,
  Material,
  Batch,
  CharcInternalID,
  ManufacturingOrderCategory,
  Characteristic,
  CharcValue,
  ClassType
FROM I_MfgOrderConfGRBatchCharc
LEFT OUTER JOIN A_ProcOrdConfirmation_2 AS _ProcOrdConf ON ConfirmationGroup = _ProcOrdConf.ConfirmationGroup AND ConfirmationCount = _ProcOrdConf.ConfirmationCount  -- association [1..1]
;

Learn More