A_CAInvcgDocument

DDL: A_CAINVCGDOCUMENT Type: view_entity CONSUMPTION
74 Fields 1 Data Sources 6 Associations

Invoicing Document

A_CAInvcgDocument is a Consumption CDS View that provides data about "Invoicing Document" in SAP S/4HANA. It reads from 1 data source (R_CAInvcgDocumentTP) and exposes 74 fields with key field CAInvoicingDocument. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_CAInvcgDocumentTP R_CAInvcgDocumentTP projection

Associations (6)

CardinalityTargetAliasCondition
[0..*] A_CAInvcgDocPosting _CAInvcgDocPosting $projection.CAInvoicingDocument = _CAInvcgDocPosting.CAInvoicingDocument
[0..*] A_CAInvcgDocSource _CAInvcgDocSource $projection.CAInvoicingDocument = _CAInvcgDocSource.CAInvoicingDocument
[0..*] A_CAInvcgDocOffsetting _CAInvcgDocOffsetting $projection.CAInvoicingDocument = _CAInvcgDocOffsetting.CAInvoicingDocument
[0..*] A_CAInvcgDocChargeAndDiscount _CAInvcgDocChargeAndDiscount $projection.CAInvoicingDocument = _CAInvcgDocChargeAndDiscount.CAInvoicingDocument
[0..*] A_CAInvcgDocChrgAndDiscHistory _CAInvcgDocChrgAndDiscHistory $projection.CAInvoicingDocument = _CAInvcgDocChrgAndDiscHistory.CAInvoicingDocument
[0..*] A_CAInvcgDocRelation _CAInvcgDocRelation $projection.CAInvoicingDocument = _CAInvcgDocRelation.CAInvoicingDocument

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Invoicing Document view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
OData.entityType.name CAInvcgDocument_Type view

Fields (74)

