I_CANotDisputedOpenDoc
Not Disputed Open Doc
I_CANotDisputedOpenDoc is a Composite CDS View that provides data about "Not Disputed Open Doc" in SAP S/4HANA. It reads from 1 data source (I_CADocumentHeader) and exposes 32 fields with key field CADocumentNumber.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_CADocumentHeader | I_CADocumentHeader | from |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | INOTDSPUTDOPNDOC | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| VDM.viewType | #COMPOSITE | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| EndUserText.label | Not Disputed Open Doc | view |
Fields (32)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CADocumentNumber | CADocumentNumber | ||
| CAAmountInTransactionCurrency | ||||
| TransactionCurrency | ||||
| CAMainTransaction | ||||
| CASubTransaction | ||||
| CANetDueDate | ||||
| CADeferralDate | ||||
| CAClearingDate | ||||
| CAClearingReasonName | ||||
| CAClearingReason | ||||
| OpenAmountInTransCrcy | ||||
| CAMainTransactionName | ||||
| CASubTransactionName | ||||
| BusinessPartner | ||||
| ContractAccount | ||||
| CAContract | ||||
| CASubApplication | ||||
| CompanyCode | ||||
| CreationDate | ||||
| CreationTime | ||||
| CAPostingDate | CAPostingDate | |||
| CAReferenceDocument | CAReferenceDocument | |||
| ReferenceDocumentType | ReferenceDocumentType | |||
| CADocumentTypeName | ||||
| DocumentDate | DocumentDate | |||
| CAReconciliationKey | CAReconciliationKey | |||
| CADocumentOriginCodeName | CADocumentOriginCodeName | |||
| CreatedByUser | CreatedByUser | |||
| CADocumentOriginCode | CADocumentOriginCode | |||
| CAReversalDocumentNumber | CAReversalDocumentNumber | |||
| CAReversedDocumentNumber | CAReversedDocumentNumber | |||
| _DocOriginCode | _DocOriginCode |
@AbapCatalog.sqlViewName: 'INOTDSPUTDOPNDOC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking
@EndUserText.label: 'Not Disputed Open Doc'
define view I_CANotDisputedOpenDoc
as select from I_CADocumentHeader
{
key CADocumentNumber,
@Semantics.amount.currencyCode: 'TransactionCurrency'
cast( 1 as betrw_kk ) as CAAmountInTransactionCurrency,
@Semantics.currencyCode: true
cast(TransactionCurrency as fis_rwcur ) as TransactionCurrency,
cast(' ' as hvorg_kk) as CAMainTransaction,
cast(' ' as tvorg_kk) as CASubTransaction,
cast('00000000' as faedn_kk) as CANetDueDate,
cast('00000000' as studt_kk) as CADeferralDate,
cast('00000000' as augdt_kk) as CAClearingDate,
cast( '' as augrd_gfn_kk) as CAClearingReasonName,
cast(''as augrd_kk) as CAClearingReason,
@Semantics.amount.currencyCode: 'TransactionCurrency'
cast( 0 as obetw_gfn_kk ) as OpenAmountInTransCrcy,
cast('' as hvorg_txt) as CAMainTransactionName,
cast('' as tvorg_txt) as CASubTransactionName,
cast(' ' as bu_partner ) as BusinessPartner,
cast(' ' as vkont_gfn_kk ) as ContractAccount,
cast('' as vtref_kk) as CAContract,
cast('' as subap_kk) as CASubApplication,
cast('' as bukrs) as CompanyCode,
cast(CreationDate as erdat) as CreationDate,
cast(CreationTime as crtime_kk) as CreationTime,
CAPostingDate,
CAReferenceDocument,
ReferenceDocumentType,
_DocType._Text[1:Language = $session.system_language].CADocumentTypeName,
DocumentDate,
CAReconciliationKey,
CADocumentOriginCodeName,
CreatedByUser,
CADocumentOriginCode,
CAReversalDocumentNumber,
CAReversedDocumentNumber,
_DocOriginCode
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CADOCUMENTHEADER",
"I_CADOCUMENTTYPE",
"I_CADOCUMENTTYPETEXT"
],
"ASSOCIATED":
[
"I_CADOCUMENTORIGINCODE"
],
"BASE":
[
"I_CADOCUMENTHEADER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- 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