I_CAInvcgDocMassCreate

DDL: I_CAINVCGDOCMASSCREATE Type: view_entity COMPOSITE Package: FKKINV_VDM_BIT

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.

2 data source(s) 84 fields

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
CAApplicationArea I_CAInvcgDocHeader CAApplicationArea
CAInvcgProcess I_CAInvcgDocHeader CAInvcgProcess
CAInvcgType I_CAInvcgDocHeader CAInvcgType
CAInvcgCategory I_CAInvcgDocHeader CAInvcgCategory
CAInvcgTechnicalDocumentType I_CAInvcgDocHeader CAInvcgTechnicalDocumentType
CAInvcgTargetProcess I_CAInvcgDocHeader CAInvcgTargetProcess
BusinessPartner I_CAInvcgDocHeader BusinessPartner
ContractAccount I_CAInvcgDocHeader ContractAccount
CAInvcgMasterDataType I_CAInvcgDocHeader CAInvcgMasterDataType
AltvContractAcctForCollvBills I_CAInvcgDocHeader AltvContractAcctForCollvBills
CASubstituteDocumentNumber I_CAInvcgDocHeader CASubstituteDocumentNumber
CreatedByUser I_CAInvcgDocHeader CreatedByUser
CAInvcgCreationDate I_CAInvcgDocHeader CAInvcgCreationDate
CAInvcgCreationTime I_CAInvcgDocHeader CAInvcgCreationTime
CAInvcgDocCreationMode I_CAInvcgDocHeader CAInvcgDocCreationMode
CAInvcgNmbrOfInvoicingDocItems I_CAInvcgDocHeader CAInvcgNmbrOfInvoicingDocItems
CAInvcgDocInternalNumber I_CAInvcgDocHeader CAInvcgDocInternalNumber
CAReconciliationKey I_CAInvcgDocHeader CAReconciliationKey
CAPostingDate I_CAInvcgDocHeader CAPostingDate
DocumentDate I_CAInvcgDocHeader DocumentDate
CANetDueDate I_CAInvcgDocHeader CANetDueDate
CACashDiscountDueDate I_CAInvcgDocHeader CACashDiscountDueDate
CACashDiscountRate I_CAInvcgDocHeader CACashDiscountRate
TransactionCurrency I_CAInvcgDocHeader TransactionCurrency
CAAmountInTransactionCurrency I_CAInvcgDocHeader CAAmountInTransactionCurrency
CAInvcgIsDocumentPosted I_CAInvcgDocHeader CAInvcgIsDocumentPosted
CAInvcgIsDocumentSimulated I_CAInvcgDocHeader CAInvcgIsDocumentSimulated
CAInvcgIsDocumentPreliminary I_CAInvcgDocHeader CAInvcgIsDocumentPreliminary
CAInvcgPreliminaryCategory I_CAInvcgDocHeader CAInvcgPreliminaryCategory
CAInvcgDocumentReversalReason I_CAInvcgDocHeader CAInvcgDocumentReversalReason
CAInvcgReversalDocument I_CAInvcgDocHeader CAInvcgReversalDocument
CAInvcgReversedDocument I_CAInvcgDocHeader CAInvcgReversedDocument
CAInvcgCorrectionCategory I_CAInvcgDocHeader CAInvcgCorrectionCategory
CAInvcgDocumentPrintDate I_CAInvcgDocHeader CAInvcgDocumentPrintDate
CAInvcgDocIsLockedForPrinting I_CAInvcgDocHeader CAInvcgDocIsLockedForPrinting
CAPaymentMethod I_CAInvcgDocHeader CAPaymentMethod
CAPaymentFormNumber I_CAInvcgDocHeader CAPaymentFormNumber
CAInvcgDocFormID I_CAInvcgDocHeader CAInvcgDocFormID
ApplicationForm I_CAInvcgDocHeader ApplicationForm
FormIDForAttachedPaymentMedium I_CAInvcgDocHeader FormIDForAttachedPaymentMedium
CAInvcgDocumentType I_CAInvcgDocHeader CAInvcgDocumentType
CAKeyIdentification I_CAInvcgDocHeader CAKeyIdentification
CAOfficialDocumentNumber I_CAInvcgDocHeader CAOfficialDocumentNumber
CAPartnerSettlementRule I_CAInvcgDocHeader CAPartnerSettlementRule
CompanyCode I_CAInvcgDocHeader CompanyCode
BusinessPlace I_CAInvcgDocHeader BusinessPlace
CAContract I_CAInvcgDocHeader CAContract
CASubApplication I_CAInvcgDocHeader CASubApplication
CAInvcgBaseDate I_CAInvcgDocHeader CAInvcgBaseDate
CAInvcgDocPeriodCategory I_CAInvcgDocHeader CAInvcgDocPeriodCategory
CAInvcgDocPeriodDate I_CAInvcgDocHeader CAInvcgDocPeriodDate
CAInvcgDocPeriodStartDate I_CAInvcgDocHeader CAInvcgDocPeriodStartDate
CADunningCounter I_CAInvcgDocHeader CADunningCounter
CAInvcgDocHasChargeOrDiscItems I_CAInvcgDocHeader CAInvcgDocHasChargeOrDiscItems
CAInvcgDocHasControlDoc I_CAInvcgDocHeader CAInvcgDocHasControlDoc
CAInvcgBolloTaxPostStatus I_CAInvcgDocHeader CAInvcgBolloTaxPostStatus
CAInvcgDocIsPartOfList I_CAInvcgDocHeader CAInvcgDocIsPartOfList
CAInvcgDocHasObjectRelation I_CAInvcgDocHeader CAInvcgDocHasObjectRelation
CAInvcgDocHasSEPAPreNotif I_CAInvcgDocHeader CAInvcgDocHasSEPAPreNotif
CAInvcgDocExternal I_CAInvcgDocHeader CAInvcgDocExternal
CAInvcgAdjustmentDocument I_CAInvcgDocHeader CAInvcgAdjustmentDocument
CAInvcgAdjustedDocument I_CAInvcgDocHeader CAInvcgAdjustedDocument
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 
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.representativeKey: 'CAInvoicingDocument'
@Analytics.technicalName: 'ICAINVDOCMC_H'
@EndUserText.label: 'Abrechnungsauftrag (Mass)'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view entity I_CAInvcgDocMassCreate
  as select from    I_CAInvcgDocHeader    as _CAInvcgDocHeader
    left outer join I_CABillgRequest as _CABillgReqDocHeader on _CABillgReqDocHeader.CAInvoicingDocument = _CAInvcgDocHeader.CAInvoicingDocument

  association [0..1] to I_CAInvcgDocLockedforPrint as _CAInvcgDocLockedForPrint on $projection.CAInvcgDocIsLockedForPrinting = _CAInvcgDocLockedForPrint.CAInvcgDocIsLockedForPrinting

