I_CnConSetlDetldStmntSuplrInvc

DDL: I_CNCONSETLDETLDSTMNTSUPLRINVC Type: view_entity COMPOSITE
32 Fields 1 Data Sources 3 Associations

Detailed Statement for Supplier Invoice

I_CnConSetlDetldStmntSuplrInvc is a Composite CDS View that provides data about "Detailed Statement for Supplier Invoice" in SAP S/4HANA. It reads from 1 data source (R_CndnContrSettlmtDetldStmnt) and exposes 32 fields with key fields ConditionContract, SettlmtDoc, SettlmtDocItem, SetldBusVolDocCategory, SettledSuplrInvc. It has 3 associations to related views.

SAP Help Documentation

CategoryCondition Contract
Purpose
This CDS view is used to see which supplier invoice 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 supplier invoice 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 SettledSuplrInvc Settled Supplier Invoice SettledSuplrInvcItem Settled Supplier Invoice Item SettledSuplrInvcFiscalYear Supplier Invoice Fiscal Year

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
R_CndnContrSettlmtDetldStmnt R_CndnContrSettlmtDetldStmnt from

Associations (3)

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

Annotations (10)

NameValueLevelField
EndUserText.label Detailed Statement for Supplier Invoice 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 (32)

KeyFieldSource TableSource FieldDescription
KEY ConditionContract ConditionContract Condition Contract
KEY SettlmtDoc SettlmtDoc Settlement Doc.
KEY SettlmtDocItem SettlmtDocItem Item
KEY SetldBusVolDocCategory SetldBusVolDocCategory
KEY SettledSuplrInvc
KEY SettledSuplrInvcFiscalYear
KEY SettledSuplrInvcItem
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
_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_CnConSetlDetldStmntSuplrInvc.
-- 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_CnConSetlDetldStmntSuplrInvc AS
SELECT
  ConditionContract,
  SettlmtDoc,
  SettlmtDocItem,
  SetldBusVolDocCategory,
  cast( SetldBusVolDocKey1 as wlf_setld_supr_invc ) AS SettledSuplrInvc,
  cast( SetldBusVolDocKey2 as wlf_setld_supr_invc_fisc_year ) AS SettledSuplrInvcFiscalYear,
  cast( SetldBusVolDocItem as wlf_setld_supr_invc_itm ) AS SettledSuplrInvcItem,
  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]
;

Learn More