C_CADisputedInvcgDocDraftTP

DDL: C_CADISPUTEDINVCGDOCDRAFTTP Type: view_entity CONSUMPTION

Disputed invoicing document

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

Data Sources (1)

SourceAliasJoin Type
R_CADisputedInvcgDocTP R_CADisputedInvcgDocTP projection

Annotations (7)

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

Fields (84)

KeyFieldSource TableSource FieldDescription
KEY CaseUUID CaseUUID UUID
KEY CAInvoicingDocument CAInvoicingDocument Invoic. Doc.
CAOfficialDocumentNumber CAOfficialDocumentNumber Offic. Doc. No.
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerFullName _BusinessPartner BusinessPartnerFullName Broker Name
ContractAccount ContractAccount Contract Acct
ContractAccountName _ContractAccountHeader ContractAccountName Cont. acct name
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
CAInvcgCreationDateTime CAInvcgCreationDateTime Invoiced On
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

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_CADisputedInvcgDocDraftTP.
-- 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_CADisputedInvcgDocDraftTP AS
SELECT
  CaseUUID,
  CAInvoicingDocument,
  CAOfficialDocumentNumber,
  BusinessPartner,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  ContractAccount,
  _ContractAccountHeader.ContractAccountName AS ContractAccountName,
  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,
  CAInvcgCreationDateTime,
  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 R_CADisputedInvcgDocTP
;