I_CAINVCGDOCPOSTING

CDS View

Fakturierungsbelegbuchungen

I_CAINVCGDOCPOSTING is a CDS View in S/4HANA. Fakturierungsbelegbuchungen. It contains 7 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_CAInvcgDocPosting view_entity from CONSUMPTION Fakturierungsbeleg Buchungen
I_CABillPrntInvcgDocPosting view_entity from COMPOSITE Fakt.beleg Buchungen f. Rechnungsausgabe
P_CAInvcgDocSeparatedAmtsInDC view_entity from COMPOSITE Invoicing Document - Separated Amounts
P_CAInvcgDocSeparatedAmtsInTC view_entity from COMPOSITE Fakturierungsbeleg - aufgeteilte Beträge
R_CAInvcgDocPostingTP view_entity from TRANSACTIONAL Invoicing Document Posting Doc Ref - TP

Fields (7)

KeyField CDS FieldsUsed in Views
KEY CADocumentNumber CADocumentNumber 4
KEY CAInvoicingDocument CAInvoicingDocument 4
KEY CASequenceNumber CASequenceNumber 2
CABPItemNumber CABPItemNumber 2
CAInvcgIsPostedInCurrentInvcg CAInvcgIsPostedInCurrentInvcg 2
CAInvcgRefPostingDocType CAInvcgRefPostingDocType 2
CARepetitionItemNumber CARepetitionItemNumber 2
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Fakturierungsbelegbuchungen'
@VDM.viewType: #BASIC
@Analytics.dataExtraction.enabled: true
@ObjectModel: {
  usageType: {
    serviceQuality: #A,
    sizeCategory: #XL,
    dataClass: #TRANSACTIONAL
  },
  modelingPattern: #NONE,
  representativeKey: 'CASequenceNumber',
  sapObjectNodeType.name: 'ContrAcctgInvcgDocPosting',
  supportedCapabilities: [
    #SQL_DATA_SOURCE,
    #CDS_MODELING_DATA_SOURCE,
    #CDS_MODELING_ASSOCIATION_TARGET,
    #EXTRACTION_DATA_SOURCE
  ]
}
@Metadata.ignorePropagatedAnnotations: true
define view entity I_CAInvcgDocPosting
  as select from dfkkinvdoc_p

  association [1..1] to I_CAInvcgDocHeader      as _CAInvcgDocHeader      on $projection.CAInvoicingDocument = _CAInvcgDocHeader.CAInvoicingDocument
  association [0..1] to I_CAInvcgRefPostgDocTyp as _CAInvcgRefPostgDocTyp on $projection.CAInvcgRefPostingDocType = _CAInvcgRefPostgDocTyp.CAInvcgRefPostingDocType
  association [0..1] to I_CADocument            as _CADocument            on $projection.CADocumentNumber = _CADocument.CADocumentNumber
{
      @ObjectModel.foreignKey.association: '_CAInvcgDocHeader'
  key invdocno                                             as CAInvoicingDocument,
  key consno                                               as CASequenceNumber,
      @ObjectModel.foreignKey.association: '_CAInvcgRefPostgDocTyp'
      cast(cadoctype as cadoctype_gfn_kk preserving type ) as CAInvcgRefPostingDocType,
      @ObjectModel.foreignKey.association: '_CADocument'
      cast(opbel as opbel_gfn_kk preserving type)          as CADocumentNumber,
      opupw                                                as CARepetitionItemNumber,
      opupk                                                as CABPItemNumber,
      xnewdoc                                              as CAInvcgIsPostedInCurrentInvcg,

      _CAInvcgDocHeader,
      _CAInvcgRefPostgDocTyp,
      _CADocument
}