C_CAInvcgRequest

DDL: C_CAINVCGREQUEST Type: view_entity CONSUMPTION Package: ODATA_O2C_CI_INVREQUEST

Fakturierungsaufträge anzeigen

C_CAInvcgRequest is a Consumption CDS View that provides data about "Fakturierungsaufträge anzeigen" in SAP S/4HANA. It reads from 1 data source (R_CAInvcgRequestTP) and exposes 75 fields with key fields CAInvcgSourceDocumentCat, CAInvcgSourceDocumentNumber. Part of development package ODATA_O2C_CI_INVREQUEST.

Data Sources (1)

SourceAliasJoin Type
R_CAInvcgRequestTP R_CAInvcgRequestTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Metadata.allowExtensions true view
ObjectModel.representativeKey CAInvcgSourceDocumentNumber view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
Search.searchable true view
EndUserText.label Fakturierungsaufträge anzeigen view

Fields (75)

KeyFieldSource TableSource FieldDescription
KEY CAInvcgSourceDocumentCat CAInvcgSourceDocumentCat
KEY CAInvcgSourceDocumentNumber CAInvcgSourceDocumentNumber
CAInvcgSourceDocumentSemObj
FirstName
LastName
BusinessPartner _CAInvcgRequest BusinessPartner
BusinessPartnerName _BusinessPartner BusinessPartnerName
ContractAccount _CAInvcgRequest ContractAccount
ContractAccountName _ContractAccountHeader ContractAccountName
TransactionCurrency _CAInvcgRequest TransactionCurrency
CAInvcgSourceDocumentAmount _CAInvcgRequest CAInvcgSourceDocumentAmount
CAInvcgFirstDate _CAInvcgRequest CAInvcgFirstDate
CAInvcgReqCreationDate _CAInvcgRequest CAInvcgReqCreationDate
AltvContractAcctForCollvBills _CAInvcgRequest AltvContractAcctForCollvBills
AltvContrAcctForCollvBillsName _AltvContractAccountHeader ContractAccountName
BusinessPlace _CAInvcgRequest BusinessPlace
CAApplicationArea _CAInvcgRequest CAApplicationArea
CABillgDocOriginProcess _CAInvcgRequest CABillgDocOriginProcess
CAInvcgReqEndDate _CAInvcgRequest CAInvcgReqEndDate
CAInvcgReqStartDate _CAInvcgRequest CAInvcgReqStartDate
CAContract _CAInvcgRequest CAContract
CAInvcgCategory _CAInvcgRequest CAInvcgCategory
CAInvcgControlOfInvoicingUnit _CAInvcgRequest CAInvcgControlOfInvoicingUnit
CAInvcgCorrectionCategory _CAInvcgRequest CAInvcgCorrectionCategory
CAInvcgBaseDate _CAInvcgRequest CAInvcgBaseDate
CAInvcgMasterDataType _CAInvcgRequest CAInvcgMasterDataType
CAInvcgReqCreationUser _CAInvcgRequest CAInvcgReqCreationUser
CAInvcgReqIsDocumentSimulated _CAInvcgRequest CAInvcgReqIsDocumentSimulated
CAInvcgReqIsLockedForInvoicing _CAInvcgRequest CAInvcgReqIsLockedForInvoicing
CAInvcgReqLockReason _CAInvcgRequest CAInvcgReqLockReason
CAInvcgReqLockDate _CAInvcgRequest CAInvcgReqLockDate
CAInvcgReqLockedToDate _CAInvcgRequest CAInvcgReqLockedToDate
CAInvcgReqLockedByUser _CAInvcgRequest CAInvcgReqLockedByUser
CAInvcgSourceDocumentType _CAInvcgRequest CAInvcgSourceDocumentType
CAInvcgTargetProcess _CAInvcgRequest CAInvcgTargetProcess
CAInvcgTechnicalDocumentType _CAInvcgRequest CAInvcgTechnicalDocumentType
CAPartnerSettlementRule _CAInvcgRequest CAPartnerSettlementRule
CABllbleItmNumber CABllbleItmNumber
CASubApplication _CAInvcgRequest CASubApplication
CompanyCode _CAInvcgRequest CompanyCode
Division _CAInvcgRequest Division
LogicalSystem _CAInvcgRequest LogicalSystem
CAInvcgSourceDocCatTextlocalized
CAInvcgCategoryTextlocalized
CAInvcgReqLockTextlocalized
CAInvcgReqLockReasonTextlocalized
CAInvcgSourceDocTypeTextlocalized
CAInvcgTargetProcTextlocalized
CAInvcgDocTechDocTypeTextlocalized
CASubApplicationTextlocalized
CAInvcgMasterDataTypeTextlocalized
CABillgDocOriginProcessTextlocalized
CAInvcgCorrectionCatTextlocalized
CAInvcgControlOfInvcgUnitTxtlocalized
CompanyCodeName
virtualCAClrfctnCategoryinv_cfccat_kk
_BusinessPartner _BusinessPartner
_ContractAccountPartner _ContractAccountPartner
_ContractAccountHeader _ContractAccountHeader
_AltvContractAccountHeader _AltvContractAccountHeader
_CAInvcgSourceDocCat _CAInvcgSourceDocCat
_CAInvcgCategory _CAInvcgCategory
_CAInvcgSourceDocType _CAInvcgSourceDocType
_CAInvcgTargetProc _CAInvcgTargetProc
_CAInvcgDocTechDocType _CAInvcgDocTechDocType
_CASubApplication _CASubApplication
_CAInvcgMasterDataType _CAInvcgMasterDataType
_CABillgDocOriginProcess _CABillgDocOriginProcess
_CAInvcgCorrectionCat _CAInvcgCorrectionCat
_CAInvcgControlOfInvcgUnit _CAInvcgControlOfInvcgUnit
_CACompanyCode _CACompanyCode
_Division _Division
_TransactionCurrency _TransactionCurrency
_CAApplicationArea _CAApplicationArea
_User _User
@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #REQUIRED,
  privilegedAssociations: ['_User']
}
@Metadata.allowExtensions: true
@ObjectModel: {
  representativeKey: 'CAInvcgSourceDocumentNumber',
  -- semanticKey: ['CAInvcgSourceDocumentNumber'], -- does not work together with dynamic sem obj
  usageType: {
    serviceQuality: #C,
    sizeCategory: #XL,
    dataClass: #TRANSACTIONAL
  }
}
@VDM: {
  viewType: #CONSUMPTION,
  usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ]
}

