R_CADisputedInvcgDocTP

DDL: R_CADISPUTEDINVCGDOCTP Type: view_entity TRANSACTIONAL

Disputed invoicing document

R_CADisputedInvcgDocTP is a Transactional CDS View that provides data about "Disputed invoicing document" in SAP S/4HANA. It reads from 1 data source (I_CADisputedInvcgDoc) and exposes 84 fields with key fields CaseUUID, CAInvoicingDocument.

Data Sources (1)

SourceAliasJoin Type
I_CADisputedInvcgDoc I_CADisputedInvcgDoc from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Disputed invoicing document view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (84)

KeyFieldSource TableSource FieldDescription
KEY CaseUUID CaseUUID UUID
KEY CAInvoicingDocument CAInvoicingDocument Invoic. Doc.
CAOfficialDocumentNumber CAOfficialDocumentNumber Offic. Doc. No.
BusinessPartner BusinessPartner Issuing Authority
ContractAccount ContractAccount Contract Acct
CAInvcgType CAInvcgType Invoicing Type
CAInvcgDocPeriodDate CAInvcgDocPeriodDate Invoicing Per.
DocumentDate DocumentDate Journal Entry Date
TransactionCurrency TransactionCurrency Transaction Currency
CAAmountInTransactionCurrency CAAmountInTransactionCurrency Amount
CAInvcgProcess CAInvcgProcess Invoicing Proc.
CAInvcgDocumentType CAInvcgDocumentType Document Type
CADunningCounter CADunningCounter Dunning counter
CAInvcgDocHasControlDoc CAInvcgDocHasControlDoc Clrfctn Case Control Doc
ApplicationForm ApplicationForm Forms
CAInvcgDocumentPrintDate CAInvcgDocumentPrintDate Print Date
CAInvcgDocIsLockedForPrinting CAInvcgDocIsLockedForPrinting Printing Lock
CANetDueDate CANetDueDate Net Due Date
CAInvcgDocumentReversalReason CAInvcgDocumentReversalReason Reversal Reason
CAInvcgIsDocumentPosted CAInvcgIsDocumentPosted Document Posted
CAInvcgIsDocumentPreliminary CAInvcgIsDocumentPreliminary Preliminary Invoice
CAInvcgIsDocumentSimulated CAInvcgIsDocumentSimulated Doc. Simulated
CAPostingDate CAPostingDate Posting Date
CAApplicationArea CAApplicationArea ApplicationArea
CAInvcgTechnicalDocumentType CAInvcgTechnicalDocumentType Technical Document Type
CAInvcgTargetProcess CAInvcgTargetProcess Target Process
CAInvcgMasterDataType CAInvcgMasterDataType MasterData Type
AltvContractAcctForCollvBills AltvContractAcctForCollvBills Coll. Bill Acct
CASubstituteDocumentNumber CASubstituteDocumentNumber Sub. Doc.
CreatedByUser CreatedByUser User Name
CAInvcgCreationDate CAInvcgCreationDate Invoiced On
CAInvcgCreationTime CAInvcgCreationTime Invoiced At
CAInvcgDocCreationMode CAInvcgDocCreationMode CreatnMode
CAInvcgNmbrOfInvoicingDocItems CAInvcgNmbrOfInvoicingDocItems Number of Items
CAInvcgDocInternalNumber CAInvcgDocInternalNumber Invoicg Run No.
CAReconciliationKey CAReconciliationKey Reconcil. Key
CACashDiscountDueDate CACashDiscountDueDate Disct Due Date
CACashDiscountRate CACashDiscountRate Discount rate
CAInvcgPreliminaryCategory CAInvcgPreliminaryCategory Category Prlm Invoice
CAPrelimInvcgDocValue CAPrelimInvcgDocValue Counter PrlmInv
CAPreliminaryInvcgDocStatus CAPreliminaryInvcgDocStatus Status Prlm Invoice
CAInvcgCategory CAInvcgCategory Invoicing Cat.
CAInvcgReversalDocument CAInvcgReversalDocument Reversal Doc.
CAInvcgReversedDocument CAInvcgReversedDocument Reversed Invoicing Doc
CAInvcgCorrectionCategory CAInvcgCorrectionCategory Invcg Correction Category
CAPaymentMethod CAPaymentMethod Payment Method
CAPaymentFormNumber CAPaymentFormNumber Payment Form
FormIDForAttachedPaymentMedium FormIDForAttachedPaymentMedium Form ID
CAKeyIdentification CAKeyIdentification Key ID
CAPartnerSettlementRule CAPartnerSettlementRule Settlement Rule
CompanyCode CompanyCode Receiver Company Code
BusinessPlace BusinessPlace Business place
CAContract CAContract Contract
CASubApplication CASubApplication Subapplication
CAInvcgBaseDate CAInvcgBaseDate Baseline Date
CAInvcgDocPeriodCategory CAInvcgDocPeriodCategory Period Category
CAInvcgDocPeriodStartDate CAInvcgDocPeriodStartDate Inv. Period Frm
CAInvcgDocHasChargeOrDiscItems CAInvcgDocHasChargeOrDiscItems Charge/Discount Exists
CAInvcgBolloTaxPostStatus CAInvcgBolloTaxPostStatus Bollo Posted
CAInvcgDocIsPartOfList CAInvcgDocIsPartOfList Inv. Subdoc.
CAInvcgDocHasObjectRelation CAInvcgDocHasObjectRelation ObjRel. Exist
CAInvcgDocHasSEPAPreNotif CAInvcgDocHasSEPAPreNotif Pre-Notif.
CAInvcgDocExternal CAInvcgDocExternal External Invoicing Doc
CAInvcgDocumentTypeText CAInvcgDocumentTypeText Doc. Type Text
CAInvcgProcessText CAInvcgProcessText Process Text
CAInvcgTypeText CAInvcgTypeText Inv. Type Text
CAInvcgCategoryText CAInvcgCategoryText Inv. Cat. Text
CAInvcgDocTechDocTypeText CAInvcgDocTechDocTypeText Description
CAInvcgTargetProcText CAInvcgTargetProcText Explanation
CAInvcgMasterDataTypeText CAInvcgMasterDataTypeText Description
CAInvcgDocCreationModeText CAInvcgDocCreationModeText Description
CAInvcgPreliminaryCategoryTxt CAInvcgPreliminaryCategoryTxt Explanation
CAPreliminaryInvcgDocStatusTxt CAPreliminaryInvcgDocStatusTxt Description
CAInvcgDocReversalReasonText CAInvcgDocReversalReasonText Reversal Reason
CAInvcgCorrectionCatText CAInvcgCorrectionCatText Description
CAInvcgDocLockedForPrintText CAInvcgDocLockedForPrintText Description
CAInvcgPeriodCatText CAInvcgPeriodCatText Text
CAInvcgDocChrgDiscItemsText CAInvcgDocChrgDiscItemsText Description
CAInvcgBolloTaxPostStatText CAInvcgBolloTaxPostStatText Description
CAInvcgDocPartOfListText CAInvcgDocPartOfListText Description
CompanyCodeName CompanyCodeName Company Name
_CADisputeCase _CADisputeCase
_BusinessPartner _BusinessPartner
_ContractAccountHeader _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 R_CADisputedInvcgDocTP.
-- 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 R_CADisputedInvcgDocTP AS
SELECT
  CaseUUID,
  CAInvoicingDocument,
  CAOfficialDocumentNumber,
  BusinessPartner,
  ContractAccount,
  CAInvcgType,
  CAInvcgDocPeriodDate,
  DocumentDate,
  TransactionCurrency,
  CAAmountInTransactionCurrency,
  CAInvcgProcess,
  CAInvcgDocumentType,
  CADunningCounter,
  CAInvcgDocHasControlDoc,
  ApplicationForm,
  CAInvcgDocumentPrintDate,
  CAInvcgDocIsLockedForPrinting,
  CANetDueDate,
  CAInvcgDocumentReversalReason,
  CAInvcgIsDocumentPosted,
  CAInvcgIsDocumentPreliminary,
  CAInvcgIsDocumentSimulated,
  CAPostingDate,
  CAApplicationArea,
  CAInvcgTechnicalDocumentType,
  CAInvcgTargetProcess,
  CAInvcgMasterDataType,
  AltvContractAcctForCollvBills,
  CASubstituteDocumentNumber,
  CreatedByUser,
  CAInvcgCreationDate,
  CAInvcgCreationTime,
  CAInvcgDocCreationMode,
  CAInvcgNmbrOfInvoicingDocItems,
  CAInvcgDocInternalNumber,
  CAReconciliationKey,
  CACashDiscountDueDate,
  CACashDiscountRate,
  CAInvcgPreliminaryCategory,
  CAPrelimInvcgDocValue,
  CAPreliminaryInvcgDocStatus,
  CAInvcgCategory,
  CAInvcgReversalDocument,
  CAInvcgReversedDocument,
  CAInvcgCorrectionCategory,
  CAPaymentMethod,
  CAPaymentFormNumber,
  FormIDForAttachedPaymentMedium,
  CAKeyIdentification,
  CAPartnerSettlementRule,
  CompanyCode,
  BusinessPlace,
  CAContract,
  CASubApplication,
  CAInvcgBaseDate,
  CAInvcgDocPeriodCategory,
  CAInvcgDocPeriodStartDate,
  CAInvcgDocHasChargeOrDiscItems,
  CAInvcgBolloTaxPostStatus,
  CAInvcgDocIsPartOfList,
  CAInvcgDocHasObjectRelation,
  CAInvcgDocHasSEPAPreNotif,
  CAInvcgDocExternal,
  CAInvcgDocumentTypeText,
  CAInvcgProcessText,
  CAInvcgTypeText,
  CAInvcgCategoryText,
  CAInvcgDocTechDocTypeText,
  CAInvcgTargetProcText,
  CAInvcgMasterDataTypeText,
  CAInvcgDocCreationModeText,
  CAInvcgPreliminaryCategoryTxt,
  CAPreliminaryInvcgDocStatusTxt,
  CAInvcgDocReversalReasonText,
  CAInvcgCorrectionCatText,
  CAInvcgDocLockedForPrintText,
  CAInvcgPeriodCatText,
  CAInvcgDocChrgDiscItemsText,
  CAInvcgBolloTaxPostStatText,
  CAInvcgDocPartOfListText,
  CompanyCodeName
FROM I_CADisputedInvcgDoc
;