KeyFieldSource TableSource FieldDescription
KEY CAInvoicingDocument CAInvoicingDocument Invoic. Doc.
CAApplicationArea CAApplicationArea ApplicationArea
CAInvcgProcess CAInvcgProcess Invoicing Proc.
CAInvcgType CAInvcgType Invoicing Type
CAInvcgCategory CAInvcgCategory Invoicing Cat.
CAInvcgTechnicalDocumentType CAInvcgTechnicalDocumentType Technical Document Type
CAInvcgTargetProcess CAInvcgTargetProcess Target Process
BusinessPartner BusinessPartner Issuing Authority
ContractAccount ContractAccount Contract Acct
CAInvcgMasterDataType CAInvcgMasterDataType MasterData Type
AltvContractAcctForCollvBills AltvContractAcctForCollvBills Coll. Bill Acct
CASubstituteDocumentNumber CASubstituteDocumentNumber Sub. Doc.
CreatedByUser CreatedByUser User Name
CAInvcgCreationDate CAInvcgCreationDate Invoiced On
CAInvcgCreationTime CAInvcgCreationTime Invoiced At
CAInvcgDocCreationMode CAInvcgDocCreationMode CreatnMode
CAInvcgNmbrOfInvoicingDocItems CAInvcgNmbrOfInvoicingDocItems Number of Items
CABllbleItmNumber CABllbleItmNumber Number of Billable Items
CAInvcgDocInternalNumber CAInvcgDocInternalNumber Invoicg Run No.
CAReconciliationKey CAReconciliationKey Reconcil. Key
CAPostingDate CAPostingDate Posting Date
DocumentDate DocumentDate Journal Entry Date
CANetDueDate CANetDueDate Net Due Date
CACashDiscountDueDate CACashDiscountDueDate Disct Due Date
CACashDiscountRate CACashDiscountRate Discount rate
TransactionCurrency TransactionCurrency Transaction Currency
CAAmountInTransactionCurrency CAAmountInTransactionCurrency Amount
CAInvcgIsDocumentPosted CAInvcgIsDocumentPosted Document Posted
CAInvcgIsDocumentSimulated CAInvcgIsDocumentSimulated Doc. Simulated
CAInvcgIsDocumentPreliminary CAInvcgIsDocumentPreliminary Preliminary Invoice
CAInvcgPreliminaryCategory CAInvcgPreliminaryCategory Category Prlm Invoice
CAPrelimInvcgDocValue CAPrelimInvcgDocValue Counter PrlmInv
CAPreliminaryInvcgDocStatus CAPreliminaryInvcgDocStatus Status Prlm Invoice
CAInvcgDocumentReversalReason CAInvcgDocumentReversalReason Reversal Reason
CAInvcgReversalDocument CAInvcgReversalDocument Reversal Doc.
CAInvcgReversedDocument CAInvcgReversedDocument Reversed Invoicing Doc
CAInvcgCorrectionCategory CAInvcgCorrectionCategory Invcg Correction Category
CAInvcgDocumentPrintDate CAInvcgDocumentPrintDate Print Date
CAInvcgDocIsLockedForPrinting CAInvcgDocIsLockedForPrinting Printing Lock
CAPaymentMethod CAPaymentMethod Payment Method
CAPaymentFormNumber CAPaymentFormNumber Payment Form
CAInvcgDocFormID CAInvcgDocFormID Form ID
ApplicationForm ApplicationForm Forms
FormIDForAttachedPaymentMedium FormIDForAttachedPaymentMedium Form ID
CAInvcgDocumentType CAInvcgDocumentType Document Type
CAKeyIdentification CAKeyIdentification Key ID
CAOfficialDocumentNumber CAOfficialDocumentNumber Offic. Doc. No.
CAPartnerSettlementRule CAPartnerSettlementRule Settlement Rule
CompanyCode CompanyCode Receiver Company Code
BusinessPlace BusinessPlace Business place
CAContract CAContract Contract
CASubApplication CASubApplication Subapplication
CAInvcgBaseDate CAInvcgBaseDate Baseline Date
CAInvcgDocPeriodCategory CAInvcgDocPeriodCategory Period Category
CAInvcgDocPeriodDate CAInvcgDocPeriodDate Invoicing Per.
CAInvcgDocPeriodStartDate CAInvcgDocPeriodStartDate Inv. Period Frm
CADunningCounter CADunningCounter Dunning counter
CAInvcgDocHasChargeOrDiscItems CAInvcgDocHasChargeOrDiscItems Charge/Discount Exists
CAInvcgDocHasControlDoc CAInvcgDocHasControlDoc Clrfctn Case Control Doc
CAInvcgBolloTaxPostStatus CAInvcgBolloTaxPostStatus Bollo Posted
CAInvcgDocIsPartOfList CAInvcgDocIsPartOfList Inv. Subdoc.
CAInvcgDocHasObjectRelation CAInvcgDocHasObjectRelation ObjRel. Exist
CAInvcgDocHasSEPAPreNotif CAInvcgDocHasSEPAPreNotif Pre-Notif.
CAInvcgDocExternal CAInvcgDocExternal External Invoicing Doc
CAInvcgAdjustmentDocument CAInvcgAdjustmentDocument Adjustment Doc.
CAInvcgAdjustedDocument CAInvcgAdjustedDocument DocToBeAdjusted
_ContractAccountHeader _ContractAccountHeader
_ContractAccountPartner _ContractAccountPartner
_CAInvcgDocPosting _CAInvcgDocPosting
_CAInvcgDocSource _CAInvcgDocSource
_CAInvcgDocOffsetting _CAInvcgDocOffsetting
_CAInvcgDocChargeAndDiscount _CAInvcgDocChargeAndDiscount
_CAInvcgDocChrgAndDiscHistory _CAInvcgDocChrgAndDiscHistory
_CAInvcgDocRelation _CAInvcgDocRelation

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 A_CAInvcgDocument.
-- 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 A_CAInvcgDocument AS
SELECT
  CAInvoicingDocument,
  CAApplicationArea,
  CAInvcgProcess,
  CAInvcgType,
  CAInvcgCategory,
  CAInvcgTechnicalDocumentType,
  CAInvcgTargetProcess,
  BusinessPartner,
  ContractAccount,
  CAInvcgMasterDataType,
  AltvContractAcctForCollvBills,
  CASubstituteDocumentNumber,
  CreatedByUser,
  CAInvcgCreationDate,
  CAInvcgCreationTime,
  CAInvcgDocCreationMode,
  CAInvcgNmbrOfInvoicingDocItems,
  CABllbleItmNumber,
  CAInvcgDocInternalNumber,
  CAReconciliationKey,
  CAPostingDate,
  DocumentDate,
  CANetDueDate,
  CACashDiscountDueDate,
  CACashDiscountRate,
  TransactionCurrency,
  CAAmountInTransactionCurrency,
  CAInvcgIsDocumentPosted,
  CAInvcgIsDocumentSimulated,
  CAInvcgIsDocumentPreliminary,
  CAInvcgPreliminaryCategory,
  CAPrelimInvcgDocValue,
  CAPreliminaryInvcgDocStatus,
  CAInvcgDocumentReversalReason,
  CAInvcgReversalDocument,
  CAInvcgReversedDocument,
  CAInvcgCorrectionCategory,
  CAInvcgDocumentPrintDate,
  CAInvcgDocIsLockedForPrinting,
  CAPaymentMethod,
  CAPaymentFormNumber,
  CAInvcgDocFormID,
  ApplicationForm,
  FormIDForAttachedPaymentMedium,
  CAInvcgDocumentType,
  CAKeyIdentification,
  CAOfficialDocumentNumber,
  CAPartnerSettlementRule,
  CompanyCode,
  BusinessPlace,
  CAContract,
  CASubApplication,
  CAInvcgBaseDate,
  CAInvcgDocPeriodCategory,
  CAInvcgDocPeriodDate,
  CAInvcgDocPeriodStartDate,
  CADunningCounter,
  CAInvcgDocHasChargeOrDiscItems,
  CAInvcgDocHasControlDoc,
  CAInvcgBolloTaxPostStatus,
  CAInvcgDocIsPartOfList,
  CAInvcgDocHasObjectRelation,
  CAInvcgDocHasSEPAPreNotif,
  CAInvcgDocExternal,
  CAInvcgAdjustmentDocument,
  CAInvcgAdjustedDocument
