R_CndnContrSettlmtDocsNoDvtg
Cndn Contract Settlement Documents without deviating Data
R_CndnContrSettlmtDocsNoDvtg is a Composite CDS View that provides data about "Cndn Contract Settlement Documents without deviating Data" in SAP S/4HANA. It reads from 1 data source (R_SettlmtMgmtDocProcessFlow) and exposes 59 fields with key fields ConditionContract, SettlmtDoc, SettlmtDocItem. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_SettlmtMgmtDocProcessFlow | _docflow | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | R_SettlmtMgmtDoc | _SettlmtDoc | $projection.SettlmtDoc = _SettlmtDoc.SettlmtMgmtDoc |
| [0..*] | R_SettlmtMgmtDocItem | _SettlmtDocItem | $projection.SettlmtDoc = _SettlmtDocItem.SettlmtMgmtDoc |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | RCOCOSDOCSNO | view | |
| AbapCatalog.preserveKey | true | view | |
| ObjectModel.representativeKey | ConditionContract | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ClientHandling.type | #INHERITED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| EndUserText.label | Cndn Contract Settlement Documents without deviating Data | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| AccessControl.authorizationCheck | #PRIVILEGED_ONLY | view | |
| AbapCatalog.compiler.compareFilter | true | view |
Fields (59)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ConditionContract | R_SettlmtMgmtDocProcessFlow | SettlmtPrecdgDoc | Pre. Document |
| KEY | SettlmtDoc | R_SettlmtMgmtDocProcessFlow | SettlmtSubsqntDoc | Subseq Doc. |
| KEY | SettlmtDocItem | _SettlmtDocItem | SettlmtMgmtDocItem | Item |
| SettlmtMgmtAcctgTransfSts | _SettlmtDoc | SettlmtMgmtAcctgTransfSts | Posting Status | |
| SettlmtDocIsCanceled | _SettlmtDoc | SettlmtMgmtDocIsCancelled | Doc. Reversed | |
| SettlmtDate | R_SettlmtMgmtDocProcessFlow | SettlmtDate | Settlement Date | |
| SettlmtDateCat | _SettlmtDoc | SettlmtDateCat | Settlement Date Type | |
| SettlmtDateSequentialID | R_SettlmtMgmtDocProcessFlow | SettlmtDateSequentialID | Settlement Date ID | |
| PostingPartnerCat | _SettlmtDoc | PostingPartnerCat | Posting Partner | |
| SettlmtDocType | _SettlmtDoc | SettlmtDocType | Settlement Document Type | |
| SuplrSettlmtCompanyCode | _SettlmtDoc | CompanyCode | Receiver Company Code | |
| CustSettlmtCompanyCode | _SettlmtDoc | IntercompanyCompanyCode | ||
| PurchasingOrganization | _SettlmtDoc | PurchasingOrganization | Purchasing Organization | |
| PurchasingGroup | _SettlmtDoc | PurchasingGroup | Purchasing Group | |
| SalesOrganization | _SettlmtDoc | SalesOrganization | Sales Organization | |
| DistributionChannel | _SettlmtDoc | DistributionChannel | RefDistCh-Cust/Mat. | |
| Division | _SettlmtDoc | Division | Internal Division ID | |
| SettlmtDocAuthznCat | _SettlmtDoc | SettlmtMgmtAuthznCat | ||
| SettlmtItmStatisticalPrpty | _SettlmtDocItem | SettlmtItmStatisticalPrpty | Statistical Prpty | |
| SettlmtDocCurrency | _SettlmtDoc | SettlmtDocCurrency | Doc. Currency | |
| ExchangeRateDate | _SettlmtDoc | ExchangeRateDate | Translatn Date | |
| SupplierItemNetAmount | _SettlmtDocItem | SupplierItemNetAmount | Supplier Item Net Amount | |
| CustomerItemNetAmount | _SettlmtDocItem | CustomerItemNetAmount | Customer Item Net Amount | |
| SupplierItemGrossAmount | _SettlmtDocItem | SupplierItemGrossAmount | Supplier Item Gross Amount | |
| CustomerItemGrossAmount | _SettlmtDocItem | CustomerItemGrossAmount | Customer Item Gross Amount | |
| SupplierSubtotal1Amount | ||||
| CustomerSubtotal1Amount | ||||
| SupplierSubtotal2Amount | ||||
| CustomerSubtotal2Amount | ||||
| SupplierSubtotal3Amount | ||||
| CustomerSubtotal3Amount | ||||
| SupplierSubtotal4Amount | ||||
| CustomerSubtotal4Amount | ||||
| SupplierSubtotal5Amount | ||||
| CustomerSubtotal5Amount | ||||
| SupplierSubtotal6Amount | ||||
| CustomerSubtotal6Amount | ||||
| SupplierRebateBasisAmount | ||||
| CustomerRebateBasisAmount | ||||
| SuplrItmEligibleAmtForCshDisc | ||||
| CustItmEligibleAmtForCshDisc | ||||
| SupplierEffectiveItemAmount | ||||
| CustomerEffectiveItemAmount | ||||
| SupplierItemTaxAmount | ||||
| CustomerItemTaxAmount | ||||
| CndnContrProcVar | _SettlmtDoc | CndnContrProcVar | Process Variant | |
| _SettlmtDoc | _SettlmtDoc | |||
| _SettlmtDocItem | _SettlmtDocItem | |||
| _SettlmtMgmtAcctgTransfSts | _SettlmtDoc | _SettlmtMgmtAcctgTransfSts | ||
| _PostingPartnerCat | _SettlmtDoc | _PostingPartnerCat | ||
| _SettlmtDocType | _SettlmtDoc | _SettlmtDocType | ||
| _SuplrSettlmtCompanyCode | _SettlmtDoc | _CompanyCode | ||
| _CustSettlmtCompanyCode | _SettlmtDoc | _IntercompanyCompanyCode | ||
| _PurchasingOrganization | _SettlmtDoc | _PurchasingOrganization | ||
| _PurchasingGroup | _SettlmtDoc | _PurchasingGroup | ||
| _SalesOrganization | _SettlmtDoc | _SalesOrganization | ||
| _DistributionChannel | _SettlmtDoc | _DistributionChannel | ||
| _Division | _SettlmtDoc | _Division | ||
| _SettlmtDocCurrency | _SettlmtDoc | _SettlmtDocCurrency |
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 R_CndnContrSettlmtDocsNoDvtg.
-- 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: RCOCOSDOCSNO
CREATE VIEW R_CndnContrSettlmtDocsNoDvtg AS
SELECT
_docflow.SettlmtPrecdgDoc AS ConditionContract,
_docflow.SettlmtSubsqntDoc AS SettlmtDoc,
_SettlmtDocItem.SettlmtMgmtDocItem AS SettlmtDocItem,
_SettlmtDoc.SettlmtMgmtAcctgTransfSts AS SettlmtMgmtAcctgTransfSts,
_SettlmtDoc.SettlmtMgmtDocIsCancelled AS SettlmtDocIsCanceled,
_docflow.SettlmtDate AS SettlmtDate,
_SettlmtDoc.SettlmtDateCat AS SettlmtDateCat,
_docflow.SettlmtDateSequentialID AS SettlmtDateSequentialID,
_SettlmtDoc.PostingPartnerCat AS PostingPartnerCat,
_SettlmtDoc.SettlmtDocType AS SettlmtDocType,
_SettlmtDoc.CompanyCode AS SuplrSettlmtCompanyCode,
_SettlmtDoc.IntercompanyCompanyCode AS CustSettlmtCompanyCode,
_SettlmtDoc.PurchasingOrganization AS PurchasingOrganization,
_SettlmtDoc.PurchasingGroup AS PurchasingGroup,
_SettlmtDoc.SalesOrganization AS SalesOrganization,
_SettlmtDoc.DistributionChannel AS DistributionChannel,
_SettlmtDoc.Division AS Division,
_SettlmtDoc.SettlmtMgmtAuthznCat AS SettlmtDocAuthznCat,
_SettlmtDocItem.SettlmtItmStatisticalPrpty AS SettlmtItmStatisticalPrpty,
_SettlmtDoc.SettlmtDocCurrency AS SettlmtDocCurrency,
_SettlmtDoc.ExchangeRateDate AS ExchangeRateDate,
_SettlmtDocItem.SupplierItemNetAmount AS SupplierItemNetAmount,
_SettlmtDocItem.CustomerItemNetAmount AS CustomerItemNetAmount,
_SettlmtDocItem.SupplierItemGrossAmount AS SupplierItemGrossAmount,
_SettlmtDocItem.CustomerItemGrossAmount AS CustomerItemGrossAmount,
cast( _SettlmtDocItem.SupplierSubtotal1Amount as abap.curr( 15,2 ) ) AS SupplierSubtotal1Amount,
cast( _SettlmtDocItem.CustomerSubtotal1Amount as abap.curr( 15,2 ) ) AS CustomerSubtotal1Amount,
cast( _SettlmtDocItem.SupplierSubtotal2Amount as abap.curr( 15,2 ) ) AS SupplierSubtotal2Amount,
cast( _SettlmtDocItem.CustomerSubtotal2Amount as abap.curr( 15,2 ) ) AS CustomerSubtotal2Amount,
cast( _SettlmtDocItem.SupplierSubtotal3Amount as abap.curr( 15,2 ) ) AS SupplierSubtotal3Amount,
cast( _SettlmtDocItem.CustomerSubtotal3Amount as abap.curr( 15,2 ) ) AS CustomerSubtotal3Amount,
cast( _SettlmtDocItem.SupplierSubtotal4Amount as abap.curr( 15,2 ) ) AS SupplierSubtotal4Amount,
cast( _SettlmtDocItem.CustomerSubtotal4Amount as abap.curr( 15,2 ) ) AS CustomerSubtotal4Amount,
cast( _SettlmtDocItem.SupplierSubtotal5Amount as abap.curr( 15,2 ) ) AS SupplierSubtotal5Amount,
cast( _SettlmtDocItem.CustomerSubtotal5Amount as abap.curr( 15,2 ) ) AS CustomerSubtotal5Amount,
cast( _SettlmtDocItem.SupplierSubtotal6Amount as abap.curr( 15,2 ) ) AS SupplierSubtotal6Amount,
cast( _SettlmtDocItem.CustomerSubtotal6Amount as abap.curr( 15,2 ) ) AS CustomerSubtotal6Amount,
cast( _SettlmtDocItem.SupplierRebateBasisAmount as abap.curr( 15,2 ) ) AS SupplierRebateBasisAmount,
cast( _SettlmtDocItem.CustomerRebateBasisAmount as abap.curr( 15,2 ) ) AS CustomerRebateBasisAmount,
cast( _SettlmtDocItem.SuplrItmEligibleAmtForCshDisc as abap.curr( 15,2 ) ) AS SuplrItmEligibleAmtForCshDisc,
cast( _SettlmtDocItem.CustItmEligibleAmtForCshDisc as abap.curr( 15,2 ) ) AS CustItmEligibleAmtForCshDisc,
cast( _SettlmtDocItem.SupplierEffectiveItemAmount as abap.curr( 15,2 ) ) AS SupplierEffectiveItemAmount,
cast( _SettlmtDocItem.CustomerEffectiveItemAmount as abap.curr( 15,2 ) ) AS CustomerEffectiveItemAmount,
cast( _SettlmtDocItem.SupplierItemTaxAmount as abap.curr( 15,2 ) ) AS SupplierItemTaxAmount,
cast( _SettlmtDocItem.CustomerItemTaxAmount as abap.curr( 15,2 ) ) AS CustomerItemTaxAmount,
_SettlmtDoc.CndnContrProcVar AS CndnContrProcVar,
_SettlmtDoc._SettlmtMgmtAcctgTransfSts AS _SettlmtMgmtAcctgTransfSts,
_SettlmtDoc._PostingPartnerCat AS _PostingPartnerCat,
_SettlmtDoc._SettlmtDocType AS _SettlmtDocType,
_SettlmtDoc._CompanyCode AS _SuplrSettlmtCompanyCode,
_SettlmtDoc._IntercompanyCompanyCode AS _CustSettlmtCompanyCode,
_SettlmtDoc._PurchasingOrganization AS _PurchasingOrganization,
_SettlmtDoc._PurchasingGroup AS _PurchasingGroup,
_SettlmtDoc._SalesOrganization AS _SalesOrganization,
_SettlmtDoc._DistributionChannel AS _DistributionChannel,
_SettlmtDoc._Division AS _Division,
_SettlmtDoc._SettlmtDocCurrency AS _SettlmtDocCurrency
FROM R_SettlmtMgmtDocProcessFlow AS _docflow
LEFT OUTER JOIN R_SettlmtMgmtDoc AS _SettlmtDoc ON SettlmtDoc = _SettlmtDoc.SettlmtMgmtDoc -- association [1..1]
LEFT OUTER JOIN R_SettlmtMgmtDocItem AS _SettlmtDocItem ON SettlmtDoc = _SettlmtDocItem.SettlmtMgmtDoc -- association [0..*]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA