I_CnConSetlDetldStmntMatlDoc

DDL: I_CNCONSETLDETLDSTMNTMATLDOC Type: view_entity COMPOSITE
36 Fields 1 Data Sources 6 Associations

Detailed Statement for Goods Receipt

I_CnConSetlDetldStmntMatlDoc is a Composite CDS View that provides data about "Detailed Statement for Goods Receipt" in SAP S/4HANA. It reads from 1 data source (R_CndnContrSettlmtDetldStmnt) and exposes 36 fields with key fields ConditionContract, SettlmtDoc, SettlmtDocItem, SetldBusVolDocCategory, SettledMaterialDocument. It has 6 associations to related views.

SAP Help Documentation

CategoryCondition Contract
Purpose
This CDS view is used to see which goods receipt documents are part of detailed statement information for a corresponding settlement document and/or condition contract. This CDS view provides the data to answer the following business question: Which goods receipt documents are part of detailed statement information for a corresponding settlement document and/or condition contract? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to run reports using this CDS view must have the authorization to display the following data: Authorization Object: W_COCO Authorization required for Condition Contract Type ( CONTR_TYP ) Authorization Object: W_COCO_ORG Authorization required for the following: Purchasing Organization ( EKORG ) Purchasing Group ( EKGRP ) Sales Org ( VKORG ) Distribution Channel ( VTWEG ) Division ( SPART ) Authorization Object: F_KNA1_BED Authorization group needs to be maintained for the following: Customer Supplier Prior Supplier Authorization Object: W_WBRK_FKA Authorization required for Settlement Document Type ( LFART ) Authorization Object: W_WBRK_ORG Authorization required for the following: Relevant Company Code ( BURKS ) Purchasing Organization ( EKORG ) Purchasing Group ( EKGRP ) Sales Org ( VKORG ) Distribution Channel ( VTWEG ) Division ( SPART ) Authorization Object: F_KNA1_BED Authorization group needs to be maintained for the following: Bill-To Party Bill-To Party Company Payer Party Payer Party Company Invoicing Party Invoicing Party Company Payee Party Payee Party Company Alternative Invoicing Party Alternative Invoicing Party Company

Structure
Further important fields Important fields in this view include the following: Field Name Description ConditionContract Condition Contract SettlmtDoc Settlement Document Number SettlmtDocItem Document Item SetldBusVolDocCategory Settled Business Volume Document Type SettledMaterialDocument Settled Material Document SettledMaterialDocumentItem Settled Material Document Item SettledMaterialDocumentYear Material Document Year

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
R_CndnContrSettlmtDetldStmnt R_CndnContrSettlmtDetldStmnt from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_SettlmtDoc _SettlmtDoc $projection.SettlmtDoc = _SettlmtDoc.SettlmtDoc
[0..1] I_SettlmtDocItem _SettlmtDocItem $projection.SettlmtDoc = _SettlmtDocItem.SettlmtDoc and $projection.SettlmtDocItem = _SettlmtDocItem.SettlmtDocItem
[0..1] I_ConditionContract _ConditionContract $projection.ConditionContract = _ConditionContract.ConditionContract
[0..1] I_MaterialDocumentHeader_2 _MaterialDocumentHeader $projection.SettledMaterialDocument = _MaterialDocumentHeader.MaterialDocument and $projection.SettledMaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear
[0..1] I_MaterialDocumentYear _MaterialDocumentYear $projection.SettledMaterialDocumentYear = _MaterialDocumentYear.MaterialDocumentYear
[0..1] I_MaterialDocumentItem_2 _MaterialDocumentItem $projection.SettledMaterialDocument = _MaterialDocumentItem.MaterialDocument and $projection.SettledMaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear and $projection.SettledMaterialDocumentItem = _MaterialDocumentItem.MaterialDocumentItem

Annotations (10)

