R_CNDNDOCCONDITIONUSAGE
Condition Document Condition Usage
R_CNDNDOCCONDITIONUSAGE is a CDS View in S/4HANA. Condition Document Condition Usage. It contains 39 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_CndnContrConditionUsage | view | from | BASIC | Condition Contract Condition Usage |
Fields (39)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | DocRelationshipUUID | DocRelationshipUUID | 1 |
| _AccrSrceDocCompanyCode | _AccrSrceDocCompanyCode | 1 | |
| _AccrSrceDocCurrency | _AccrSrceDocCurrency | 1 | |
| _AccrSrceDocItemPlant | _AccrSrceDocItemPlant | 1 | |
| _BillingDocument | _BillingDocument | 1 | |
| _BillingDocumentItem | _BillingDocumentItem | 1 | |
| _CndnDocAccrReversalStatus | _CndnContrAccrRvslSts | 1 | |
| _ConditionApplication | _ConditionApplication | 1 | |
| _ConditionType | _ConditionType | 1 | |
| AccrSrceDocCategory | AccrSrceDocCategory | 1 | |
| AccrSrceDocCompanyCode | AccrSrceDocCompanyCode | 1 | |
| AccrSrceDocCurrency | AccrSrceDocCurrency | 1 | |
| AccrSrceDocFiscalYear | AccrSrceDocFiscalYear | 1 | |
| AccrSrceDocItemPlant | AccrSrceDocItemPlant | 1 | |
| AccrSrceDocPostingDate | AccrSrceDocPostingDate | 1 | |
| AccrSrceDocument | AccrSrceDocument | 1 | |
| AccrSrceDocumentItem | AccrSrceDocumentItem | 1 | |
| AccrSrceDocumentYear | AccrSrceDocumentYear | 1 | |
| BillingDocument | BillingDocument | 1 | |
| BillingDocumentItem | BillingDocumentItem | 1 | |
| CndnDocAccrReversalStatus | CndnContrAccrRvslSts | 1 | |
| CndnDocAccrualSource | CndnContrAccrSource | 1 | |
| ConditionAmount | ConditionAmount | 1 | |
| ConditionApplication | ConditionApplication | 1 | |
| ConditionRecord | ConditionRecord | 1 | |
| ConditionSequentialNumberShort | ConditionSequentialNumberShort | 1 | |
| ConditionType | ConditionType | 1 | |
| MaterialDocument | MaterialDocument | 1 | |
| MaterialDocumentItem | MaterialDocumentItem | 1 | |
| MaterialDocumentYear | MaterialDocumentYear | 1 | |
| PricingDocument | PricingDocument | 1 | |
| PricingProcedureCounter | PricingProcedureCounter | 1 | |
| PricingProcedureStep | PricingProcedureStep | 1 | |
| RefSettlmtDate | RefSettlmtDate | 1 | |
| RefSettlmtDateSequentialID | RefSettlmtDateSequentialID | 1 | |
| SettlmtDate | SettlmtDate | 1 | |
| SettlmtDateSequentialID | SettlmtDateSequentialID | 1 | |
| SettlmtMgmtDoc | SettlmtMgmtDoc | 1 | |
| SettlmtMgmtDocItem | SettlmtMgmtDocItem | 1 |
@AbapCatalog: {
sqlViewName: 'RWLFCDCNDUSAGE',
compiler.compareFilter: true,
viewEnhancementCategory: [#NONE],
dataMaintenance: #DISPLAY_ONLY
}
@EndUserText.label: 'Condition Document Condition Usage'
@VDM: {
viewType: #BASIC,
lifecycle.contract.type: #SAP_INTERNAL_API
}
@AccessControl: {
authorizationCheck: #MANDATORY,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
representativeKey: 'DocRelationshipUUID',
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #B,
sizeCategory: #XXL
}
}
@ClientHandling: {
type: #INHERITED,
algorithm: #SESSION_VARIABLE
}
@Metadata: {
ignorePropagatedAnnotations: true
}
/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] } */
define view R_CndnDocConditionUsage
as select from P_CndnContrCndnUsgeMatlDocs
association [0..1] to R_ConditionDocument as _ConditionDocument on $projection.ConditionDocument = _ConditionDocument.ConditionDocument
association [0..1] to I_BillingDocument as _BillingDocument on $projection.BillingDocument = _BillingDocument.BillingDocument
association [0..1] to I_BillingDocumentItem as _BillingDocumentItem on $projection.BillingDocument = _BillingDocumentItem.BillingDocument
and $projection.BillingDocumentItem = _BillingDocumentItem.BillingDocumentItem
association [0..1] to I_CndnContrAccrSource as _CndnDocAccrualSource on $projection.CndnDocAccrualSource = _CndnDocAccrualSource.CndnContrAccrSource
{
key DocRelationshipUUID,
PricingDocument,
PricingProcedureStep,
PricingProcedureCounter,
cast ( ConditionContract as wcb_condition_document preserving type ) as ConditionDocument,
cast ( CndnContrUUID as wcb_cndn_doc_uuid preserving type ) as ConditionDocumentUUID,
ConditionRecord,
ConditionSequentialNumberShort,
CndnContrAccrRvslSts as CndnDocAccrReversalStatus,
/* Accrual Source Document - Generic*/
AccrSrceDocCategory,
AccrSrceDocument,
AccrSrceDocumentYear,
AccrSrceDocumentItem,
ConditionApplication,
ConditionType,
@Semantics.amount.currencyCode: 'AccrSrceDocCurrency'
@Aggregation.default: #SUM
ConditionAmount,
@Semantics.currencyCode: true
AccrSrceDocCurrency,
AccrSrceDocPostingDate,
SettlmtDate,
SettlmtDateSequentialID,
RefSettlmtDate,
RefSettlmtDateSequentialID,
AccrSrceDocFiscalYear,
AccrSrceDocItemPlant,
AccrSrceDocCompanyCode,
cast( '1' as wb2_accruals_source ) as CndnDocAccrualSource,
/* Material Document*/
MaterialDocument,
MaterialDocumentYear,
MaterialDocumentItem,
/* Settlement Management Document*/
cast( ' ' as wbeln_ag preserving type ) as SettlmtMgmtDoc,
cast( '000000' as wposnr_lf preserving type ) as SettlmtMgmtDocItem,
/* Billing Document*/
cast( ' ' as vbeln_vf preserving type ) as BillingDocument,
cast( '000000' as posnr_vf preserving type ) as BillingDocumentItem,
/* Associations */
_BillingDocument,
_BillingDocumentItem,
_AccrSrceDocCompanyCode,
_AccrSrceDocCurrency,
_AccrSrceDocItemPlant,
_CndnDocAccrualSource as _CndnDocAccrualSource,
_CndnContrAccrRvslSts as _CndnDocAccrReversalStatus,
_ConditionApplication,
_ConditionDocument,
_ConditionType
}
union all select from P_CndnContrCndnUsgeSetlMgmtDoc
association [0..1] to R_ConditionDocument as _ConditionDocument on $projection.ConditionDocument = _ConditionDocument.ConditionDocument
association [0..1] to I_BillingDocument as _BillingDocument on $projection.BillingDocument = _BillingDocument.BillingDocument
association [0..1] to I_BillingDocumentItem as _BillingDocumentItem on $projection.BillingDocument = _BillingDocumentItem.BillingDocument
and $projection.BillingDocumentItem = _BillingDocumentItem.BillingDocumentItem
association [0..1] to I_CndnContrAccrSource as _CndnDocAccrualSource on $projection.CndnDocAccrualSource = _CndnDocAccrualSource.CndnContrAccrSource
{
key DocRelationshipUUID,
PricingDocument,
PricingProcedureStep,
PricingProcedureCounter,
cast ( ConditionContract as wcb_condition_document preserving type ) as ConditionDocument,
cast ( CndnContrUUID as wcb_cndn_doc_uuid preserving type ) as ConditionDocumentUUID,
ConditionRecord,
ConditionSequentialNumberShort,
CndnContrAccrRvslSts as CndnDocAccrReversalStatus,
/* Accrual Source Document - Generic*/
AccrSrceDocCategory,
AccrSrceDocument,
AccrSrceDocumentYear,
AccrSrceDocumentItem,
ConditionApplication,
ConditionType,
@Semantics.amount.currencyCode: 'AccrSrceDocCurrency'
@Aggregation.default: #SUM
ConditionAmount,
@Semantics.currencyCode: true
AccrSrceDocCurrency,
AccrSrceDocPostingDate,
SettlmtDate,
SettlmtDateSequentialID,
RefSettlmtDate,
RefSettlmtDateSequentialID,
AccrSrceDocFiscalYear,
AccrSrceDocItemPlant,
AccrSrceDocCompanyCode,
CndnContrAccrSource as CndnDocAccrualSource,
/* Material Document*/
cast( ' ' as mblnr preserving type ) as MaterialDocument,
cast( '0000' as mjahr preserving type ) as MaterialDocumentYear,
cast( '0000' as mblpo preserving type ) as MaterialDocumentItem,
/* Settlement Management Document*/
SettlmtMgmtDoc,
SettlmtMgmtDocItem,
/* Billing Document*/
cast( ' ' as vbeln_vf preserving type ) as BillingDocument,
cast( '000000' as posnr_vf preserving type ) as BillingDocumentItem,
/* Associations */
_BillingDocument,
_BillingDocumentItem,
_AccrSrceDocCompanyCode,
_AccrSrceDocCurrency,
_AccrSrceDocItemPlant,
_CndnDocAccrualSource as _CndnDocAccrualSource,
_CndnContrAccrRvslSts as _CndnDocAccrReversalStatus,
_ConditionApplication,
_ConditionDocument,
_ConditionType
}
union all select from P_CndnContrCndnUsgeBillgDocs
association [0..1] to R_ConditionDocument as _ConditionDocument on $projection.ConditionDocument = _ConditionDocument.ConditionDocument
association [0..1] to I_BillingDocument as _BillingDocument on $projection.BillingDocument = _BillingDocument.BillingDocument
association [0..1] to I_BillingDocumentItem as _BillingDocumentItem on $projection.BillingDocument = _BillingDocumentItem.BillingDocument
and $projection.BillingDocumentItem = _BillingDocumentItem.BillingDocumentItem
association [0..1] to I_CndnContrAccrSource as _CndnDocAccrualSource on $projection.CndnDocAccrualSource = _CndnDocAccrualSource.CndnContrAccrSource
{
key DocRelationshipUUID,
PricingDocument,
PricingProcedureStep,
PricingProcedureCounter,
cast ( ConditionContract as wcb_condition_document preserving type ) as ConditionDocument,
cast ( CndnContrUUID as wcb_cndn_doc_uuid preserving type ) as ConditionDocumentUUID,
ConditionRecord,
ConditionSequentialNumberShort,
CndnContrAccrRvslSts as CndnDocAccrReversalStatus,
/* Accrual Source Document - Generic*/
AccrSrceDocCategory,
AccrSrceDocument,
AccrSrceDocumentYear,
AccrSrceDocumentItem,
ConditionApplication,
ConditionType,
@Semantics.amount.currencyCode: 'AccrSrceDocCurrency'
@Aggregation.default: #SUM
ConditionAmount,
@Semantics.currencyCode: true
AccrSrceDocCurrency,
AccrSrceDocPostingDate,
SettlmtDate,
SettlmtDateSequentialID,
RefSettlmtDate,
RefSettlmtDateSequentialID,
AccrSrceDocFiscalYear,
AccrSrceDocItemPlant,
AccrSrceDocCompanyCode,
cast( '1' as wb2_accruals_source ) as CndnDocAccrualSource,
/* Material Document*/
cast( ' ' as mblnr preserving type ) as MaterialDocument,
cast( '0000' as mjahr preserving type ) as MaterialDocumentYear,
cast( '0000' as mblpo preserving type ) as MaterialDocumentItem,
/* Settlement Management Document*/
cast( ' ' as wbeln_ag preserving type ) as SettlmtMgmtDoc,
cast( '000000' as wposnr_lf preserving type ) as SettlmtMgmtDocItem,
/* Billing Document*/
BillingDocument,
BillingDocumentItem,
/* Associations */
_BillingDocument,
_BillingDocumentItem,
_AccrSrceDocCompanyCode,
_AccrSrceDocCurrency,
_AccrSrceDocItemPlant,
_CndnDocAccrualSource as _CndnDocAccrualSource,
_CndnContrAccrRvslSts as _CndnDocAccrReversalStatus,
_ConditionApplication,
_ConditionDocument,
_ConditionType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CNDNCONTRCNDNUSGEBILLGDOCS",
"P_CNDNCONTRCNDNUSGEMATLDOCS",
"P_CNDNCONTRCNDNUSGESETLMGMTDOC"
],
"ASSOCIATED":
[
"I_BILLINGDOCUMENT",
"I_BILLINGDOCUMENTITEM",
"I_CNDNCONTRACCRRVSLSTS",
"I_CNDNCONTRACCRSOURCE",
"I_COMPANYCODE",
"I_CONDITIONAPPLICATION",
"I_CURRENCY",
"I_PLANT",
"I_PRICINGCONDITIONTYPE",
"R_CONDITIONDOCUMENT"
],
"BASE":
[
"P_CNDNCONTRCNDNUSGEMATLDOCS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/