R_CAInvcgRequestTP

DDL: R_CAINVCGREQUESTTP Type: view_entity TRANSACTIONAL
59 Fields 1 Data Sources

Invoicing Request - TP

R_CAInvcgRequestTP is a Transactional CDS View that provides data about "Invoicing Request - TP" in SAP S/4HANA. It reads from 1 data source (I_CAInvcgRequest) and exposes 59 fields with key fields CAInvcgSourceDocumentCat, CAInvcgSourceDocumentNumber.

Data Sources (1)

SourceAliasJoin Type
I_CAInvcgRequest I_CAInvcgRequest from

Annotations (10)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Invoicing Request - TP view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey CAInvcgSourceDocumentNumber view
ObjectModel.sapObjectNodeType.name ContrAcctgInvoicingRequest view

Fields (59)

KeyFieldSource TableSource FieldDescription
KEY CAInvcgSourceDocumentCat CAInvcgSourceDocumentCat Source Document Category
KEY CAInvcgSourceDocumentNumber CAInvcgSourceDocumentNumber Source Document Number
AltvContractAcctForCollvBills AltvContractAcctForCollvBills Coll. Bill Acct
CAApplicationArea CAApplicationArea ApplicationArea
CompanyCode CompanyCode Receiver Company Code
BusinessPlace BusinessPlace Business place
CAInvcgCorrectionCategory CAInvcgCorrectionCategory Invcg Correction Category
CAInvcgReqCreationDate CAInvcgReqCreationDate Sizing Date
CAInvcgReqCreationUser CAInvcgReqCreationUser Last Changed By
CAInvcgReqStartDate CAInvcgReqStartDate
CAInvcgReqEndDate CAInvcgReqEndDate
BusinessPartner BusinessPartner Issuing Authority
CAInvcgCategory CAInvcgCategory Invoicing Cat.
CAInvcgBaseDate CAInvcgBaseDate Baseline Date
CAInvcgFirstDate CAInvcgFirstDate Invoice From
CAInvcgReqIsLockedForInvoicing CAInvcgReqIsLockedForInvoicing Invoicing Lock
CAInvcgReqLockReason CAInvcgReqLockReason Lock Reason
CAInvcgReqLockDate CAInvcgReqLockDate
CAInvcgReqLockedToDate CAInvcgReqLockedToDate
CAInvcgReqLockedByUser CAInvcgReqLockedByUser
LogicalSystem LogicalSystem Logical System
CAInvcgMasterDataType CAInvcgMasterDataType MasterData Type
CAPartnerSettlementRule CAPartnerSettlementRule Settlement Rule
CASourceDocumentNumberOfItems CASourceDocumentNumberOfItems Number of Items
CABllbleItmNumber CABllbleItmNumber Number of Billable Items
CAInvcgControlOfInvoicingUnit CAInvcgControlOfInvoicingUnit Invoicing Unit Control
CAInvcgReqIsDocumentSimulated CAInvcgReqIsDocumentSimulated
Division Division Internal Division ID
CAInvcgSourceDocumentAmount CAInvcgSourceDocumentAmount Amount in SrcDoc Crcy
CASourceDocumentCreationDate CASourceDocumentCreationDate Created On
CAInvcgSourceDocumentType CAInvcgSourceDocumentType Source Doc.Type
CABillgDocOriginProcess CABillgDocOriginProcess Origin
CASubApplication CASubApplication Subapplication
CAInvcgTargetProcess CAInvcgTargetProcess Target Process
CAInvcgTechnicalDocumentType CAInvcgTechnicalDocumentType Technical Document Type
ContractAccount ContractAccount Contract Acct
CAContract CAContract Contract
TransactionCurrency TransactionCurrency Transaction Currency
_ContractAccountPartner _ContractAccountPartner
_AltvContractAccountHeader _AltvContractAccountHeader
_BusinessPartner _BusinessPartner
_CAApplicationArea _CAApplicationArea
_CABillgDocOriginProcess _CABillgDocOriginProcess
_CACompanyCode _CACompanyCode
_CAInvcgCategory _CAInvcgCategory
_CAInvcgReqLock _CAInvcgReqLock
_CAInvcgReqLockReason _CAInvcgReqLockReason
_CAInvcgControlOfInvcgUnit _CAInvcgControlOfInvcgUnit
_CAInvcgCorrectionCat _CAInvcgCorrectionCat
_CAInvcgDocTechDocType _CAInvcgDocTechDocType
_CAInvcgMasterDataType _CAInvcgMasterDataType
_CAInvcgSourceDocCat _CAInvcgSourceDocCat
_CAInvcgSourceDocType _CAInvcgSourceDocType
_CAInvcgTargetProc _CAInvcgTargetProc
_CASubApplication _CASubApplication
_ContractAccountHeader _ContractAccountHeader
_Division _Division
_TransactionCurrency _TransactionCurrency
_User _User

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_CAInvcgRequestTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_CAInvcgRequestTP AS
SELECT
  CAInvcgSourceDocumentCat,
  CAInvcgSourceDocumentNumber,
  AltvContractAcctForCollvBills,
  CAApplicationArea,
  CompanyCode,
  BusinessPlace,
  CAInvcgCorrectionCategory,
  CAInvcgReqCreationDate,
  CAInvcgReqCreationUser,
  CAInvcgReqStartDate,
  CAInvcgReqEndDate,
  BusinessPartner,
  CAInvcgCategory,
  CAInvcgBaseDate,
  CAInvcgFirstDate,
  CAInvcgReqIsLockedForInvoicing,
  CAInvcgReqLockReason,
  CAInvcgReqLockDate,
  CAInvcgReqLockedToDate,
  CAInvcgReqLockedByUser,
  LogicalSystem,
  CAInvcgMasterDataType,
  CAPartnerSettlementRule,
  CASourceDocumentNumberOfItems,
  CABllbleItmNumber,
  CAInvcgControlOfInvoicingUnit,
  CAInvcgReqIsDocumentSimulated,
  Division,
  CAInvcgSourceDocumentAmount,
  CASourceDocumentCreationDate,
  CAInvcgSourceDocumentType,
  CABillgDocOriginProcess,
  CASubApplication,
  CAInvcgTargetProcess,
  CAInvcgTechnicalDocumentType,
  ContractAccount,
  CAContract,
  TransactionCurrency
FROM I_CAInvcgRequest
;

Learn More