NameValueLevelField
EndUserText.label Detailed Statement for Goods Receipt view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY ConditionContract ConditionContract Condition Contract
KEY SettlmtDoc SettlmtDoc Settlement Doc.
KEY SettlmtDocItem SettlmtDocItem Item
KEY SetldBusVolDocCategory SetldBusVolDocCategory
KEY SettledMaterialDocument
KEY SettledMaterialDocumentYear
KEY SetldBusVolDocKey3 SetldBusVolDocKey3
KEY SettledMaterialDocumentItem
BusVolSelDteForSettlmt BusVolSelDteForSettlmt
SettledBusVolQty SettledBusVolQty
SettledBusVolQtyUnit SettledBusVolQtyUnit
SettledBusVolAmount1 SettledBusVolAmount1
SettledBusVolAmount2 SettledBusVolAmount2
SettledBusVolAmount3 SettledBusVolAmount3
SettledBusVolAmount4 SettledBusVolAmount4
SettledBusVolNetWeight SettledBusVolNetWeight
SettledBusVolGrossWeight SettledBusVolGrossWeight
SettledBusVolWeightUnit SettledBusVolWeightUnit
SettledBusVolVolume SettledBusVolVolume
SettledBusVolVolumeUnit SettledBusVolVolumeUnit
SettledBusVolPointsQty SettledBusVolPointsQty
SettledBusVolPointsQtyUnit SettledBusVolPointsQtyUnit
SettlmtDocType SettlmtDocType Settlement Document Type
BusVolDocCurrency BusVolDocCurrency
_ConditionContract _ConditionContract
_SettlmtDoc _SettlmtDoc
_SettlmtDocItem _SettlmtDocItem
_SetldBusVolDocCategory _SetldBusVolDocCategory
_MaterialDocumentHeader _MaterialDocumentHeader
_MaterialDocumentYear _MaterialDocumentYear
_MaterialDocumentItem _MaterialDocumentItem
_SettledBusVolQtyUnit _SettledBusVolQtyUnit
_SettledBusVolWeightUnit _SettledBusVolWeightUnit
_SettledBusVolVolumeUnit _SettledBusVolVolumeUnit
_SettledBusVolPointsQtyUnit _SettledBusVolPointsQtyUnit
_BusVolDocCurrency _BusVolDocCurrency

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_CnConSetlDetldStmntMatlDoc.
-- 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 I_CnConSetlDetldStmntMatlDoc AS
SELECT
  ConditionContract,
  SettlmtDoc,
  SettlmtDocItem,
  SetldBusVolDocCategory,
  cast ( SetldBusVolDocKey1 as wlf_setld_mat_doc ) AS SettledMaterialDocument,
  cast ( SetldBusVolDocKey2 as wlf_setld_mat_doc_year ) AS SettledMaterialDocumentYear,
  SetldBusVolDocKey3,
  cast ( SetldBusVolDocItem as wlf_setld_mat_doc_item ) AS SettledMaterialDocumentItem,
  BusVolSelDteForSettlmt,
  SettledBusVolQty,
  SettledBusVolQtyUnit,
  SettledBusVolAmount1,
  SettledBusVolAmount2,
  SettledBusVolAmount3,
  SettledBusVolAmount4,
  SettledBusVolNetWeight,
  SettledBusVolGrossWeight,
  SettledBusVolWeightUnit,
  SettledBusVolVolume,
  SettledBusVolVolumeUnit,
  SettledBusVolPointsQty,
  SettledBusVolPointsQtyUnit,
  SettlmtDocType,
  BusVolDocCurrency
FROM R_CndnContrSettlmtDetldStmnt
LEFT OUTER JOIN I_SettlmtDoc AS _SettlmtDoc ON SettlmtDoc = _SettlmtDoc.SettlmtDoc  -- association [0..1]
LEFT OUTER JOIN I_SettlmtDocItem AS _SettlmtDocItem ON SettlmtDoc = _SettlmtDocItem.SettlmtDoc AND SettlmtDocItem = _SettlmtDocItem.SettlmtDocItem  -- association [0..1]
LEFT OUTER JOIN I_ConditionContract AS _ConditionContract ON ConditionContract = _ConditionContract.ConditionContract  -- association [0..1]
LEFT OUTER JOIN I_MaterialDocumentHeader_2 AS _MaterialDocumentHeader ON SettledMaterialDocument = _MaterialDocumentHeader.MaterialDocument AND SettledMaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear  -- association [0..1]
LEFT OUTER JOIN I_MaterialDocumentYear AS _MaterialDocumentYear ON SettledMaterialDocumentYear = _MaterialDocumentYear.MaterialDocumentYear  -- association [0..1]
LEFT OUTER JOIN I_MaterialDocumentItem_2 AS _MaterialDocumentItem ON SettledMaterialDocument = _MaterialDocumentItem.MaterialDocument AND SettledMaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear AND SettledMaterialDocumentItem = _MaterialDocumentItem.MaterialDocumentItem  -- association [0..1]
;

Learn More