I_CADisputedInvcgDoc

DDL: I_CADISPUTEDINVCGDOC Type: view_entity COMPOSITE
83 Fields 2 Data Sources

Disputed invoicing document

I_CADisputedInvcgDoc is a Composite CDS View that provides data about "Disputed invoicing document" in SAP S/4HANA. It reads from 2 data sources (I_CAInvcgDocHeader, P_CADisputedInvcgDoc) and exposes 83 fields with key fields CaseUUID, CAInvoicingDocument.

Data Sources (2)

SourceAliasJoin Type
I_CAInvcgDocHeader _CAInvcgDocHeader inner
P_CADisputedInvcgDoc _DisputedInvcgDoc from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Disputed invoicing document view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (83)

KeyFieldSource TableSource FieldDescription
KEY CaseUUID P_CADisputedInvcgDoc CaseUUID UUID
KEY CAInvoicingDocument P_CADisputedInvcgDoc CAInvoicingDocument Invoic. Doc.
CAOfficialDocumentNumber I_CAInvcgDocHeader CAOfficialDocumentNumber Offic. Doc. No.
BusinessPartner I_CAInvcgDocHeader BusinessPartner Issuing Authority
ContractAccount I_CAInvcgDocHeader ContractAccount Contract Acct
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
CAInvcgDocumentTypeText
CAInvcgProcessText
CAInvcgTypeText
CAInvcgCategoryText
CAInvcgDocTechDocTypeText
CAInvcgTargetProcText
CAInvcgMasterDataTypeText
CAInvcgDocCreationModeText
CAInvcgPreliminaryCategoryTxt
CAPreliminaryInvcgDocStatusTxt
CAInvcgDocReversalReasonText
CAInvcgCorrectionCatText
CAInvcgDocLockedForPrintText
CAInvcgPeriodCatText
CAInvcgDocChrgDiscItemsText
CAInvcgBolloTaxPostStatText
CAInvcgDocPartOfListText
CompanyCodeName
_BusinessPartner I_CAInvcgDocHeader _BusinessPartner
_ContractAccountHeader I_CAInvcgDocHeader _ContractAccountHeader

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 I_CADisputedInvcgDoc.
-- 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 I_CADisputedInvcgDoc AS
SELECT
  _DisputedInvcgDoc.CaseUUID AS CaseUUID,
  _DisputedInvcgDoc.CAInvoicingDocument AS CAInvoicingDocument,
  _CAInvcgDocHeader.CAOfficialDocumentNumber AS CAOfficialDocumentNumber,
  _CAInvcgDocHeader.BusinessPartner AS BusinessPartner,
  _CAInvcgDocHeader.ContractAccount AS ContractAccount,
  _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._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,
  cast(_CAInvcgDocHeader._CAInvcgDocTechDocType._CAInvcgDocTechDocTypeText[1: Language=$session.system_language].CAInvcgDocTechDocTypeText as description_kk) AS CAInvcgDocTechDocTypeText,
  _CAInvcgDocHeader._CAInvcgTargetProc._CAInvcgTargetProcText[1: Language=$session.system_language].CAInvcgTargetProcText AS CAInvcgTargetProcText,
  cast(_CAInvcgDocHeader._CAInvcgMasterDataType._CAInvcgMasterDataTypeText[1: Language=$session.system_language].CAInvcgMasterDataTypeText as description_kk) AS CAInvcgMasterDataTypeText,
  cast(_CAInvcgDocHeader._CAInvcgDocCreationMode._CAInvcgDocCreationModeText[1: Language=$session.system_language].CAInvcgDocCreationModeText as description_kk) 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,
  cast(_CAInvcgDocHeader._CAInvcgCorrectionCat._CAInvcgCorrectionCatText[1: Language=$session.system_language].CAInvcgCorrectionCatText as description_kk) AS CAInvcgCorrectionCatText,
  cast(_CAInvcgDocHeader._CAInvcgDocLockedforPrint._CAInvcgDocLockedForPrintText[1: Language=$session.system_language].CAInvcgDocLockedForPrintText as description_kk) AS CAInvcgDocLockedForPrintText,
  _CAInvcgDocHeader._CAInvcgPeriodCat._CAInvcgPeriodCatText[1: Language=$session.system_language].CAInvcgPeriodCatText AS CAInvcgPeriodCatText,
  cast(_CAInvcgDocHeader._CAInvcgDocChrgDiscItems._CAInvcgDocChrgDiscItemsText[1: Language=$session.system_language].CAInvcgDocChrgDiscItemsText as description_kk) AS CAInvcgDocChrgDiscItemsText,
  cast(_CAInvcgDocHeader._CAInvcgBolloTaxPostStatus._CAInvcgBolloTaxPostStatText[1: Language=$session.system_language].CAInvcgBolloTaxPostStatText as description_kk) AS CAInvcgBolloTaxPostStatText,
  cast(_CAInvcgDocHeader._CAInvcgDocPartOfList._CAInvcgDocPartOfListText[1: Language=$session.system_language].CAInvcgDocPartOfListText as description_kk) AS CAInvcgDocPartOfListText,
  _CAInvcgDocHeader._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _CAInvcgDocHeader._BusinessPartner AS _BusinessPartner,
  _CAInvcgDocHeader._ContractAccountHeader AS _ContractAccountHeader
FROM P_CADisputedInvcgDoc AS _DisputedInvcgDoc
INNER JOIN I_CAInvcgDocHeader AS _CAInvcgDocHeader ON /* join condition not captured in parsed metadata */
;

Learn More