I_CN_TAXINVCBINDGRECDACTV

CDS View

China Tax Invoice Bind Record

I_CN_TAXINVCBINDGRECDACTV is a CDS View in S/4HANA. China Tax Invoice Bind Record. It contains 10 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_CN_TaxInvoiceBindingRecord view from BASIC China Input Tax Invoice Binding Record
C_CN_TaxInvcBindgRecdActv view from CONSUMPTION China Tax Invoice Bind Record
I_CN_TaxInvcBindgRecd view from BASIC China Tax Invoice Bind Record

Fields (10)

KeyField CDS FieldsUsed in Views
KEY CN_TaxInvcBindgItmUUID CN_TaxInvcBindgItmUUID 3
KEY CN_TaxInvcBindgUUID CN_TaxInvcBindgUUID 3
CN_TaxEntityID CN_TaxEntityID 1
CN_TaxInvcBindgSrceBusObjKey CN_TaxInvcBindgSrceBusObjKey 3
CN_TaxInvcBindgSrceBusObjType CN_TaxInvcBindgSrceBusObjType 3
CN_TaxInvcUUID CN_TaxInvcUUID 2
CreatedByUser CreatedByUser 1
CreationUTCDateTime CreationUTCDateTime 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog: {
    sqlViewName: 'ICNTXIBNDGRECDAC',
    compiler.compareFilter: true
}
@VDM: {
    viewType: #BASIC,
    private: false
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'China Tax Invoice Bind Record'
@ObjectModel: {
  usageType: {
    serviceQuality: #A,
    sizeCategory: #XL,
    dataClass: #TRANSACTIONAL
  }
}

define view I_CN_TaxInvcBindgRecdActv
  as select from I_CN_TaxInvcBindgItm as _item
    inner join   I_CN_TaxInvcBindgHdr as _head on _item.CN_TaxInvcBindgUUID = _head.CN_TaxInvcBindgUUID
{
  key _item.CN_TaxInvcBindgUUID,

  key _item.CN_TaxInvcBindgItmUUID,
  
      _item.CN_TaxInvcUUID                         as CN_TaxInvcUUID, 

      _head.CN_TaxInvcBindgSrceBusObjType,
      
      _head.CN_TaxInvcBindgSrceBusObjKey,
      
      _item.CN_TaxEntityID,
      
      _item.CreatedByUser                          as CreatedByUser,
      
      _item.CreationUTCDateTime                    as CreationUTCDateTime,
      
      _item.LastChangedByUser                      as LastChangedByUser,
      
      _item.LastChangeDateTime                     as LastChangeDateTime
      
}