I_CANotDisputedOpenDoc

DDL: I_CANOTDISPUTEDOPENDOC SQL: INOTDSPUTDOPNDOC Type: view COMPOSITE

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)

SourceAliasJoin Type
I_CADocumentHeader I_CADocumentHeader from

Annotations (10)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/