@Search.searchable: true
@EndUserText.label: 'Fakturierungsaufträge anzeigen'
define root view entity C_CAInvcgRequest
  provider contract transactional_query
  as projection on R_CAInvcgRequestTP as _CAInvcgRequest
{
          @ObjectModel.text.element: ['CAInvcgSourceDocCatText']
  key     CAInvcgSourceDocumentCat,

          //SRCDOCNO

  key     CAInvcgSourceDocumentNumber,

          _CAInvcgRequest._CAInvcgSourceDocCat.CAInvcgSourceDocumentSemObj,

          //GPART

          @ObjectModel.filter.enabled: false
          _CAInvcgRequest._BusinessPartner.FirstName,

          @ObjectModel.filter.enabled: false
          _CAInvcgRequest._BusinessPartner.LastName,

          @ObjectModel.text.element: ['BusinessPartnerName']
          _CAInvcgRequest.BusinessPartner,

          _BusinessPartner.BusinessPartnerName,

          //VKONT

          @ObjectModel.text.element: ['ContractAccountName']
          _CAInvcgRequest.ContractAccount,

          _ContractAccountHeader.ContractAccountName,

          //WAERS

          _CAInvcgRequest.TransactionCurrency,

          //SRCDOC_AMOUNT

          _CAInvcgRequest.CAInvcgSourceDocumentAmount,

          //INVOICE_FIRST

          _CAInvcgRequest.CAInvcgFirstDate,

          //CRDATE

          _CAInvcgRequest.CAInvcgReqCreationDate,

          @ObjectModel.text.element: ['AltvContrAcctForCollvBillsName']
          _CAInvcgRequest.AltvContractAcctForCollvBills,

          _AltvContractAccountHeader.ContractAccountName as AltvContrAcctForCollvBillsName,

          @ObjectModel.filter.enabled: false
          _CAInvcgRequest.BusinessPlace,

          _CAInvcgRequest.CAApplicationArea,

          @ObjectModel.text.element: ['CABillgDocOriginProcessText']
          _CAInvcgRequest.CABillgDocOriginProcess,

          _CAInvcgRequest.CAInvcgReqEndDate,

          _CAInvcgRequest.CAInvcgReqStartDate,

          _CAInvcgRequest.CAContract,

          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CINV_VTREF_SEMOBJ'
  virtual CAContractSemanticObject      : vtref_semobj_kk,

          @ObjectModel.text.element: ['CAInvcgCategoryText']
          _CAInvcgRequest.CAInvcgCategory,

          @ObjectModel.text.element: ['CAInvcgControlOfInvcgUnitTxt']
          _CAInvcgRequest.CAInvcgControlOfInvoicingUnit,

          @ObjectModel.text.element: ['CAInvcgCorrectionCatText']
          _CAInvcgRequest.CAInvcgCorrectionCategory,

          @Consumption.filter.selectionType: #INTERVAL
          _CAInvcgRequest.CAInvcgBaseDate,

          @ObjectModel.text.element: ['CAInvcgMasterDataTypeText']
          _CAInvcgRequest.CAInvcgMasterDataType,

          _CAInvcgRequest.CAInvcgReqCreationUser,

          _CAInvcgRequest.CAInvcgReqIsDocumentSimulated,

          @ObjectModel.text.element: ['CAInvcgReqLockText']
          _CAInvcgRequest.CAInvcgReqIsLockedForInvoicing,

          @ObjectModel.text.element: ['CAInvcgReqLockReasonText']
          _CAInvcgRequest.CAInvcgReqLockReason,

          _CAInvcgRequest.CAInvcgReqLockDate,

          _CAInvcgRequest.CAInvcgReqLockedToDate,

          _CAInvcgRequest.CAInvcgReqLockedByUser,

          @ObjectModel.text.element: ['CAInvcgSourceDocTypeText']
          _CAInvcgRequest.CAInvcgSourceDocumentType,

          @ObjectModel.text.element: ['CAInvcgTargetProcText']
          _CAInvcgRequest.CAInvcgTargetProcess,

          @ObjectModel.text.element: ['CAInvcgDocTechDocTypeText']
          _CAInvcgRequest.CAInvcgTechnicalDocumentType,

          _CAInvcgRequest.CAPartnerSettlementRule,

          CABllbleItmNumber, // _CAInvcgRequest.CABllbleItmNumber,


          @ObjectModel.text.element: ['CASubApplicationText']
          _CAInvcgRequest.CASubApplication,

          @ObjectModel.text.element: ['CompanyCodeName']
          _CAInvcgRequest.CompanyCode,

          _CAInvcgRequest.Division,

          _CAInvcgRequest.LogicalSystem,


          _CAInvcgSourceDocCat._CAInvcgSourceDocCatText.CAInvcgSourceDocCatText                 : localized,

          _CAInvcgCategory._CAInvcgCategoryText.CAInvcgCategoryText                             : localized,

          _CAInvcgReqLock._Text.CAInvcgReqLockText                                              : localized,

          _CAInvcgReqLockReason._Text.CAInvcgReqLockReasonText                                  : localized,

          _CAInvcgSourceDocType._CAInvcgSourceDocTypeText.CAInvcgSourceDocTypeText              : localized,

          _CAInvcgTargetProc._CAInvcgTargetProcText.CAInvcgTargetProcText                       : localized,

          _CAInvcgDocTechDocType._CAInvcgDocTechDocTypeText.CAInvcgDocTechDocTypeText           : localized,

          _CASubApplication._CASubApplicationText.CASubApplicationText                          : localized,

          _CAInvcgMasterDataType._CAInvcgMasterDataTypeText.CAInvcgMasterDataTypeText           : localized,

          _CABillgDocOriginProcess._CABillgDocOriginProcessText.CABillgDocOriginProcessText     : localized,

          _CAInvcgCorrectionCat._CAInvcgCorrectionCatText.CAInvcgCorrectionCatText              : localized,

          _CAInvcgControlOfInvcgUnit._CAInvcgControlOfInvcgUnitTxt.CAInvcgControlOfInvcgUnitTxt : localized,

          _CACompanyCode._CompanyCode.CompanyCodeName,


          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CINV_SADL_EXIT_INVREQ_DSP'
  virtual CAClrfctnCategory             : inv_cfccat_kk,

          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CINV_SADL_EXIT_INVREQ_DSP'
  virtual CAInvcgClrfctnCreateIsEnabled : xfeld,


          // Make association public

          _BusinessPartner,
          _ContractAccountPartner,
          _ContractAccountHeader,
          _AltvContractAccountHeader,
          _CAInvcgSourceDocCat,
          _CAInvcgCategory,
          _CAInvcgSourceDocType,
          _CAInvcgTargetProc,
          _CAInvcgDocTechDocType,
          _CASubApplication,
          _CAInvcgMasterDataType,
          _CABillgDocOriginProcess,
          _CAInvcgCorrectionCat,
          _CAInvcgControlOfInvcgUnit,
          _CACompanyCode,
          _Division,
          _TransactionCurrency,
          _CAApplicationArea,
          _User
}