I_CANotDisputedClearedDoc

DDL: I_CANOTDISPUTEDCLEAREDDOC SQL: INODSPUTDCLRDDOC Type: view COMPOSITE

Not Disputed Cleared Doc

I_CANotDisputedClearedDoc is a Composite CDS View that provides data about "Not Disputed Cleared Doc" in SAP S/4HANA. It reads from 1 data source (I_CADocumentHeader) and exposes 34 fields with key field CADocumentNumber. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CADocumentHeader I_CADocumentHeader from

Associations (2)

CardinalityTargetAliasCondition
[0..1] P_CANotDisputedDocIsBlocked _CADocumentIsBlocked $projection.CADocumentNumber = _CADocumentIsBlocked.CADocumentNumber
[1..1] I_ContractAccountHeader _ContractAccount $projection.ContractAccount = _ContractAccount.ContractAccount

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName INODSPUTDCLRDDOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Not Disputed Cleared Doc view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view

Fields (34)

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
IsBusinessPurposeCompleted _CADocumentIsBlocked IsBusinessPurposeCompleted
_ContractAccount _ContractAccount
_DocOriginCode _DocOriginCode
@AbapCatalog.sqlViewName: 'INODSPUTDCLRDDOC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@EndUserText.label: 'Not Disputed Cleared Doc'
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
define view I_CANotDisputedClearedDoc 
  as select from I_CADocumentHeader 
  association [0..1] to P_CANotDisputedDocIsBlocked  as _CADocumentIsBlocked  on  $projection.CADocumentNumber = _CADocumentIsBlocked.CADocumentNumber
  association [1..1] to I_ContractAccountHeader   as _ContractAccount on  $projection.ContractAccount = _ContractAccount.ContractAccount 
{
   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('BP_JQ_II' as bu_partner ) as BusinessPartner,
   cast('CA_JQ_II' 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,
   _CADocumentIsBlocked.IsBusinessPurposeCompleted,
   _ContractAccount,
   _DocOriginCode
} 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CADOCUMENTHEADER",
"I_CADOCUMENTTYPE",
"I_CADOCUMENTTYPETEXT",
"P_CANOTDISPUTEDDOCISBLOCKED"
],
"ASSOCIATED":
[
"I_CADOCUMENTORIGINCODE",
"I_CONTRACTACCOUNTHEADER",
"P_CANOTDISPUTEDDOCISBLOCKED"
],
"BASE":
[
"I_CADOCUMENTHEADER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/