I_CANotDisputedOpenDoc

DDL: I_CANOTDISPUTEDOPENDOC SQL: INOTDSPUTDOPNDOC Type: view COMPOSITE Package: ODATA_O2C_FICA_DISPUTE_MANAGE

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_CADocument) and exposes 32 fields with key field CADocumentNumber. Part of development package ODATA_O2C_FICA_DISPUTE_MANAGE.

Data Sources (1)

SourceAliasJoin Type
I_CADocument I_CADocument 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
CreatedByUser CreatedByUser
CADocumentOriginCode CADocumentOriginCode
CAReversalDocumentNumber CAReversalDocumentNumber
CAReversedDocumentNumber CAReversedDocumentNumber
_CADocumentOriginCode _CADocumentOriginCode
@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_CADocument
{
   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,
   _CADocumentType._Text[1:Language = $session.system_language].CADocumentTypeName,
   DocumentDate,
   CAReconciliationKey,
   
   _CADocumentOriginCode._Text[1:Language = $session.system_language].CADocumentOriginCodeName,
    
   CreatedByUser,
    
   CADocumentOriginCode,
    
   CAReversalDocumentNumber,
    
   CAReversedDocumentNumber,
   _CADocumentOriginCode
}