C_CAInvcgDocDisp
Fakturierungsbelege anzeigen
C_CAInvcgDocDisp is a Consumption CDS View that provides data about "Fakturierungsbelege anzeigen" in SAP S/4HANA. It reads from 1 data source (R_CAInvcgDocumentTP) and exposes 88 fields with key field CAInvoicingDocument. It has 11 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_CAInvcgDocumentTP | _CAInvcgDocHeader | from |
Associations (11)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..*] | C_CAInvcgDocItem | _CAInvcgDocItem | $projection.CAInvoicingDocument = _CAInvcgDocItem.CAInvoicingDocument |
| [1..*] | C_CAInvcgDocSource | _CAInvcgDocSource | $projection.CAInvoicingDocument = _CAInvcgDocSource.CAInvoicingDocument |
| [1..*] | C_CAInvcgDocPosting | _CAInvcgDocPosting | $projection.CAInvoicingDocument = _CAInvcgDocPosting.CAInvoicingDocument |
| [1..*] | C_CAInvcgDocRelation | _CAInvcgDocRelation | $projection.CAInvoicingDocument = _CAInvcgDocRelation.CAInvoicingDocument |
| [1..*] | C_CAInvcgDocContractAccount | _CAInvcgDocContractAccount | $projection.ContractAccount = _CAInvcgDocContractAccount.ContractAccount |
| [0..*] | C_CAInvcgDocPrintReceiver | _CAInvcgDocPrintReceiver | $projection.CAInvoicingDocument = _CAInvcgDocPrintReceiver.CAInvoicingDocument and $projection.CAInvcgProcess = _CAInvcgDocPrintReceiver.CAInvcgProcess and $projection.CAInvcgDocumentPrintDate is not initial and $projection.CAInvcgDocIsLockedForPrinting is initial and $projection.CAInvcgIsDocumentSimulated is initial |
| [0..1] | C_CAInvcgDocDisp | _CAInvcgReversedDocument | $projection.CAInvcgReversedDocument = _CAInvcgReversedDocument.CAInvoicingDocument |
| [0..1] | C_CAInvcgDocDisp | _CAInvcgReversalDocument | $projection.CAInvcgReversalDocument = _CAInvcgReversalDocument.CAInvoicingDocument |
| [0..1] | C_CAInvcgDocDisp | _CAInvcgAdjustedDocument | $projection.CAInvcgAdjustedDocument = _CAInvcgAdjustedDocument.CAInvoicingDocument |
| [0..1] | C_CAInvcgDocDisp | _CAInvcgAdjustmentDocument | $projection.CAInvcgAdjustmentDocument = _CAInvcgAdjustmentDocument.CAInvoicingDocument |
| [0..1] | E_CAInvcgDocHeader | _Extension | $projection.CAInvoicingDocument = _Extension.CAInvoicingDocument |
Annotations (17)
| Name | Value | Level | Field |
|---|---|---|---|
| VDM.viewType | #CONSUMPTION | view | |
| EndUserText.label | Fakturierungsbelege anzeigen | view | |
| Consumption.semanticObject | CAInvoicingDocument | view | |
| Search.searchable | true | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.representativeKey | CAInvoicingDocument | view | |
| Analytics.technicalName | CCAINVDOC_DISP | view | |
| UI.headerInfo.typeName | Fakturierungsbeleg anzeigen | view | |
| UI.headerInfo.typeNamePlural | Fakturierungsbelege | view | |
| UI.headerInfo.title.type | #STANDARD | view | |
| UI.headerInfo.title.value | CAInvoicingDocument | view | |
| VDM.lifecycle.status | #DEPRECATED | view | |
| VDM.lifecycle.successor | C_CAInvcgDocHeader | view |
Fields (88)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CAInvoicingDocument | R_CAInvcgDocumentTP | CAInvoicingDocument | Invoic. Doc. |
| UICT_CAInvoicingDocument | ||||
| CAOfficialDocumentNumber | R_CAInvcgDocumentTP | CAOfficialDocumentNumber | Offic. Doc. No. | |
| BusinessPartnerFullName | ||||
| BusinessPartner | R_CAInvcgDocumentTP | BusinessPartner | Issuing Authority | |
| ContractAccount | R_CAInvcgDocumentTP | ContractAccount | Contract Acct | |
| ContractAccountName | ||||
| CAInvcgType | R_CAInvcgDocumentTP | CAInvcgType | Invoicing Type | |
| CAInvcgTypeText | ||||
| CAInvcgDocPeriodDate | R_CAInvcgDocumentTP | CAInvcgDocPeriodDate | Invoicing Per. | |
| DocumentDate | R_CAInvcgDocumentTP | DocumentDate | Journal Entry Date | |
| TransactionCurrency | R_CAInvcgDocumentTP | TransactionCurrency | Transaction Currency | |
| CAAmountInTransactionCurrency | R_CAInvcgDocumentTP | CAAmountInTransactionCurrency | Amount | |
| CAInvcgProcess | R_CAInvcgDocumentTP | CAInvcgProcess | Invoicing Proc. | |
| CAInvcgProcessText | ||||
| CAInvcgDocumentType | R_CAInvcgDocumentTP | CAInvcgDocumentType | Document Type | |
| CAInvcgDocumentTypeText | ||||
| CADunningCounter | R_CAInvcgDocumentTP | CADunningCounter | Dunning counter | |
| CAInvcgDocHasControlDoc | R_CAInvcgDocumentTP | CAInvcgDocHasControlDoc | Clrfctn Case Control Doc | |
| ApplicationForm | R_CAInvcgDocumentTP | ApplicationForm | Forms | |
| CAInvcgDocumentPrintDate | R_CAInvcgDocumentTP | CAInvcgDocumentPrintDate | Print Date | |
| CAInvcgDocIsLockedForPrinting | R_CAInvcgDocumentTP | CAInvcgDocIsLockedForPrinting | Printing Lock | |
| CAInvcgDocLockedForPrintText | ||||
| CANetDueDate | R_CAInvcgDocumentTP | CANetDueDate | Net Due Date | |
| CAInvcgDocumentReversalReason | R_CAInvcgDocumentTP | CAInvcgDocumentReversalReason | Reversal Reason | |
| CAInvcgDocReversalReasonText | ||||
| CAInvcgIsDocumentPosted | R_CAInvcgDocumentTP | CAInvcgIsDocumentPosted | Document Posted | |
| CAInvcgIsDocumentPreliminary | R_CAInvcgDocumentTP | CAInvcgIsDocumentPreliminary | Preliminary Invoice | |
| CAInvcgIsDocumentSimulated | R_CAInvcgDocumentTP | CAInvcgIsDocumentSimulated | Doc. Simulated | |
| CAPostingDate | R_CAInvcgDocumentTP | CAPostingDate | Posting Date | |
| CAApplicationArea | R_CAInvcgDocumentTP | CAApplicationArea | ApplicationArea | |
| CAInvcgTechnicalDocumentType | R_CAInvcgDocumentTP | CAInvcgTechnicalDocumentType | Technical Document Type | |
| CAInvcgDocTechDocTypeText | ||||
| CAInvcgTargetProcess | R_CAInvcgDocumentTP | CAInvcgTargetProcess | Target Process | |
| CAInvcgTargetProcText | ||||
| CAInvcgMasterDataType | R_CAInvcgDocumentTP | CAInvcgMasterDataType | MasterData Type | |
| CAInvcgMasterDataTypeText | ||||
| AltvContractAcctForCollvBills | R_CAInvcgDocumentTP | AltvContractAcctForCollvBills | Coll. Bill Acct | |
| CASubstituteDocumentNumber | R_CAInvcgDocumentTP | CASubstituteDocumentNumber | Sub. Doc. | |
| CreatedByUser | R_CAInvcgDocumentTP | CreatedByUser | User Name | |
| CAInvcgCreationDate | R_CAInvcgDocumentTP | CAInvcgCreationDate | Invoiced On | |
| CAInvcgCreationTime | R_CAInvcgDocumentTP | CAInvcgCreationTime | Invoiced At | |
| CAInvcgDocCreationMode | R_CAInvcgDocumentTP | CAInvcgDocCreationMode | CreatnMode | |
| CAInvcgDocCreationModeText | ||||
| CAInvcgNmbrOfInvoicingDocItems | R_CAInvcgDocumentTP | CAInvcgNmbrOfInvoicingDocItems | Number of Items | |
| CABllbleItmNumber | R_CAInvcgDocumentTP | CABllbleItmNumber | Number of Billable Items | |
| CAReconciliationKey | R_CAInvcgDocumentTP | CAReconciliationKey | Reconcil. Key | |
| CAInvcgDocInternalNumber | R_CAInvcgDocumentTP | CAInvcgDocInternalNumber | Invoicg Run No. | |
| CACashDiscountDueDate | R_CAInvcgDocumentTP | CACashDiscountDueDate | Disct Due Date | |
| CACashDiscountRate | R_CAInvcgDocumentTP | CACashDiscountRate | Discount rate | |
| CAInvcgPreliminaryCategory | R_CAInvcgDocumentTP | CAInvcgPreliminaryCategory | Category Prlm Invoice | |
| CAInvcgPreliminaryCategoryTxt | ||||
| CAPrelimInvcgDocValue | R_CAInvcgDocumentTP | CAPrelimInvcgDocValue | Counter PrlmInv | |
| CAPreliminaryInvcgDocStatus | R_CAInvcgDocumentTP | CAPreliminaryInvcgDocStatus | Status Prlm Invoice | |
| CAPreliminaryInvcgDocStatusTxt | ||||
| CAInvcgCategory | R_CAInvcgDocumentTP | CAInvcgCategory | Invoicing Cat. | |
| CAInvcgCategoryText | ||||
| CAInvcgReversalDocument | R_CAInvcgDocumentTP | CAInvcgReversalDocument | Reversal Doc. | |
| CAInvcgReversedDocument | R_CAInvcgDocumentTP | CAInvcgReversedDocument | Reversed Invoicing Doc | |
| CAInvcgCorrectionCategory | R_CAInvcgDocumentTP | CAInvcgCorrectionCategory | Invcg Correction Category | |
| CAInvcgCorrectionCatText | ||||
| CAPaymentMethod | R_CAInvcgDocumentTP | CAPaymentMethod | Payment Method | |
| CAPaymentMethodName | ||||
| CAPaymentFormNumber | R_CAInvcgDocumentTP | CAPaymentFormNumber | Payment Form | |
| FormIDForAttachedPaymentMedium | R_CAInvcgDocumentTP | FormIDForAttachedPaymentMedium | Form ID | |
| CAKeyIdentification | R_CAInvcgDocumentTP | CAKeyIdentification | Key ID | |
| CAPartnerSettlementRule | R_CAInvcgDocumentTP | CAPartnerSettlementRule | Settlement Rule | |
| CompanyCode | R_CAInvcgDocumentTP | CompanyCode | Receiver Company Code | |
| CompanyCodeName | _CompanyCode | CompanyCodeName | Company Name | |
| BusinessPlace | R_CAInvcgDocumentTP | BusinessPlace | Business place | |
| CAInvcgBaseDate | R_CAInvcgDocumentTP | CAInvcgBaseDate | Baseline Date | |
| CAInvcgDocPeriodCategory | R_CAInvcgDocumentTP | CAInvcgDocPeriodCategory | Period Category | |
| CAInvcgPeriodCatText | ||||
| CAInvcgDocPeriodStartDate | R_CAInvcgDocumentTP | CAInvcgDocPeriodStartDate | Inv. Period Frm | |
| CAInvcgDocHasChargeOrDiscItems | R_CAInvcgDocumentTP | CAInvcgDocHasChargeOrDiscItems | Charge/Discount Exists | |
| CAInvcgDocChrgDiscItemsText | ||||
| CAInvcgBolloTaxPostStatus | R_CAInvcgDocumentTP | CAInvcgBolloTaxPostStatus | Bollo Posted | |
| CAInvcgBolloTaxPostStatText | ||||
| CAInvcgDocIsPartOfList | R_CAInvcgDocumentTP | CAInvcgDocIsPartOfList | Inv. Subdoc. | |
| CAInvcgDocPartOfListText | ||||
| CAInvcgDocHasObjectRelation | R_CAInvcgDocumentTP | CAInvcgDocHasObjectRelation | ObjRel. Exist | |
| CAInvcgDocHasSEPAPreNotif | R_CAInvcgDocumentTP | CAInvcgDocHasSEPAPreNotif | Pre-Notif. | |
| CAInvcgDocExternal | R_CAInvcgDocumentTP | CAInvcgDocExternal | External Invoicing Doc | |
| CAInvcgDocFormID | R_CAInvcgDocumentTP | CAInvcgDocFormID | Form ID | |
| CAInvcgAdjustmentDocument | R_CAInvcgDocumentTP | CAInvcgAdjustmentDocument | Adjustment Doc. | |
| CAInvcgAdjustedDocument | R_CAInvcgDocumentTP | CAInvcgAdjustedDocument | DocToBeAdjusted | |
| CAContract | R_CAInvcgDocumentTP | CAContract | Contract | |
| CAContractSemanticObject |
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 C_CAInvcgDocDisp.
-- 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 C_CAInvcgDocDisp AS
SELECT
_CAInvcgDocHeader.CAInvoicingDocument AS CAInvoicingDocument,
cast( '' as abap.char(50) ) AS UICT_CAInvoicingDocument,
_CAInvcgDocHeader.CAOfficialDocumentNumber AS CAOfficialDocumentNumber,
_CAInvcgDocHeader._BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
_CAInvcgDocHeader.BusinessPartner AS BusinessPartner,
_CAInvcgDocHeader.ContractAccount AS ContractAccount,
_CAInvcgDocHeader._ContractAccountHeader.ContractAccountName AS ContractAccountName,
_CAInvcgDocHeader.CAInvcgType AS CAInvcgType,
_CAInvcgType._CAInvcgTypeText[1: Language=$session.system_language].CAInvcgTypeText AS CAInvcgTypeText,
_CAInvcgDocHeader.CAInvcgDocPeriodDate AS CAInvcgDocPeriodDate,
_CAInvcgDocHeader.DocumentDate AS DocumentDate,
_CAInvcgDocHeader.TransactionCurrency AS TransactionCurrency,
_CAInvcgDocHeader.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
_CAInvcgDocHeader.CAInvcgProcess AS CAInvcgProcess,
_CAInvcgProcess._CAInvcgProcessText[1: Language=$session.system_language].CAInvcgProcessText AS CAInvcgProcessText,
_CAInvcgDocHeader.CAInvcgDocumentType AS CAInvcgDocumentType,
_CAInvcgDocumentType._CAInvcgDocumentTypeText[1: Language=$session.system_language].CAInvcgDocumentTypeText AS CAInvcgDocumentTypeText,
_CAInvcgDocHeader.CADunningCounter AS CADunningCounter,
_CAInvcgDocHeader.CAInvcgDocHasControlDoc AS CAInvcgDocHasControlDoc,
_CAInvcgDocHeader.ApplicationForm AS ApplicationForm,
_CAInvcgDocHeader.CAInvcgDocumentPrintDate AS CAInvcgDocumentPrintDate,
_CAInvcgDocHeader.CAInvcgDocIsLockedForPrinting AS CAInvcgDocIsLockedForPrinting,
_CAInvcgDocLockedforPrint._CAInvcgDocLockedForPrintText[1: Language=$session.system_language].CAInvcgDocLockedForPrintText AS CAInvcgDocLockedForPrintText,
_CAInvcgDocHeader.CANetDueDate AS CANetDueDate,
_CAInvcgDocHeader.CAInvcgDocumentReversalReason AS CAInvcgDocumentReversalReason,
_CAInvcgDocReversalReason._CAInvcgDocReversalReasonText[1: Language=$session.system_language].CAInvcgDocReversalReasonText AS CAInvcgDocReversalReasonText,
_CAInvcgDocHeader.CAInvcgIsDocumentPosted AS CAInvcgIsDocumentPosted,
_CAInvcgDocHeader.CAInvcgIsDocumentPreliminary AS CAInvcgIsDocumentPreliminary,
_CAInvcgDocHeader.CAInvcgIsDocumentSimulated AS CAInvcgIsDocumentSimulated,
_CAInvcgDocHeader.CAPostingDate AS CAPostingDate,
_CAInvcgDocHeader.CAApplicationArea AS CAApplicationArea,
_CAInvcgDocHeader.CAInvcgTechnicalDocumentType AS CAInvcgTechnicalDocumentType,
_CAInvcgDocTechDocType._CAInvcgDocTechDocTypeText[1: Language=$session.system_language].CAInvcgDocTechDocTypeText AS CAInvcgDocTechDocTypeText,
_CAInvcgDocHeader.CAInvcgTargetProcess AS CAInvcgTargetProcess,
_CAInvcgTargetProc._CAInvcgTargetProcText[1: Language=$session.system_language].CAInvcgTargetProcText AS CAInvcgTargetProcText,
_CAInvcgDocHeader.CAInvcgMasterDataType AS CAInvcgMasterDataType,
_CAInvcgMasterDataType._CAInvcgMasterDataTypeText[1: Language=$session.system_language].CAInvcgMasterDataTypeText AS CAInvcgMasterDataTypeText,
_CAInvcgDocHeader.AltvContractAcctForCollvBills AS AltvContractAcctForCollvBills,
_CAInvcgDocHeader.CASubstituteDocumentNumber AS CASubstituteDocumentNumber,
_CAInvcgDocHeader.CreatedByUser AS CreatedByUser,
_CAInvcgDocHeader.CAInvcgCreationDate AS CAInvcgCreationDate,
_CAInvcgDocHeader.CAInvcgCreationTime AS CAInvcgCreationTime,
_CAInvcgDocHeader.CAInvcgDocCreationMode AS CAInvcgDocCreationMode,
_CAInvcgDocCreationMode._CAInvcgDocCreationModeText[1: Language=$session.system_language].CAInvcgDocCreationModeText AS CAInvcgDocCreationModeText,
_CAInvcgDocHeader.CAInvcgNmbrOfInvoicingDocItems AS CAInvcgNmbrOfInvoicingDocItems,
_CAInvcgDocHeader.CABllbleItmNumber AS CABllbleItmNumber,
_CAInvcgDocHeader.CAReconciliationKey AS CAReconciliationKey,
_CAInvcgDocHeader.CAInvcgDocInternalNumber AS CAInvcgDocInternalNumber,
_CAInvcgDocHeader.CACashDiscountDueDate AS CACashDiscountDueDate,
_CAInvcgDocHeader.CACashDiscountRate AS CACashDiscountRate,
_CAInvcgDocHeader.CAInvcgPreliminaryCategory AS CAInvcgPreliminaryCategory,
_CAInvcgPreliminaryCategory._Text[1: Language=$session.system_language].CAInvcgPreliminaryCategoryTxt AS CAInvcgPreliminaryCategoryTxt,
_CAInvcgDocHeader.CAPrelimInvcgDocValue AS CAPrelimInvcgDocValue,
_CAInvcgDocHeader.CAPreliminaryInvcgDocStatus AS CAPreliminaryInvcgDocStatus,
_CAPreliminaryInvcgDocStatus._Text[1: Language=$session.system_language].CAPreliminaryInvcgDocStatusTxt AS CAPreliminaryInvcgDocStatusTxt,
_CAInvcgDocHeader.CAInvcgCategory AS CAInvcgCategory,
_CAInvcgCategory._CAInvcgCategoryText[1: Language=$session.system_language].CAInvcgCategoryText AS CAInvcgCategoryText,
_CAInvcgDocHeader.CAInvcgReversalDocument AS CAInvcgReversalDocument,
_CAInvcgDocHeader.CAInvcgReversedDocument AS CAInvcgReversedDocument,
_CAInvcgDocHeader.CAInvcgCorrectionCategory AS CAInvcgCorrectionCategory,
_CAInvcgCorrectionCat._CAInvcgCorrectionCatText[1: Language=$session.system_language].CAInvcgCorrectionCatText AS CAInvcgCorrectionCatText,
_CAInvcgDocHeader.CAPaymentMethod AS CAPaymentMethod,
_CAPaymentMethod._Text[1: Language=$session.system_language].CAPaymentMethodName AS CAPaymentMethodName,
_CAInvcgDocHeader.CAPaymentFormNumber AS CAPaymentFormNumber,
_CAInvcgDocHeader.FormIDForAttachedPaymentMedium AS FormIDForAttachedPaymentMedium,
_CAInvcgDocHeader.CAKeyIdentification AS CAKeyIdentification,
_CAInvcgDocHeader.CAPartnerSettlementRule AS CAPartnerSettlementRule,
_CAInvcgDocHeader.CompanyCode AS CompanyCode,
_CompanyCode.CompanyCodeName AS CompanyCodeName,
_CAInvcgDocHeader.BusinessPlace AS BusinessPlace,
_CAInvcgDocHeader.CAInvcgBaseDate AS CAInvcgBaseDate,
_CAInvcgDocHeader.CAInvcgDocPeriodCategory AS CAInvcgDocPeriodCategory,
_CAInvcgPeriodCat._CAInvcgPeriodCatText[1: Language=$session.system_language].CAInvcgPeriodCatText AS CAInvcgPeriodCatText,
_CAInvcgDocHeader.CAInvcgDocPeriodStartDate AS CAInvcgDocPeriodStartDate,
_CAInvcgDocHeader.CAInvcgDocHasChargeOrDiscItems AS CAInvcgDocHasChargeOrDiscItems,
_CAInvcgDocChrgDiscItems._CAInvcgDocChrgDiscItemsText[1: Language=$session.system_language].CAInvcgDocChrgDiscItemsText AS CAInvcgDocChrgDiscItemsText,
_CAInvcgDocHeader.CAInvcgBolloTaxPostStatus AS CAInvcgBolloTaxPostStatus,
_CAInvcgBolloTaxPostStatus._CAInvcgBolloTaxPostStatText[1: Language=$session.system_language].CAInvcgBolloTaxPostStatText AS CAInvcgBolloTaxPostStatText,
_CAInvcgDocHeader.CAInvcgDocIsPartOfList AS CAInvcgDocIsPartOfList,
_CAInvcgDocPartOfList._CAInvcgDocPartOfListText[1: Language=$session.system_language].CAInvcgDocPartOfListText AS CAInvcgDocPartOfListText,
_CAInvcgDocHeader.CAInvcgDocHasObjectRelation AS CAInvcgDocHasObjectRelation,
_CAInvcgDocHeader.CAInvcgDocHasSEPAPreNotif AS CAInvcgDocHasSEPAPreNotif,
_CAInvcgDocHeader.CAInvcgDocExternal AS CAInvcgDocExternal,
_CAInvcgDocHeader.CAInvcgDocFormID AS CAInvcgDocFormID,
_CAInvcgDocHeader.CAInvcgAdjustmentDocument AS CAInvcgAdjustmentDocument,
_CAInvcgDocHeader.CAInvcgAdjustedDocument AS CAInvcgAdjustedDocument,
_CAInvcgDocHeader.CAContract AS CAContract,
cast ( '' as vtref_semobj_kk ) AS CAContractSemanticObject
FROM R_CAInvcgDocumentTP AS _CAInvcgDocHeader
LEFT OUTER JOIN C_CAInvcgDocItem AS _CAInvcgDocItem ON CAInvoicingDocument = _CAInvcgDocItem.CAInvoicingDocument -- association [1..*]
LEFT OUTER JOIN C_CAInvcgDocSource AS _CAInvcgDocSource ON CAInvoicingDocument = _CAInvcgDocSource.CAInvoicingDocument -- association [1..*]
LEFT OUTER JOIN C_CAInvcgDocPosting AS _CAInvcgDocPosting ON CAInvoicingDocument = _CAInvcgDocPosting.CAInvoicingDocument -- association [1..*]
LEFT OUTER JOIN C_CAInvcgDocRelation AS _CAInvcgDocRelation ON CAInvoicingDocument = _CAInvcgDocRelation.CAInvoicingDocument -- association [1..*]
LEFT OUTER JOIN C_CAInvcgDocContractAccount AS _CAInvcgDocContractAccount ON ContractAccount = _CAInvcgDocContractAccount.ContractAccount -- association [1..*]
LEFT OUTER JOIN C_CAInvcgDocPrintReceiver AS _CAInvcgDocPrintReceiver ON CAInvoicingDocument = _CAInvcgDocPrintReceiver.CAInvoicingDocument AND CAInvcgProcess = _CAInvcgDocPrintReceiver.CAInvcgProcess AND CAInvcgDocumentPrintDate is not initial AND CAInvcgDocIsLockedForPrinting is initial AND CAInvcgIsDocumentSimulated is initial -- association [0..*]
LEFT OUTER JOIN C_CAInvcgDocDisp AS _CAInvcgReversedDocument ON CAInvcgReversedDocument = _CAInvcgReversedDocument.CAInvoicingDocument -- association [0..1]
LEFT OUTER JOIN C_CAInvcgDocDisp AS _CAInvcgReversalDocument ON CAInvcgReversalDocument = _CAInvcgReversalDocument.CAInvoicingDocument -- association [0..1]
LEFT OUTER JOIN C_CAInvcgDocDisp AS _CAInvcgAdjustedDocument ON CAInvcgAdjustedDocument = _CAInvcgAdjustedDocument.CAInvoicingDocument -- association [0..1]
LEFT OUTER JOIN C_CAInvcgDocDisp AS _CAInvcgAdjustmentDocument ON CAInvcgAdjustmentDocument = _CAInvcgAdjustmentDocument.CAInvoicingDocument -- association [0..1]
LEFT OUTER JOIN E_CAInvcgDocHeader AS _Extension ON CAInvoicingDocument = _Extension.CAInvoicingDocument -- association [0..1]
;
Learn More
- S/4HANA CDS View Deprecation: What You Need to Know
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA