C_CAInvcgDocSource

DDL: C_CAINVCGDOCSOURCE SQL: CCAINVDOC_S Type: view CONSUMPTION

Fakturierungsbeleg Quellen

C_CAInvcgDocSource is a Consumption CDS View that provides data about "Fakturierungsbeleg Quellen" in SAP S/4HANA. It reads from 1 data source (I_CAInvcgDocSource) and exposes 20 fields with key fields CAInvoicingDocument, CAInvcgSourceDocumentNumber, CAInvcgSourceDocumentCat. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CAInvcgDocSource _CAInvDocSource from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_CAInvcgDocDisp _CAInvcgReversalDocument $projection.CAInvcgReversalDocument = _CAInvcgReversalDocument.CAInvoicingDocument
[1..1] C_CAInvcgDocDisp _CAInvcgReversedDocument $projection.CAInvcgReversedDocument = _CAInvcgReversedDocument.CAInvoicingDocument

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CCAINVDOC_S view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Fakturierungsbeleg Quellen view
UI.headerInfo.typeName Quellbeleg view
UI.headerInfo.typeNamePlural Quellbelege view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY CAInvoicingDocument I_CAInvcgDocSource CAInvoicingDocument
KEY CAInvcgSourceDocumentNumber I_CAInvcgDocSource CAInvcgSourceDocumentNumber
KEY CAInvcgSourceDocumentCat I_CAInvcgDocSource CAInvcgSourceDocumentCat
CAInvcgSourceDocumentSemObj _CAInvcgSourceDocCat CAInvcgSourceDocumentSemObj
CAInvcgSourceDocumentType I_CAInvcgDocSource CAInvcgSourceDocumentType
CAInvcgIsDocumentSimulated I_CAInvcgDocSource CAInvcgIsDocumentSimulated
CAInvcgIsDocumentPreliminary I_CAInvcgDocSource CAInvcgIsDocumentPreliminary
LogicalSystem I_CAInvcgDocSource LogicalSystem
CAApplicationArea I_CAInvcgDocSource CAApplicationArea
CAInvcgIsDocumentPosted I_CAInvcgDocSource CAInvcgIsDocumentPosted
CAInvcgReversalDocument I_CAInvcgDocSource CAInvcgReversalDocument
CAInvcgReversedDocument I_CAInvcgDocSource CAInvcgReversedDocument
CAInvcgCreationDate I_CAInvcgDocSource CAInvcgCreationDate
CAInvcgSourceDocCatText
CAInvcgSourceDocTypeText
_CAInvcgDocHeader _CAInvcgDocHeader
_CAInvcgSourceDocCat _CAInvcgSourceDocCat
_CAInvcgSourceDocType _CAInvcgSourceDocType
_CAInvcgReversalDocument _CAInvcgReversalDocument
_CAInvcgReversedDocument _CAInvcgReversedDocument
@AbapCatalog.sqlViewName: 'CCAINVDOC_S'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Fakturierungsbeleg Quellen'
@UI:{
  headerInfo: {
    typeName:       'Quellbeleg',
    typeNamePlural: 'Quellbelege'
  },
  presentationVariant: [{ 
    sortOrder: [ { by: 'CAInvcgCreationDate', direction: #DESC }],
    requestAtLeast: ['CAInvcgSourceDocumentSemObj'] 
  }]
}
define view C_CAInvcgDocSource
  as select from I_CAInvcgDocSource as _CAInvDocSource

  -- required for in-app navigation
  association [1..1] to C_CAInvcgDocDisp as _CAInvcgReversalDocument on $projection.CAInvcgReversalDocument = _CAInvcgReversalDocument.CAInvoicingDocument
  association [1..1] to C_CAInvcgDocDisp as _CAInvcgReversedDocument on $projection.CAInvcgReversedDocument = _CAInvcgReversedDocument.CAInvoicingDocument

{
      //INVDOCNO

      @UI.lineItem:       { position: 09, importance: #HIGH}
  key _CAInvDocSource.CAInvoicingDocument,

      //SRCDOCNO

      @UI.lineItem:       { position: 10, importance: #HIGH, semanticObjectAction: 'display'}
      @Consumption.semanticObject: 'CABillgDocument'
  key _CAInvDocSource.CAInvcgSourceDocumentNumber,

      //SRCDOCCAT

      @UI.lineItem:       { position: 20, importance: #HIGH}
      @ObjectModel.text.element: 'CAInvcgSourceDocCatText'
  key _CAInvDocSource.CAInvcgSourceDocumentCat,

      @UI.hidden: true
      _CAInvcgSourceDocCat.CAInvcgSourceDocumentSemObj,

      //SRCDOCTYPE

      @UI.lineItem:       { position: 30, importance: #HIGH}
      @ObjectModel.text.element: 'CAInvcgSourceDocTypeText'
      _CAInvDocSource.CAInvcgSourceDocumentType,

      //SIMULATED

      @UI.lineItem:       { position: 40, importance: #HIGH}
      _CAInvDocSource.CAInvcgIsDocumentSimulated,


      //PRELIMINARY

      @UI.lineItem:       { position: 50, importance: #HIGH}
      _CAInvDocSource.CAInvcgIsDocumentPreliminary,

      // Hidden fields


      //LOGSYSTEM

      _CAInvDocSource.LogicalSystem,

      //APPLK

      _CAInvDocSource.CAApplicationArea,

      //INVOICED

      _CAInvDocSource.CAInvcgIsDocumentPosted,

      //REVERSALDOC

      @UI.lineItem: [{ position: 60, importance: #LOW, type: #WITH_NAVIGATION_PATH, value: 'CAInvcgReversalDocument', targetElement: '_CAInvcgReversalDocument' }]        
      _CAInvDocSource.CAInvcgReversalDocument,

      //REVERSEDDOC

      @UI.lineItem: [{ position: 70, importance: #LOW, type: #WITH_NAVIGATION_PATH, value: 'CAInvcgReversedDocument', targetElement: '_CAInvcgReversedDocument' }]  
      _CAInvDocSource.CAInvcgReversedDocument,

      //CRDATE

      _CAInvDocSource.CAInvcgCreationDate,

      @UI.hidden: true
      _CAInvcgSourceDocCat._CAInvcgSourceDocCatText[1: Language=$session.system_language].CAInvcgSourceDocCatText,
      @UI.hidden: true
      _CAInvcgSourceDocType._CAInvcgSourceDocTypeText[1: Language=$session.system_language].CAInvcgSourceDocTypeText,


      // Make association public

      _CAInvcgDocHeader,
      _CAInvcgSourceDocCat,
      _CAInvcgSourceDocType,
      _CAInvcgReversalDocument,
      _CAInvcgReversedDocument
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CAINVCGDOCSOURCE",
"I_CAINVCGSOURCEDOCCAT",
"I_CAINVCGSOURCEDOCCATTEXT",
"I_CAINVCGSOURCEDOCTYPE",
"I_CAINVCGSOURCEDOCTYPETEXT"
],
"ASSOCIATED":
[
"C_CAINVCGDOCDISP",
"I_CAINVCGDOCHEADER",
"I_CAINVCGSOURCEDOCCAT",
"I_CAINVCGSOURCEDOCTYPE"
],
"BASE":
[
"I_CAINVCGDOCSOURCE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/