{
       //_CAInvcgDocHeader

  key  _CAInvcgDocHeader.CAInvoicingDocument,
       _CAInvcgDocHeader.CAApplicationArea,
       _CAInvcgDocHeader.CAInvcgProcess,
       _CAInvcgDocHeader.CAInvcgType,
       _CAInvcgDocHeader.CAInvcgCategory,
       _CAInvcgDocHeader.CAInvcgTechnicalDocumentType,
       _CAInvcgDocHeader.CAInvcgTargetProcess,
       _CAInvcgDocHeader.BusinessPartner,
       _CAInvcgDocHeader.ContractAccount,
       _CAInvcgDocHeader.CAInvcgMasterDataType,
       _CAInvcgDocHeader.AltvContractAcctForCollvBills,
       _CAInvcgDocHeader.CASubstituteDocumentNumber,
       _CAInvcgDocHeader.CreatedByUser,
       _CAInvcgDocHeader.CAInvcgCreationDate,
       _CAInvcgDocHeader.CAInvcgCreationTime,
       _CAInvcgDocHeader.CAInvcgDocCreationMode,
       _CAInvcgDocHeader.CAInvcgNmbrOfInvoicingDocItems,
       _CAInvcgDocHeader.CAInvcgDocInternalNumber,
       _CAInvcgDocHeader.CAReconciliationKey,
       _CAInvcgDocHeader.CAPostingDate,
       _CAInvcgDocHeader.DocumentDate,
       _CAInvcgDocHeader.CANetDueDate,
       _CAInvcgDocHeader.CACashDiscountDueDate,
       _CAInvcgDocHeader.CACashDiscountRate,
       _CAInvcgDocHeader.TransactionCurrency,
       @Semantics.amount.currencyCode: 'TRANSACTIONCURRENCY'
       _CAInvcgDocHeader.CAAmountInTransactionCurrency,
       _CAInvcgDocHeader.CAInvcgIsDocumentPosted,
       _CAInvcgDocHeader.CAInvcgIsDocumentSimulated,
       _CAInvcgDocHeader.CAInvcgIsDocumentPreliminary,
       _CAInvcgDocHeader.CAInvcgPreliminaryCategory,
       _CAInvcgDocHeader.CAInvcgDocumentReversalReason,
       _CAInvcgDocHeader.CAInvcgReversalDocument,
       _CAInvcgDocHeader.CAInvcgReversedDocument,
       _CAInvcgDocHeader.CAInvcgCorrectionCategory,
       _CAInvcgDocHeader.CAInvcgDocumentPrintDate,
       _CAInvcgDocHeader.CAInvcgDocIsLockedForPrinting,
       _CAInvcgDocHeader.CAPaymentMethod,
       _CAInvcgDocHeader.CAPaymentFormNumber,
       _CAInvcgDocHeader.CAInvcgDocFormID,
       _CAInvcgDocHeader.ApplicationForm,
       _CAInvcgDocHeader.FormIDForAttachedPaymentMedium,
       _CAInvcgDocHeader.CAInvcgDocumentType,
       _CAInvcgDocHeader.CAKeyIdentification,
       _CAInvcgDocHeader.CAOfficialDocumentNumber,
       _CAInvcgDocHeader.CAPartnerSettlementRule,
       _CAInvcgDocHeader.CompanyCode,
       _CAInvcgDocHeader.BusinessPlace,
       _CAInvcgDocHeader.CAContract,
       _CAInvcgDocHeader.CASubApplication,
       _CAInvcgDocHeader.CAInvcgBaseDate,
       _CAInvcgDocHeader.CAInvcgDocPeriodCategory,
       _CAInvcgDocHeader.CAInvcgDocPeriodDate,
       _CAInvcgDocHeader.CAInvcgDocPeriodStartDate,
       _CAInvcgDocHeader.CADunningCounter,
       _CAInvcgDocHeader.CAInvcgDocHasChargeOrDiscItems,
       _CAInvcgDocHeader.CAInvcgDocHasControlDoc,
       _CAInvcgDocHeader.CAInvcgBolloTaxPostStatus,
       _CAInvcgDocHeader.CAInvcgDocIsPartOfList,
       _CAInvcgDocHeader.CAInvcgDocHasObjectRelation,
       _CAInvcgDocHeader.CAInvcgDocHasSEPAPreNotif,
       _CAInvcgDocHeader.CAInvcgDocExternal,
       _CAInvcgDocHeader.CAInvcgAdjustmentDocument,
       _CAInvcgDocHeader.CAInvcgAdjustedDocument,

       cast( 'FKKINV' as nrobj ) as NameNumberRangeObject,


       /* Associations */
       //_CAInvcgDocHeader

       _CAInvcgDocHeader._ContractAccountHeader,
       _CAInvcgDocHeader._ContractAccountPartner,
       _CAInvcgDocHeader._CAApplicationArea,
       _CAInvcgDocHeader._CompanyCode,
       _CAInvcgDocHeader._CAInvcgBolloTaxPostStatus,
       _CAInvcgDocHeader._CAInvcgCategory,
       _CAInvcgDocHeader._CAInvcgCorrectionCat,
       _CAInvcgDocHeader._CAInvcgDocChrgDiscItems,
       _CAInvcgDocHeader._CAInvcgDocCreationMode,
       _CAInvcgDocHeader._CAInvcgDocHeader,
       _CAInvcgDocLockedForPrint,
       _CAInvcgDocHeader._CAInvcgDocPartOfList,
       _CAInvcgDocHeader._CAInvcgDocReversalReason,
       _CAInvcgDocHeader._CAInvcgDocTechDocType,
       _CAInvcgDocHeader._CAInvcgMasterDataType,
       _CAInvcgDocHeader._CAInvcgPeriodCat,
       _CAInvcgDocHeader._CAInvcgProcess,
       _CAInvcgDocHeader._CAInvcgTargetProc,
       _CAInvcgDocHeader._CAInvcgType,
       _CAInvcgDocHeader._ProviderContract,


       case when _CAInvcgDocHeader.CAInvoicingDocument = _CABillgReqDocHeader.CAInvoicingDocument
         then 'X'
         else ' '
       end                       as CABillgReqHasPrevious

}

Learn More