C_CANotDisputedInvcgDoc

DDL: C_CANOTDISPUTEDINVCGDOC Type: view_entity CONSUMPTION

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)

SourceAliasJoin Type
I_CAInvcgDocHeader _CAInvcgDocHeader from

Annotations (9)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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
;