A_CAInvcgDocPosting

DDL: A_CAINVCGDOCPOSTING Type: view_entity CONSUMPTION
8 Fields 1 Data Sources 1 Associations

Invoicing Document Posting Doc Reference

A_CAInvcgDocPosting is a Consumption CDS View that provides data about "Invoicing Document Posting Doc Reference" in SAP S/4HANA. It reads from 1 data source (R_CAInvcgDocPostingTP) and exposes 8 fields with key fields CAInvoicingDocument, CASequenceNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_CAInvcgDocPostingTP R_CAInvcgDocPostingTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_CAInvcgDocument _CAInvcgDocument $projection.CAInvoicingDocument = _CAInvcgDocument.CAInvoicingDocument

Annotations (9)

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

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CAInvoicingDocument CAInvoicingDocument Invoic. Doc.
KEY CASequenceNumber CASequenceNumber
CAInvcgRefPostingDocType CAInvcgRefPostingDocType Ref. Doc. Type
CADocumentNumber CADocumentNumber Document Number
CARepetitionItemNumber CARepetitionItemNumber Repetition Item
CABPItemNumber CABPItemNumber Item
CAInvcgIsPostedInCurrentInvcg CAInvcgIsPostedInCurrentInvcg
_CAInvcgDocument _CAInvcgDocument

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_CAInvcgDocPosting.
-- 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_CAInvcgDocPosting AS
SELECT
  CAInvoicingDocument,
  CASequenceNumber,
  CAInvcgRefPostingDocType,
  CADocumentNumber,
  CARepetitionItemNumber,
  CABPItemNumber,
  CAInvcgIsPostedInCurrentInvcg
FROM R_CAInvcgDocPostingTP
LEFT OUTER JOIN A_CAInvcgDocument AS _CAInvcgDocument ON CAInvoicingDocument = _CAInvcgDocument.CAInvoicingDocument  -- association [1..1]
;

Learn More