I_CAInvcgDocMassCreate

DDL: I_CAINVCGDOCMASSCREATE Type: view_entity COMPOSITE Package: FKKINV_VDM_BIT
84 Fields 2 Data Sources 1 Associations

Abrechnungsauftrag (Mass)

I_CAInvcgDocMassCreate is a Composite CDS View that provides data about "Abrechnungsauftrag (Mass)" in SAP S/4HANA. It reads from 2 data sources (I_CABillgRequest, I_CAInvcgDocHeader) and exposes 84 fields with key field CAInvoicingDocument. It has 1 association to related views. Part of development package FKKINV_VDM_BIT.

Data Sources (2)

SourceAliasJoin Type
I_CABillgRequest _CABillgReqDocHeader left_outer
I_CAInvcgDocHeader _CAInvcgDocHeader from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CAInvcgDocLockedforPrint _CAInvcgDocLockedForPrint $projection.CAInvcgDocIsLockedForPrinting = _CAInvcgDocLockedForPrint.CAInvcgDocIsLockedForPrinting

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.representativeKey CAInvoicingDocument view
Analytics.technicalName ICAINVDOCMC_H view
EndUserText.label Abrechnungsauftrag (Mass) view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (84)

KeyFieldSource TableSource FieldDescription
KEY CAInvoicingDocument I_CAInvcgDocHeader CAInvoicingDocument Invoic. Doc.
CAApplicationArea I_CAInvcgDocHeader CAApplicationArea ApplicationArea
CAInvcgProcess I_CAInvcgDocHeader CAInvcgProcess Invoicing Proc.
CAInvcgType I_CAInvcgDocHeader CAInvcgType Invoicing Type
CAInvcgCategory I_CAInvcgDocHeader CAInvcgCategory Invoicing Cat.
CAInvcgTechnicalDocumentType I_CAInvcgDocHeader CAInvcgTechnicalDocumentType Technical Document Type
CAInvcgTargetProcess I_CAInvcgDocHeader CAInvcgTargetProcess Target Process
BusinessPartner I_CAInvcgDocHeader BusinessPartner Issuing Authority
ContractAccount I_CAInvcgDocHeader ContractAccount Contract Acct
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
CAPostingDate I_CAInvcgDocHeader CAPostingDate Posting Date
DocumentDate I_CAInvcgDocHeader DocumentDate Journal Entry Date
CANetDueDate I_CAInvcgDocHeader CANetDueDate Net Due Date
CACashDiscountDueDate I_CAInvcgDocHeader CACashDiscountDueDate Disct Due Date
CACashDiscountRate I_CAInvcgDocHeader CACashDiscountRate Discount rate
TransactionCurrency I_CAInvcgDocHeader TransactionCurrency Transaction Currency
CAAmountInTransactionCurrency I_CAInvcgDocHeader CAAmountInTransactionCurrency Amount
CAInvcgIsDocumentPosted I_CAInvcgDocHeader CAInvcgIsDocumentPosted Document Posted
CAInvcgIsDocumentSimulated I_CAInvcgDocHeader CAInvcgIsDocumentSimulated Doc. Simulated
CAInvcgIsDocumentPreliminary I_CAInvcgDocHeader CAInvcgIsDocumentPreliminary Preliminary Invoice
CAInvcgPreliminaryCategory I_CAInvcgDocHeader CAInvcgPreliminaryCategory Category Prlm Invoice
CAInvcgDocumentReversalReason I_CAInvcgDocHeader CAInvcgDocumentReversalReason Reversal Reason
CAInvcgReversalDocument I_CAInvcgDocHeader CAInvcgReversalDocument Reversal Doc.
CAInvcgReversedDocument I_CAInvcgDocHeader CAInvcgReversedDocument Reversed Invoicing Doc
CAInvcgCorrectionCategory I_CAInvcgDocHeader CAInvcgCorrectionCategory Invcg Correction Category
CAInvcgDocumentPrintDate I_CAInvcgDocHeader CAInvcgDocumentPrintDate Print Date
CAInvcgDocIsLockedForPrinting I_CAInvcgDocHeader CAInvcgDocIsLockedForPrinting Printing Lock
CAPaymentMethod I_CAInvcgDocHeader CAPaymentMethod Payment Method
CAPaymentFormNumber I_CAInvcgDocHeader CAPaymentFormNumber Payment Form
CAInvcgDocFormID I_CAInvcgDocHeader CAInvcgDocFormID Form ID
ApplicationForm I_CAInvcgDocHeader ApplicationForm Forms
FormIDForAttachedPaymentMedium I_CAInvcgDocHeader FormIDForAttachedPaymentMedium Form ID
CAInvcgDocumentType I_CAInvcgDocHeader CAInvcgDocumentType Document Type
CAKeyIdentification I_CAInvcgDocHeader CAKeyIdentification Key ID
CAOfficialDocumentNumber I_CAInvcgDocHeader CAOfficialDocumentNumber Offic. Doc. No.
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
CAInvcgDocPeriodDate I_CAInvcgDocHeader CAInvcgDocPeriodDate Invoicing Per.
CAInvcgDocPeriodStartDate I_CAInvcgDocHeader CAInvcgDocPeriodStartDate Inv. Period Frm
CADunningCounter I_CAInvcgDocHeader CADunningCounter Dunning counter
CAInvcgDocHasChargeOrDiscItems I_CAInvcgDocHeader CAInvcgDocHasChargeOrDiscItems Charge/Discount Exists
CAInvcgDocHasControlDoc I_CAInvcgDocHeader CAInvcgDocHasControlDoc Clrfctn Case Control Doc
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
CAInvcgAdjustmentDocument I_CAInvcgDocHeader CAInvcgAdjustmentDocument Adjustment Doc.
CAInvcgAdjustedDocument I_CAInvcgDocHeader CAInvcgAdjustedDocument DocToBeAdjusted
NameNumberRangeObject
_ContractAccountHeader I_CAInvcgDocHeader _ContractAccountHeader
_ContractAccountPartner I_CAInvcgDocHeader _ContractAccountPartner
_CAApplicationArea I_CAInvcgDocHeader _CAApplicationArea
_CompanyCode I_CAInvcgDocHeader _CompanyCode
_CAInvcgBolloTaxPostStatus I_CAInvcgDocHeader _CAInvcgBolloTaxPostStatus
_CAInvcgCategory I_CAInvcgDocHeader _CAInvcgCategory
_CAInvcgCorrectionCat I_CAInvcgDocHeader _CAInvcgCorrectionCat
_CAInvcgDocChrgDiscItems I_CAInvcgDocHeader _CAInvcgDocChrgDiscItems
_CAInvcgDocCreationMode I_CAInvcgDocHeader _CAInvcgDocCreationMode
_CAInvcgDocHeader I_CAInvcgDocHeader _CAInvcgDocHeader
_CAInvcgDocLockedForPrint _CAInvcgDocLockedForPrint
_CAInvcgDocPartOfList I_CAInvcgDocHeader _CAInvcgDocPartOfList
_CAInvcgDocReversalReason I_CAInvcgDocHeader _CAInvcgDocReversalReason
_CAInvcgDocTechDocType I_CAInvcgDocHeader _CAInvcgDocTechDocType
_CAInvcgMasterDataType I_CAInvcgDocHeader _CAInvcgMasterDataType
_CAInvcgPeriodCat I_CAInvcgDocHeader _CAInvcgPeriodCat
_CAInvcgProcess I_CAInvcgDocHeader _CAInvcgProcess
_CAInvcgTargetProc I_CAInvcgDocHeader _CAInvcgTargetProc
_CAInvcgType I_CAInvcgDocHeader _CAInvcgType
_ProviderContract I_CAInvcgDocHeader _ProviderContract

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_CAInvcgDocMassCreate.
-- 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_CAInvcgDocMassCreate AS
SELECT
  _CAInvcgDocHeader.CAInvoicingDocument AS CAInvoicingDocument,
  _CAInvcgDocHeader.CAApplicationArea AS CAApplicationArea,
  _CAInvcgDocHeader.CAInvcgProcess AS CAInvcgProcess,
  _CAInvcgDocHeader.CAInvcgType AS CAInvcgType,
  _CAInvcgDocHeader.CAInvcgCategory AS CAInvcgCategory,
  _CAInvcgDocHeader.CAInvcgTechnicalDocumentType AS CAInvcgTechnicalDocumentType,
  _CAInvcgDocHeader.CAInvcgTargetProcess AS CAInvcgTargetProcess,
  _CAInvcgDocHeader.BusinessPartner AS BusinessPartner,
  _CAInvcgDocHeader.ContractAccount AS ContractAccount,
  _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.CAPostingDate AS CAPostingDate,
  _CAInvcgDocHeader.DocumentDate AS DocumentDate,
  _CAInvcgDocHeader.CANetDueDate AS CANetDueDate,
  _CAInvcgDocHeader.CACashDiscountDueDate AS CACashDiscountDueDate,
  _CAInvcgDocHeader.CACashDiscountRate AS CACashDiscountRate,
  _CAInvcgDocHeader.TransactionCurrency AS TransactionCurrency,
  _CAInvcgDocHeader.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  _CAInvcgDocHeader.CAInvcgIsDocumentPosted AS CAInvcgIsDocumentPosted,
  _CAInvcgDocHeader.CAInvcgIsDocumentSimulated AS CAInvcgIsDocumentSimulated,
  _CAInvcgDocHeader.CAInvcgIsDocumentPreliminary AS CAInvcgIsDocumentPreliminary,
  _CAInvcgDocHeader.CAInvcgPreliminaryCategory AS CAInvcgPreliminaryCategory,
  _CAInvcgDocHeader.CAInvcgDocumentReversalReason AS CAInvcgDocumentReversalReason,
  _CAInvcgDocHeader.CAInvcgReversalDocument AS CAInvcgReversalDocument,
  _CAInvcgDocHeader.CAInvcgReversedDocument AS CAInvcgReversedDocument,
  _CAInvcgDocHeader.CAInvcgCorrectionCategory AS CAInvcgCorrectionCategory,
  _CAInvcgDocHeader.CAInvcgDocumentPrintDate AS CAInvcgDocumentPrintDate,
  _CAInvcgDocHeader.CAInvcgDocIsLockedForPrinting AS CAInvcgDocIsLockedForPrinting,
  _CAInvcgDocHeader.CAPaymentMethod AS CAPaymentMethod,
  _CAInvcgDocHeader.CAPaymentFormNumber AS CAPaymentFormNumber,
  _CAInvcgDocHeader.CAInvcgDocFormID AS CAInvcgDocFormID,
  _CAInvcgDocHeader.ApplicationForm AS ApplicationForm,
  _CAInvcgDocHeader.FormIDForAttachedPaymentMedium AS FormIDForAttachedPaymentMedium,
  _CAInvcgDocHeader.CAInvcgDocumentType AS CAInvcgDocumentType,
  _CAInvcgDocHeader.CAKeyIdentification AS CAKeyIdentification,
  _CAInvcgDocHeader.CAOfficialDocumentNumber AS CAOfficialDocumentNumber,
  _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.CAInvcgDocPeriodDate AS CAInvcgDocPeriodDate,
  _CAInvcgDocHeader.CAInvcgDocPeriodStartDate AS CAInvcgDocPeriodStartDate,
  _CAInvcgDocHeader.CADunningCounter AS CADunningCounter,
  _CAInvcgDocHeader.CAInvcgDocHasChargeOrDiscItems AS CAInvcgDocHasChargeOrDiscItems,
  _CAInvcgDocHeader.CAInvcgDocHasControlDoc AS CAInvcgDocHasControlDoc,
  _CAInvcgDocHeader.CAInvcgBolloTaxPostStatus AS CAInvcgBolloTaxPostStatus,
  _CAInvcgDocHeader.CAInvcgDocIsPartOfList AS CAInvcgDocIsPartOfList,
  _CAInvcgDocHeader.CAInvcgDocHasObjectRelation AS CAInvcgDocHasObjectRelation,
  _CAInvcgDocHeader.CAInvcgDocHasSEPAPreNotif AS CAInvcgDocHasSEPAPreNotif,
  _CAInvcgDocHeader.CAInvcgDocExternal AS CAInvcgDocExternal,
  _CAInvcgDocHeader.CAInvcgAdjustmentDocument AS CAInvcgAdjustmentDocument,
  _CAInvcgDocHeader.CAInvcgAdjustedDocument AS CAInvcgAdjustedDocument,
  cast( 'FKKINV' as nrobj ) AS NameNumberRangeObject,
  _CAInvcgDocHeader._ContractAccountHeader AS _ContractAccountHeader,
  _CAInvcgDocHeader._ContractAccountPartner AS _ContractAccountPartner,
  _CAInvcgDocHeader._CAApplicationArea AS _CAApplicationArea,
  _CAInvcgDocHeader._CompanyCode AS _CompanyCode,
  _CAInvcgDocHeader._CAInvcgBolloTaxPostStatus AS _CAInvcgBolloTaxPostStatus,
  _CAInvcgDocHeader._CAInvcgCategory AS _CAInvcgCategory,
  _CAInvcgDocHeader._CAInvcgCorrectionCat AS _CAInvcgCorrectionCat,
  _CAInvcgDocHeader._CAInvcgDocChrgDiscItems AS _CAInvcgDocChrgDiscItems,
  _CAInvcgDocHeader._CAInvcgDocCreationMode AS _CAInvcgDocCreationMode,
  _CAInvcgDocHeader._CAInvcgDocHeader AS _CAInvcgDocHeader,
  _CAInvcgDocHeader._CAInvcgDocPartOfList AS _CAInvcgDocPartOfList,
  _CAInvcgDocHeader._CAInvcgDocReversalReason AS _CAInvcgDocReversalReason,
  _CAInvcgDocHeader._CAInvcgDocTechDocType AS _CAInvcgDocTechDocType,
  _CAInvcgDocHeader._CAInvcgMasterDataType AS _CAInvcgMasterDataType,
  _CAInvcgDocHeader._CAInvcgPeriodCat AS _CAInvcgPeriodCat,
  _CAInvcgDocHeader._CAInvcgProcess AS _CAInvcgProcess,
  _CAInvcgDocHeader._CAInvcgTargetProc AS _CAInvcgTargetProc,
  _CAInvcgDocHeader._CAInvcgType AS _CAInvcgType,
  _CAInvcgDocHeader._ProviderContract AS _ProviderContract
FROM I_CAInvcgDocHeader AS _CAInvcgDocHeader
LEFT OUTER JOIN I_CABillgRequest AS _CABillgReqDocHeader ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CAInvcgDocLockedforPrint AS _CAInvcgDocLockedForPrint ON CAInvcgDocIsLockedForPrinting = _CAInvcgDocLockedForPrint.CAInvcgDocIsLockedForPrinting  -- association [0..1]
;

Learn More