I_CAInvcgDocMassCreate

DDL: I_CAINVCGDOCMASSCREATE SQL: ICAINVDOCMC_H Type: view COMPOSITE

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_CABillgReqDocHeader, I_CAInvcgDocHeader) and exposes 82 fields with key field CAInvoicingDocument. It has 1 association to related views.

2 data source(s) 82 fields

Data Sources (2)

SourceAliasJoin Type
I_CABillgReqDocHeader _CABillgReqDocHeader left_outer
I_CAInvcgDocHeader _CAInvcgDocHeader from

Associations (1)

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

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICAINVDOCMC_H view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey CAInvoicingDocument 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
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (82)

KeyFieldSource TableSource FieldDescription
KEY CAInvoicingDocument I_CAInvcgDocHeader CAInvoicingDocument
CAApplicationArea I_CAInvcgDocHeader CAApplicationArea
CAInvcgProcess CAInvcgProcess
CAInvcgType CAInvcgType
CAInvcgCategory CAInvcgCategory
CAInvcgTechnicalDocumentType CAInvcgTechnicalDocumentType
CAInvcgTargetProcess CAInvcgTargetProcess
BusinessPartner I_CAInvcgDocHeader BusinessPartner
ContractAccount I_CAInvcgDocHeader ContractAccount
CAInvcgMasterDataType CAInvcgMasterDataType
AltvContractAcctForCollvBills AltvContractAcctForCollvBills
CASubstituteDocumentNumber CASubstituteDocumentNumber
CreatedByUser CreatedByUser
CAInvcgCreationDate CAInvcgCreationDate
CAInvcgCreationTime CAInvcgCreationTime
CAInvcgDocCreationMode CAInvcgDocCreationMode
CAInvcgNmbrOfInvoicingDocItems CAInvcgNmbrOfInvoicingDocItems
CAInvcgDocInternalNumber CAInvcgDocInternalNumber
CAReconciliationKey CAReconciliationKey
CAPostingDate CAPostingDate
DocumentDate DocumentDate
CANetDueDate CANetDueDate
CACashDiscountDueDate CACashDiscountDueDate
CACashDiscountRate CACashDiscountRate
TransactionCurrency TransactionCurrency
CAAmountInTransactionCurrency CAAmountInTransactionCurrency
CAInvcgIsDocumentPosted CAInvcgIsDocumentPosted
CAInvcgIsDocumentSimulated CAInvcgIsDocumentSimulated
CAInvcgIsDocumentPreliminary CAInvcgIsDocumentPreliminary
CAInvcgPreliminaryCategory CAInvcgPreliminaryCategory
CAInvcgDocumentReversalReason CAInvcgDocumentReversalReason
CAInvcgReversalDocument CAInvcgReversalDocument
CAInvcgReversedDocument CAInvcgReversedDocument
CAInvcgCorrectionCategory CAInvcgCorrectionCategory
CAInvcgDocumentPrintDate CAInvcgDocumentPrintDate
CAInvcgDocIsLockedForPrinting CAInvcgDocIsLockedForPrinting
CAPaymentMethod CAPaymentMethod
CAPaymentFormNumber CAPaymentFormNumber
CAInvcgDocFormID CAInvcgDocFormID
ApplicationForm ApplicationForm
FormIDForAttachedPaymentMedium FormIDForAttachedPaymentMedium
CAInvcgDocumentType CAInvcgDocumentType
CAKeyIdentification CAKeyIdentification
CAOfficialDocumentNumber CAOfficialDocumentNumber
CAPartnerSettlementRule CAPartnerSettlementRule
CompanyCode CompanyCode
BusinessPlace BusinessPlace
CAContract CAContract
CASubApplication CASubApplication
CAInvcgBaseDate CAInvcgBaseDate
CAInvcgDocPeriodCategory CAInvcgDocPeriodCategory
CAInvcgDocPeriodDate CAInvcgDocPeriodDate
CAInvcgDocPeriodStartDate CAInvcgDocPeriodStartDate
CADunningCounter CADunningCounter
CAInvcgDocHasChargeOrDiscItems CAInvcgDocHasChargeOrDiscItems
CAInvcgDocHasControlDoc CAInvcgDocHasControlDoc
CAInvcgBolloTaxPostStatus CAInvcgBolloTaxPostStatus
CAInvcgDocIsPartOfList CAInvcgDocIsPartOfList
CAInvcgDocHasObjectRelation CAInvcgDocHasObjectRelation
CAInvcgDocHasSEPAPreNotif CAInvcgDocHasSEPAPreNotif
CAInvcgDocExternal CAInvcgDocExternal
CAInvcgAdjustmentDocument CAInvcgAdjustmentDocument
CAInvcgAdjustedDocument CAInvcgAdjustedDocument
NameNumberRangeObject
_CAApplicationArea I_CAInvcgDocHeader _CAApplicationArea
_CompanyCode _CompanyCode
_CAInvcgBolloTaxPostStatus _CAInvcgBolloTaxPostStatus
_CAInvcgCategory _CAInvcgCategory
_CAInvcgCorrectionCat _CAInvcgCorrectionCat
_CAInvcgDocChrgDiscItems _CAInvcgDocChrgDiscItems
_CAInvcgDocCreationMode _CAInvcgDocCreationMode
_CAInvcgDocHeader I_CAInvcgDocHeader _CAInvcgDocHeader
_CAInvcgDocLockedForPrint _CAInvcgDocLockedForPrint
_CAInvcgDocPartOfList _CAInvcgDocPartOfList
_CAInvcgDocReversalReason _CAInvcgDocReversalReason
_CAInvcgDocTechDocType _CAInvcgDocTechDocType
_CAInvcgMasterDataType _CAInvcgMasterDataType
_CAInvcgPeriodCat _CAInvcgPeriodCat
_CAInvcgProcess _CAInvcgProcess
_CAInvcgTargetProc _CAInvcgTargetProc
_CAInvcgType _CAInvcgType
_ProviderContract _ProviderContract 
@AbapCatalog.sqlViewName: 'ICAINVDOCMC_H'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'CAInvoicingDocument'
@EndUserText.label: 'Abrechnungsauftrag (Mass)'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_CAInvcgDocMassCreate
  as select from    I_CAInvcgDocHeader    as _CAInvcgDocHeader
    left outer join I_CABillgReqDocHeader 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,
       CAInvcgProcess,
       CAInvcgType,
       CAInvcgCategory,
       CAInvcgTechnicalDocumentType,
       CAInvcgTargetProcess,
       _CAInvcgDocHeader.BusinessPartner,
       _CAInvcgDocHeader.ContractAccount,
       CAInvcgMasterDataType,
       AltvContractAcctForCollvBills,
       CASubstituteDocumentNumber,
       CreatedByUser,
       CAInvcgCreationDate,
       CAInvcgCreationTime,
       CAInvcgDocCreationMode,
       CAInvcgNmbrOfInvoicingDocItems,
       CAInvcgDocInternalNumber,
       CAReconciliationKey,
       CAPostingDate,
       DocumentDate,
       CANetDueDate,
       CACashDiscountDueDate,
       CACashDiscountRate,
       TransactionCurrency,
       CAAmountInTransactionCurrency,
       CAInvcgIsDocumentPosted,
       CAInvcgIsDocumentSimulated,
       CAInvcgIsDocumentPreliminary,
       CAInvcgPreliminaryCategory,
       CAInvcgDocumentReversalReason,
       CAInvcgReversalDocument,
       CAInvcgReversedDocument,
       CAInvcgCorrectionCategory,
       CAInvcgDocumentPrintDate,
       CAInvcgDocIsLockedForPrinting,
       CAPaymentMethod,
       CAPaymentFormNumber,
       CAInvcgDocFormID,
       ApplicationForm,
       FormIDForAttachedPaymentMedium,
       CAInvcgDocumentType,
       CAKeyIdentification,
       CAOfficialDocumentNumber,
       CAPartnerSettlementRule,
       CompanyCode,
       BusinessPlace,
       CAContract,
       CASubApplication,
       CAInvcgBaseDate,
       CAInvcgDocPeriodCategory,
       CAInvcgDocPeriodDate,
       CAInvcgDocPeriodStartDate,
       CADunningCounter,
       CAInvcgDocHasChargeOrDiscItems,
       CAInvcgDocHasControlDoc,
       CAInvcgBolloTaxPostStatus,
       CAInvcgDocIsPartOfList,
       CAInvcgDocHasObjectRelation,
       CAInvcgDocHasSEPAPreNotif,
       CAInvcgDocExternal,
       CAInvcgAdjustmentDocument,
       CAInvcgAdjustedDocument,

       cast( 'FKKINV' as nrobj ) as NameNumberRangeObject,


       /* Associations */
       //_CAInvcgDocHeader

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


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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CABILLGREQDOCHEADER",
"I_CAINVCGDOCHEADER"
],
"ASSOCIATED":
[
"I_CAAPPLICATIONAREA",
"I_CAINVCGBOLLOTAXPOSTSTATUS",
"I_CAINVCGCATEGORY",
"I_CAINVCGCORRECTIONCAT",
"I_CAINVCGDOCCHRGDISCITEMS",
"I_CAINVCGDOCCREATIONMODE",
"I_CAINVCGDOCHEADER",
"I_CAINVCGDOCLOCKEDFORPRINT",
"I_CAINVCGDOCPARTOFLIST",
"I_CAINVCGDOCREVERSALREASON",
"I_CAINVCGDOCTECHDOCTYPE",
"I_CAINVCGMASTERDATATYPE",
"I_CAINVCGPERIODCAT",
"I_CAINVCGPROCESS",
"I_CAINVCGTARGETPROC",
"I_CAINVCGTYPE",
"I_CAPROVIDERCONTRACTHEADER",
"I_COMPANYCODE"
],
"BASE":
[
"I_CAINVCGDOCHEADER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More