C_CANotDisputedInvcgDoc
Not disputed invoicing document
C_CANotDisputedInvcgDoc is a Consumption CDS View that provides data about "Not disputed invoicing document" in SAP S/4HANA. It reads from 1 data source (I_CAInvcgDocHeader) and exposes 88 fields with key field CAInvoicingDocument.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_CAInvcgDocHeader | _CAInvcgDocHeader | from |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| VDM.viewType | #CONSUMPTION | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.query.implementedBy | ABAP:CL_FICA_DM_QRY_NOT_DIS_INV_DOC | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| Metadata.allowExtensions | true | view | |
| EndUserText.label | Not disputed invoicing document | view |
Fields (88)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CAInvoicingDocument | I_CAInvcgDocHeader | CAInvoicingDocument | Invoic. Doc. |
| CaseUUID | ||||
| CAOfficialDocumentNumber | I_CAInvcgDocHeader | CAOfficialDocumentNumber | Offic. Doc. No. | |
| FirstName | ||||
| LastName | ||||
| BusinessPartnerFullName | ||||
| BusinessPartner | I_CAInvcgDocHeader | BusinessPartner | Issuing Authority | |
| ContractAccount | I_CAInvcgDocHeader | ContractAccount | Contract Acct | |
| ContractAccountName | ||||
| CAInvcgType | I_CAInvcgDocHeader | CAInvcgType | Invoicing Type | |
| CAInvcgDocPeriodDate | I_CAInvcgDocHeader | CAInvcgDocPeriodDate | Invoicing Per. | |
| DocumentDate | I_CAInvcgDocHeader | DocumentDate | Journal Entry Date | |
| TransactionCurrency | I_CAInvcgDocHeader | TransactionCurrency | Transaction Currency | |
| CAAmountInTransactionCurrency | I_CAInvcgDocHeader | CAAmountInTransactionCurrency | Amount | |
| CAInvcgProcess | I_CAInvcgDocHeader | CAInvcgProcess | Invoicing Proc. | |
| CAInvcgDocumentType | I_CAInvcgDocHeader | CAInvcgDocumentType | Document Type | |
| CADunningCounter | I_CAInvcgDocHeader | CADunningCounter | Dunning counter | |
| CAInvcgDocHasControlDoc | I_CAInvcgDocHeader | CAInvcgDocHasControlDoc | Clrfctn Case Control Doc | |
| ApplicationForm | I_CAInvcgDocHeader | ApplicationForm | Forms | |
| CAInvcgDocumentPrintDate | I_CAInvcgDocHeader | CAInvcgDocumentPrintDate | Print Date | |
| CAInvcgDocIsLockedForPrinting | I_CAInvcgDocHeader | CAInvcgDocIsLockedForPrinting | Printing Lock | |
| CANetDueDate | I_CAInvcgDocHeader | CANetDueDate | Net Due Date | |
| CAInvcgDocumentReversalReason | I_CAInvcgDocHeader | CAInvcgDocumentReversalReason | Reversal Reason | |
| CAInvcgIsDocumentPosted | I_CAInvcgDocHeader | CAInvcgIsDocumentPosted | Document Posted | |
| CAInvcgIsDocumentPreliminary | I_CAInvcgDocHeader | CAInvcgIsDocumentPreliminary | Preliminary Invoice | |
| CAInvcgIsDocumentSimulated | I_CAInvcgDocHeader | CAInvcgIsDocumentSimulated | Doc. Simulated | |
| CAPostingDate | I_CAInvcgDocHeader | CAPostingDate | Posting Date | |
| CAApplicationArea | I_CAInvcgDocHeader | CAApplicationArea | ApplicationArea | |
| CAInvcgTechnicalDocumentType | I_CAInvcgDocHeader | CAInvcgTechnicalDocumentType | Technical Document Type | |
| CAInvcgTargetProcess | I_CAInvcgDocHeader | CAInvcgTargetProcess | Target Process | |
| CAInvcgMasterDataType | I_CAInvcgDocHeader | CAInvcgMasterDataType | MasterData Type | |
| AltvContractAcctForCollvBills | I_CAInvcgDocHeader | AltvContractAcctForCollvBills | Coll. Bill Acct | |
| CASubstituteDocumentNumber | I_CAInvcgDocHeader | CASubstituteDocumentNumber | Sub. Doc. | |
| CreatedByUser | I_CAInvcgDocHeader | CreatedByUser | User Name | |
| CAInvcgCreationDate | I_CAInvcgDocHeader | CAInvcgCreationDate | Invoiced On | |
| CAInvcgCreationTime | I_CAInvcgDocHeader | CAInvcgCreationTime | Invoiced At | |
| CAInvcgDocCreationMode | I_CAInvcgDocHeader | CAInvcgDocCreationMode | CreatnMode | |
| CAInvcgNmbrOfInvoicingDocItems | I_CAInvcgDocHeader | CAInvcgNmbrOfInvoicingDocItems | Number of Items | |
| CAInvcgDocInternalNumber | I_CAInvcgDocHeader | CAInvcgDocInternalNumber | Invoicg Run No. | |
| CAReconciliationKey | I_CAInvcgDocHeader | CAReconciliationKey | Reconcil. Key | |
| CACashDiscountDueDate | I_CAInvcgDocHeader | CACashDiscountDueDate | Disct Due Date | |
| CACashDiscountRate | I_CAInvcgDocHeader | CACashDiscountRate | Discount rate | |
| CAInvcgPreliminaryCategory | I_CAInvcgDocHeader | CAInvcgPreliminaryCategory | Category Prlm Invoice | |
| CAPrelimInvcgDocValue | I_CAInvcgDocHeader | CAPrelimInvcgDocValue | Counter PrlmInv | |
| CAPreliminaryInvcgDocStatus | I_CAInvcgDocHeader | CAPreliminaryInvcgDocStatus | Status Prlm Invoice | |
| CAInvcgCategory | I_CAInvcgDocHeader | CAInvcgCategory | Invoicing Cat. | |
| CAInvcgReversalDocument | I_CAInvcgDocHeader | CAInvcgReversalDocument | Reversal Doc. | |
| CAInvcgReversedDocument | I_CAInvcgDocHeader | CAInvcgReversedDocument | Reversed Invoicing Doc | |
| CAInvcgCorrectionCategory | I_CAInvcgDocHeader | CAInvcgCorrectionCategory | Invcg Correction Category | |
| CAPaymentMethod | I_CAInvcgDocHeader | CAPaymentMethod | Payment Method | |
| CAPaymentFormNumber | I_CAInvcgDocHeader | CAPaymentFormNumber | Payment Form | |
| FormIDForAttachedPaymentMedium | I_CAInvcgDocHeader | FormIDForAttachedPaymentMedium | Form ID | |
| CAKeyIdentification | I_CAInvcgDocHeader | CAKeyIdentification | Key ID | |
| CAPartnerSettlementRule | I_CAInvcgDocHeader | CAPartnerSettlementRule | Settlement Rule | |
| CompanyCode | I_CAInvcgDocHeader | CompanyCode | Receiver Company Code | |
| BusinessPlace | I_CAInvcgDocHeader | BusinessPlace | Business place | |
| CAContract | I_CAInvcgDocHeader | CAContract | Contract | |
| CASubApplication | I_CAInvcgDocHeader | CASubApplication | Subapplication | |
| CAInvcgBaseDate | I_CAInvcgDocHeader | CAInvcgBaseDate | Baseline Date | |
| CAInvcgDocPeriodCategory | I_CAInvcgDocHeader | CAInvcgDocPeriodCategory | Period Category | |
| CAInvcgDocPeriodStartDate | I_CAInvcgDocHeader | CAInvcgDocPeriodStartDate | Inv. Period Frm | |
| CAInvcgDocHasChargeOrDiscItems | I_CAInvcgDocHeader | CAInvcgDocHasChargeOrDiscItems | Charge/Discount Exists | |
| CAInvcgBolloTaxPostStatus | I_CAInvcgDocHeader | CAInvcgBolloTaxPostStatus | Bollo Posted | |
| CAInvcgDocIsPartOfList | I_CAInvcgDocHeader | CAInvcgDocIsPartOfList | Inv. Subdoc. | |
| CAInvcgDocHasObjectRelation | I_CAInvcgDocHeader | CAInvcgDocHasObjectRelation | ObjRel. Exist | |
| CAInvcgDocHasSEPAPreNotif | I_CAInvcgDocHeader | CAInvcgDocHasSEPAPreNotif | Pre-Notif. | |
| CAInvcgDocExternal | I_CAInvcgDocHeader | CAInvcgDocExternal | External Invoicing Doc | |
| CAPaymentCompanyCodeCountry | ||||
| CAInvcgDocumentTypeText | ||||
| CAInvcgProcessText | ||||
| CAInvcgTypeText | ||||
| CAInvcgCategoryText | ||||
| CAInvcgDocTechDocTypeText | ||||
| CAInvcgTargetProcText | ||||
| CAInvcgMasterDataTypeText | ||||
| CAInvcgDocCreationModeText | ||||
| CAInvcgPreliminaryCategoryTxt | ||||
| CAPreliminaryInvcgDocStatusTxt | ||||
| CAInvcgDocReversalReasonText | ||||
| CAInvcgCorrectionCatText | ||||
| CAInvcgDocLockedForPrintText | ||||
| CAInvcgPeriodCatText | ||||
| CAInvcgDocChrgDiscItemsText | ||||
| CAInvcgBolloTaxPostStatText | ||||
| CAInvcgDocPartOfListText | ||||
| CompanyCodeName | ||||
| _ContractAccountHeader | _ContractAccountHeader | |||
| _ContractAccountPartner | _ContractAccountPartner |
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_CANotDisputedInvcgDoc.
-- 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_CANotDisputedInvcgDoc AS
SELECT
_CAInvcgDocHeader.CAInvoicingDocument AS CAInvoicingDocument,
cast('' as sysuuid_c ) AS CaseUUID,
_CAInvcgDocHeader.CAOfficialDocumentNumber AS CAOfficialDocumentNumber,
_CAInvcgDocHeader._BusinessPartner.FirstName AS FirstName,
_CAInvcgDocHeader._BusinessPartner.LastName AS LastName,
_CAInvcgDocHeader._BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
_CAInvcgDocHeader.BusinessPartner AS BusinessPartner,
_CAInvcgDocHeader.ContractAccount AS ContractAccount,
_CAInvcgDocHeader._ContractAccountHeader.ContractAccountName AS ContractAccountName,
_CAInvcgDocHeader.CAInvcgType AS CAInvcgType,
_CAInvcgDocHeader.CAInvcgDocPeriodDate AS CAInvcgDocPeriodDate,
_CAInvcgDocHeader.DocumentDate AS DocumentDate,
_CAInvcgDocHeader.TransactionCurrency AS TransactionCurrency,
_CAInvcgDocHeader.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
_CAInvcgDocHeader.CAInvcgProcess AS CAInvcgProcess,
_CAInvcgDocHeader.CAInvcgDocumentType AS CAInvcgDocumentType,
_CAInvcgDocHeader.CADunningCounter AS CADunningCounter,
_CAInvcgDocHeader.CAInvcgDocHasControlDoc AS CAInvcgDocHasControlDoc,
_CAInvcgDocHeader.ApplicationForm AS ApplicationForm,
_CAInvcgDocHeader.CAInvcgDocumentPrintDate AS CAInvcgDocumentPrintDate,
_CAInvcgDocHeader.CAInvcgDocIsLockedForPrinting AS CAInvcgDocIsLockedForPrinting,
_CAInvcgDocHeader.CANetDueDate AS CANetDueDate,
_CAInvcgDocHeader.CAInvcgDocumentReversalReason AS CAInvcgDocumentReversalReason,
_CAInvcgDocHeader.CAInvcgIsDocumentPosted AS CAInvcgIsDocumentPosted,
_CAInvcgDocHeader.CAInvcgIsDocumentPreliminary AS CAInvcgIsDocumentPreliminary,
_CAInvcgDocHeader.CAInvcgIsDocumentSimulated AS CAInvcgIsDocumentSimulated,
_CAInvcgDocHeader.CAPostingDate AS CAPostingDate,
_CAInvcgDocHeader.CAApplicationArea AS CAApplicationArea,
_CAInvcgDocHeader.CAInvcgTechnicalDocumentType AS CAInvcgTechnicalDocumentType,
_CAInvcgDocHeader.CAInvcgTargetProcess AS CAInvcgTargetProcess,
_CAInvcgDocHeader.CAInvcgMasterDataType AS CAInvcgMasterDataType,
_CAInvcgDocHeader.AltvContractAcctForCollvBills AS AltvContractAcctForCollvBills,
_CAInvcgDocHeader.CASubstituteDocumentNumber AS CASubstituteDocumentNumber,
_CAInvcgDocHeader.CreatedByUser AS CreatedByUser,
_CAInvcgDocHeader.CAInvcgCreationDate AS CAInvcgCreationDate,
_CAInvcgDocHeader.CAInvcgCreationTime AS CAInvcgCreationTime,
_CAInvcgDocHeader.CAInvcgDocCreationMode AS CAInvcgDocCreationMode,
_CAInvcgDocHeader.CAInvcgNmbrOfInvoicingDocItems AS CAInvcgNmbrOfInvoicingDocItems,
_CAInvcgDocHeader.CAInvcgDocInternalNumber AS CAInvcgDocInternalNumber,
_CAInvcgDocHeader.CAReconciliationKey AS CAReconciliationKey,
_CAInvcgDocHeader.CACashDiscountDueDate AS CACashDiscountDueDate,
_CAInvcgDocHeader.CACashDiscountRate AS CACashDiscountRate,
_CAInvcgDocHeader.CAInvcgPreliminaryCategory AS CAInvcgPreliminaryCategory,
_CAInvcgDocHeader.CAPrelimInvcgDocValue AS CAPrelimInvcgDocValue,
_CAInvcgDocHeader.CAPreliminaryInvcgDocStatus AS CAPreliminaryInvcgDocStatus,
_CAInvcgDocHeader.CAInvcgCategory AS CAInvcgCategory,
_CAInvcgDocHeader.CAInvcgReversalDocument AS CAInvcgReversalDocument,
_CAInvcgDocHeader.CAInvcgReversedDocument AS CAInvcgReversedDocument,
_CAInvcgDocHeader.CAInvcgCorrectionCategory AS CAInvcgCorrectionCategory,
_CAInvcgDocHeader.CAPaymentMethod AS CAPaymentMethod,
_CAInvcgDocHeader.CAPaymentFormNumber AS CAPaymentFormNumber,
_CAInvcgDocHeader.FormIDForAttachedPaymentMedium AS FormIDForAttachedPaymentMedium,
_CAInvcgDocHeader.CAKeyIdentification AS CAKeyIdentification,
_CAInvcgDocHeader.CAPartnerSettlementRule AS CAPartnerSettlementRule,
_CAInvcgDocHeader.CompanyCode AS CompanyCode,
_CAInvcgDocHeader.BusinessPlace AS BusinessPlace,
_CAInvcgDocHeader.CAContract AS CAContract,
_CAInvcgDocHeader.CASubApplication AS CASubApplication,
_CAInvcgDocHeader.CAInvcgBaseDate AS CAInvcgBaseDate,
_CAInvcgDocHeader.CAInvcgDocPeriodCategory AS CAInvcgDocPeriodCategory,
_CAInvcgDocHeader.CAInvcgDocPeriodStartDate AS CAInvcgDocPeriodStartDate,
_CAInvcgDocHeader.CAInvcgDocHasChargeOrDiscItems AS CAInvcgDocHasChargeOrDiscItems,
_CAInvcgDocHeader.CAInvcgBolloTaxPostStatus AS CAInvcgBolloTaxPostStatus,
_CAInvcgDocHeader.CAInvcgDocIsPartOfList AS CAInvcgDocIsPartOfList,
_CAInvcgDocHeader.CAInvcgDocHasObjectRelation AS CAInvcgDocHasObjectRelation,
_CAInvcgDocHeader.CAInvcgDocHasSEPAPreNotif AS CAInvcgDocHasSEPAPreNotif,
_CAInvcgDocHeader.CAInvcgDocExternal AS CAInvcgDocExternal,
_CAInvcgDocHeader._ContractAccountPartner._CompCodeGroup._CompanyCode.Country AS CAPaymentCompanyCodeCountry,
_CAInvcgDocHeader._CAInvcgDocumentType._CAInvcgDocumentTypeText[1: Language=$session.system_language].CAInvcgDocumentTypeText AS CAInvcgDocumentTypeText,
_CAInvcgDocHeader._CAInvcgProcess._CAInvcgProcessText[1: Language=$session.system_language].CAInvcgProcessText AS CAInvcgProcessText,
_CAInvcgDocHeader._CAInvcgType._CAInvcgTypeText[1: Language=$session.system_language].CAInvcgTypeText AS CAInvcgTypeText,
_CAInvcgDocHeader._CAInvcgCategory._CAInvcgCategoryText[1: Language=$session.system_language].CAInvcgCategoryText AS CAInvcgCategoryText,
_CAInvcgDocHeader._CAInvcgDocTechDocType._CAInvcgDocTechDocTypeText[1: Language=$session.system_language].CAInvcgDocTechDocTypeText AS CAInvcgDocTechDocTypeText,
_CAInvcgDocHeader._CAInvcgTargetProc._CAInvcgTargetProcText[1: Language=$session.system_language].CAInvcgTargetProcText AS CAInvcgTargetProcText,
_CAInvcgDocHeader._CAInvcgMasterDataType._CAInvcgMasterDataTypeText[1: Language=$session.system_language].CAInvcgMasterDataTypeText AS CAInvcgMasterDataTypeText,
_CAInvcgDocHeader._CAInvcgDocCreationMode._CAInvcgDocCreationModeText[1: Language=$session.system_language].CAInvcgDocCreationModeText AS CAInvcgDocCreationModeText,
_CAInvcgDocHeader._CAInvcgPreliminaryCategory._Text[1: Language=$session.system_language].CAInvcgPreliminaryCategoryTxt AS CAInvcgPreliminaryCategoryTxt,
_CAInvcgDocHeader._CAPreliminaryInvcgDocStatus._Text[1: Language=$session.system_language].CAPreliminaryInvcgDocStatusTxt AS CAPreliminaryInvcgDocStatusTxt,
_CAInvcgDocHeader._CAInvcgDocReversalReason._CAInvcgDocReversalReasonText[1: Language=$session.system_language].CAInvcgDocReversalReasonText AS CAInvcgDocReversalReasonText,
_CAInvcgDocHeader._CAInvcgCorrectionCat._CAInvcgCorrectionCatText[1: Language=$session.system_language].CAInvcgCorrectionCatText AS CAInvcgCorrectionCatText,
_CAInvcgDocHeader._CAInvcgDocLockedforPrint._CAInvcgDocLockedForPrintText[1: Language=$session.system_language].CAInvcgDocLockedForPrintText AS CAInvcgDocLockedForPrintText,
_CAInvcgDocHeader._CAInvcgPeriodCat._CAInvcgPeriodCatText[1: Language=$session.system_language].CAInvcgPeriodCatText AS CAInvcgPeriodCatText,
_CAInvcgDocHeader._CAInvcgDocChrgDiscItems._CAInvcgDocChrgDiscItemsText[1: Language=$session.system_language].CAInvcgDocChrgDiscItemsText AS CAInvcgDocChrgDiscItemsText,
_CAInvcgDocHeader._CAInvcgBolloTaxPostStatus._CAInvcgBolloTaxPostStatText[1: Language=$session.system_language].CAInvcgBolloTaxPostStatText AS CAInvcgBolloTaxPostStatText,
_CAInvcgDocHeader._CAInvcgDocPartOfList._CAInvcgDocPartOfListText[1: Language=$session.system_language].CAInvcgDocPartOfListText AS CAInvcgDocPartOfListText,
_CAInvcgDocHeader._CompanyCode.CompanyCodeName AS CompanyCodeName
FROM I_CAInvcgDocHeader AS _CAInvcgDocHeader
;
Learn More
- 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
- S/4HANA CDS View Deprecation: What You Need to Know
- 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