C_CAInvcgOvwInvcgRequest

DDL: C_CAINVCGOVWINVCGREQUEST Type: view_entity CONSUMPTION Package: ODATA_O2C_CI_CUSTINVOVW

Fakturierungsaufträge anzeigen

C_CAInvcgOvwInvcgRequest is a Consumption CDS View that provides data about "Fakturierungsaufträge anzeigen" in SAP S/4HANA. It reads from 1 data source (I_CAInvcgRequest) and exposes 67 fields with key fields CAInvcgSourceDocumentCat, CAInvcgSourceDocumentNumber. It has 1 association to related views. Part of development package ODATA_O2C_CI_CUSTINVOVW.

1 data source(s) 67 fields

Data Sources (1)

SourceAliasJoin Type
I_CAInvcgRequest _CAInvcgRequest from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ContractAccountPartner _ContractAccountPartner $projection.ContractAccount = _ContractAccountPartner.ContractAccount and $projection.BusinessPartner = _ContractAccountPartner.BusinessPartner

Annotations (9)

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

Fields (67)

KeyFieldSource TableSource FieldDescription
KEY CAInvcgSourceDocumentCat CAInvcgSourceDocumentCat
KEY CAInvcgSourceDocumentNumber CAInvcgSourceDocumentNumber
CAInvcgSourceDocumentSemObj
BusinessPartner I_CAInvcgRequest BusinessPartner
BusinessPartnerName _BusinessPartner BusinessPartnerName
ContractAccount I_CAInvcgRequest ContractAccount
ContractAccountName _ContractAccountHeader ContractAccountName
TransactionCurrency I_CAInvcgRequest TransactionCurrency
CAInvcgSourceDocumentAmount I_CAInvcgRequest CAInvcgSourceDocumentAmount
CAInvcgFirstDate I_CAInvcgRequest CAInvcgFirstDate
CAInvcgReqCreationDate I_CAInvcgRequest CAInvcgReqCreationDate
AltvContractAcctForCollvBills I_CAInvcgRequest AltvContractAcctForCollvBills
BusinessPlace I_CAInvcgRequest BusinessPlace
CAApplicationArea I_CAInvcgRequest CAApplicationArea
CABillgDocOriginProcess I_CAInvcgRequest CABillgDocOriginProcess
CAInvcgReqEndDate I_CAInvcgRequest CAInvcgReqEndDate
CAInvcgReqStartDate I_CAInvcgRequest CAInvcgReqStartDate
CAContract I_CAInvcgRequest CAContract
CAContractSemanticObject
CAInvcgCategory I_CAInvcgRequest CAInvcgCategory
CAInvcgControlOfInvoicingUnit I_CAInvcgRequest CAInvcgControlOfInvoicingUnit
CAInvcgCorrectionCategory I_CAInvcgRequest CAInvcgCorrectionCategory
CAInvcgBaseDate I_CAInvcgRequest CAInvcgBaseDate
CAInvcgMasterDataType I_CAInvcgRequest CAInvcgMasterDataType
CAInvcgReqCreationUser I_CAInvcgRequest CAInvcgReqCreationUser
CAInvcgReqIsDocumentSimulated I_CAInvcgRequest CAInvcgReqIsDocumentSimulated
CAInvcgReqIsLockedForInvoicing I_CAInvcgRequest CAInvcgReqIsLockedForInvoicing
CAInvcgSourceDocumentType I_CAInvcgRequest CAInvcgSourceDocumentType
CAInvcgTargetProcess I_CAInvcgRequest CAInvcgTargetProcess
CAInvcgTechnicalDocumentType I_CAInvcgRequest CAInvcgTechnicalDocumentType
CAPartnerSettlementRule I_CAInvcgRequest CAPartnerSettlementRule
CABllbleItmNumber CABllbleItmNumber
CASubApplication I_CAInvcgRequest CASubApplication
CompanyCode I_CAInvcgRequest CompanyCode
Division I_CAInvcgRequest Division
LogicalSystem I_CAInvcgRequest LogicalSystem
CAInvcgSourceDocCatText
CAInvcgCategoryText
CAInvcgSourceDocTypeText
CAInvcgTargetProcText
CAInvcgDocTechDocTypeText
CASubApplicationText
CAInvcgMasterDataTypeText
CABillgDocOriginProcessText
CAInvcgCorrectionCatText
CAInvcgControlOfInvcgUnitTxt
CompanyCodeName
CAClrfctnCategory
_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 
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.privilegedAssociations: [ '_User' ]
@Metadata.allowExtensions: true
@ObjectModel: {
  representativeKey: 'CAInvcgSourceDocumentNumber',
  -- semanticKey: ['CAInvcgSourceDocumentNumber'], -- does not work together with dynamic sem obj
  usageType: {
    serviceQuality: #D,
    sizeCategory: #XL,
    dataClass: #MIXED
  }
}

@EndUserText.label: 'Fakturierungsaufträge anzeigen'
define view entity C_CAInvcgOvwInvcgRequest
  as select from I_CAInvcgRequest as _CAInvcgRequest
  association [0..1] to I_ContractAccountPartner as _ContractAccountPartner on  $projection.ContractAccount = _ContractAccountPartner.ContractAccount
                                                                            and $projection.BusinessPartner = _ContractAccountPartner.BusinessPartner
{

      @ObjectModel.text.element: ['CAInvcgSourceDocCatText']
  key CAInvcgSourceDocumentCat,

      //SRCDOCNO

  key CAInvcgSourceDocumentNumber,

      _CAInvcgRequest._CAInvcgSourceDocCat.CAInvcgSourceDocumentSemObj,

      @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,

      _CAInvcgRequest.AltvContractAcctForCollvBills,

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

      _CAInvcgRequest.CAApplicationArea,

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

      _CAInvcgRequest.CAInvcgReqEndDate,

      _CAInvcgRequest.CAInvcgReqStartDate,

      _CAInvcgRequest.CAContract,

      @ObjectModel: {
        readOnly: true,
        virtualElement: true,
        virtualElementCalculatedBy: 'ABAP:CL_CINV_VTREF_SEMOBJ'
      }
      cast ( '' as vtref_semobj_kk ) as CAContractSemanticObject,

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

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

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

      _CAInvcgRequest.CAInvcgBaseDate,

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

      _CAInvcgRequest.CAInvcgReqCreationUser,

      _CAInvcgRequest.CAInvcgReqIsDocumentSimulated,

      _CAInvcgRequest.CAInvcgReqIsLockedForInvoicing,

      @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[1: Language=$session.system_language].CAInvcgSourceDocCatText,
      _CAInvcgCategory._CAInvcgCategoryText[1: Language=$session.system_language].CAInvcgCategoryText,
      _CAInvcgSourceDocType._CAInvcgSourceDocTypeText[1: Language=$session.system_language].CAInvcgSourceDocTypeText,
      _CAInvcgTargetProc._CAInvcgTargetProcText[1: Language=$session.system_language].CAInvcgTargetProcText,
      _CAInvcgDocTechDocType._CAInvcgDocTechDocTypeText[1: Language=$session.system_language].CAInvcgDocTechDocTypeText,
      _CASubApplication._CASubApplicationText[1: Language=$session.system_language].CASubApplicationText,
      _CAInvcgMasterDataType._CAInvcgMasterDataTypeText[1: Language=$session.system_language].CAInvcgMasterDataTypeText,
      _CABillgDocOriginProcess._CABillgDocOriginProcessText[1: Language=$session.system_language].CABillgDocOriginProcessText,
      _CAInvcgCorrectionCat._CAInvcgCorrectionCatText[1: Language=$session.system_language].CAInvcgCorrectionCatText,
      _CAInvcgControlOfInvcgUnit._CAInvcgControlOfInvcgUnitTxt[1: Language=$session.system_language].CAInvcgControlOfInvcgUnitTxt,
      _CAInvcgRequest._CACompanyCode._CompanyCode.CompanyCodeName,


      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CINV_SADL_EXIT_INVREQ_DSP'
      cast (' ' as inv_cfccat_kk)    as CAClrfctnCategory,

      // Make association public


      _BusinessPartner,

      _ContractAccountPartner,

      _ContractAccountHeader,

      _AltvContractAccountHeader,

      _CAInvcgSourceDocCat,

      _CAInvcgCategory,

      _CAInvcgSourceDocType,

      _CAInvcgTargetProc,

      _CAInvcgDocTechDocType,

      _CASubApplication,

      _CAInvcgMasterDataType,

      _CABillgDocOriginProcess,

      _CAInvcgCorrectionCat,

      _CAInvcgControlOfInvcgUnit,

      _CACompanyCode,

      _Division,

      _TransactionCurrency,

      _CAApplicationArea,

      _User
}

Learn More