C_CAInvcgDocRelation

DDL: C_CAINVCGDOCRELATION SQL: CCAINVDOC_X Type: view CONSUMPTION

Fakturierungsbeleg Objektverknüpfungen

C_CAInvcgDocRelation is a Consumption CDS View that provides data about "Fakturierungsbeleg Objektverknüpfungen" in SAP S/4HANA. It reads from 1 data source (I_CAInvcgDocRelation) and exposes 13 fields with key fields CAInvoicingDocument, CAInvcgReferenceObject, CAReferenceObjectID, CAInvcgCreationDate. It has 1 association to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_CAInvcgDocRelation _CAInvcgDocRelation from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_CAInvcgDocHeader _CAInvcgHeader $projection.CAInvoicingDocument = _CAInvcgHeader.CAInvoicingDocument

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CCAINVDOC_X 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 #MIXED view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Fakturierungsbeleg Objektverknüpfungen view
UI.headerInfo.typeName Referenz view
UI.headerInfo.typeNamePlural Referenzen view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CAInvoicingDocument I_CAInvcgDocRelation CAInvoicingDocument
KEY CAInvcgReferenceObject I_CAInvcgDocRelation CAInvcgReferenceObject
KEY CAReferenceObjectID I_CAInvcgDocRelation CAReferenceObjectID
KEY CAInvcgCreationDate I_CAInvcgDocRelation CAInvcgCreationDate
CAInvcgReferenceObjectSemObj _CAInvcgReferenceObj CAInvcgReferenceObjectSemObj
CAInvcgReferenceObjectSemObj_H _CAInvcgReferenceObj CAInvcgReferenceObjectSemObj
CAInvcgIsDocumentSimulated I_CAInvcgDocRelation CAInvcgIsDocumentSimulated
CAInvcgIsDocumentPreliminary I_CAInvcgDocRelation CAInvcgIsDocumentPreliminary
CAInvcgIsDocumentPosted I_CAInvcgDocRelation CAInvcgIsDocumentPosted
CAInvcgReferenceObjText
CAReferenceObjectAddlText I_CAInvcgDocRelation CAReferenceObjectAddlText
_CAInvcgReferenceObj _CAInvcgReferenceObj
_CAInvcgHeader _CAInvcgHeader 
@AbapCatalog.sqlViewName: 'CCAINVDOC_X'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
  usageType: {
    serviceQuality: #C,
    sizeCategory: #XL,
    dataClass: #MIXED
  }
}
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Fakturierungsbeleg Objektverknüpfungen'
@UI:{
  headerInfo: {
    typeName:       'Referenz',
    typeNamePlural: 'Referenzen'
  },
  presentationVariant: [{
    sortOrder: [{ by: 'CAInvcgCreationDate', direction: #ASC }],
    requestAtLeast: ['CAInvcgReferenceObjectSemObj']
  }]
}
define view C_CAInvcgDocRelation
  as select from I_CAInvcgDocRelation as _CAInvcgDocRelation

  association [1..1] to C_CAInvcgDocHeader as _CAInvcgHeader on $projection.CAInvoicingDocument = _CAInvcgHeader.CAInvoicingDocument
{
      @UI.hidden: true
  key _CAInvcgDocRelation.CAInvoicingDocument,
  
      //REFOBJNAME

      @UI.lineItem: { position: 20 }
      @ObjectModel.text.element: 'CAInvcgReferenceObjText'
  key _CAInvcgDocRelation.CAInvcgReferenceObject,

      //REFOBJVALUE

      @UI.lineItem: { position: 10 }
      // @Consumption.semanticObject: #(CAInvcgReferenceObjectSemObj)

  key _CAInvcgDocRelation.CAReferenceObjectID,

      //CRDATE

      @UI.lineItem: { position: 30 }
  key _CAInvcgDocRelation.CAInvcgCreationDate,

      @UI.hidden: true
      @ObjectModel: {
        virtualElement: true,
        virtualElementCalculatedBy: 'ABAP:CL_CINV_SADL_EXIT_INVREFOBJ'
      }
      _CAInvcgReferenceObj.CAInvcgReferenceObjectSemObj,
      @Consumption.hidden: true
      _CAInvcgReferenceObj.CAInvcgReferenceObjectSemObj as CAInvcgReferenceObjectSemObj_H,
      
      //SIMULATED

      @UI.lineItem: { position: 40 }
      _CAInvcgDocRelation.CAInvcgIsDocumentSimulated,

      //PRELIMINARY

      @UI.lineItem: { position: 50 }
      _CAInvcgDocRelation.CAInvcgIsDocumentPreliminary,

      //INVOICED

      @UI.lineItem: { position: 60 }
      _CAInvcgDocRelation.CAInvcgIsDocumentPosted,

      @UI.hidden: true
      _CAInvcgReferenceObj._CAInvcgReferenceObjText[1: Language=$session.system_language].CAInvcgReferenceObjText,

      // refobjvalue2

      _CAInvcgDocRelation.CAReferenceObjectAddlText,


      // Make association public

      _CAInvcgReferenceObj,
      _CAInvcgHeader
}

Learn More