FROM R_CAInvcgDocumentTP
LEFT OUTER JOIN A_CAInvcgDocPosting AS _CAInvcgDocPosting ON CAInvoicingDocument = _CAInvcgDocPosting.CAInvoicingDocument  -- association [0..*]
LEFT OUTER JOIN A_CAInvcgDocSource AS _CAInvcgDocSource ON CAInvoicingDocument = _CAInvcgDocSource.CAInvoicingDocument  -- association [0..*]
LEFT OUTER JOIN A_CAInvcgDocOffsetting AS _CAInvcgDocOffsetting ON CAInvoicingDocument = _CAInvcgDocOffsetting.CAInvoicingDocument  -- association [0..*]
LEFT OUTER JOIN A_CAInvcgDocChargeAndDiscount AS _CAInvcgDocChargeAndDiscount ON CAInvoicingDocument = _CAInvcgDocChargeAndDiscount.CAInvoicingDocument  -- association [0..*]
LEFT OUTER JOIN A_CAInvcgDocChrgAndDiscHistory AS _CAInvcgDocChrgAndDiscHistory ON CAInvoicingDocument = _CAInvcgDocChrgAndDiscHistory.CAInvoicingDocument  -- association [0..*]
LEFT OUTER JOIN A_CAInvcgDocRelation AS _CAInvcgDocRelation ON CAInvoicingDocument = _CAInvcgDocRelation.CAInvoicingDocument  -- association [0..*]
;

Learn More