I_CABillPrntInvcgDocHeader
Fakt.beleg für Rechnungsausgabe
I_CABillPrntInvcgDocHeader is a Composite CDS View that provides data about "Fakt.beleg für Rechnungsausgabe" in SAP S/4HANA. It reads from 1 data source (I_CAInvcgDocHeader) and exposes 80 fields with key field CAInvoicingDocument. It has 12 associations to related views. Part of development package FKKINV_VDM_INV.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_CAInvcgDocHeader | _CAInvcgDocHeader | from |
Associations (12)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_CAInvcgTypeProcText | _CAInvcgTypeProcText | $projection.CAInvcgType = _CAInvcgTypeProcText.CAInvcgType and $projection.CAApplicationArea = _CAInvcgTypeProcText.CAApplicationArea and $projection.CAInvcgProcess = _CAInvcgTypeProcText.CAInvcgProcess |
| [0..1] | I_BusinessPartner | _BusinessPartner | $projection.BusinessPartner = _BusinessPartner.BusinessPartner |
| [0..1] | I_ContractAccountHeader | _ContractAccountHeader | $projection.ContractAccount = _ContractAccountHeader.ContractAccount |
| [0..1] | I_ContractAccountPartner | _ContractAccountPartner | $projection.ContractAccount = _ContractAccountPartner.ContractAccount and $projection.BusinessPartner = _ContractAccountPartner.BusinessPartner |
| [0..1] | I_CABillPrntBillData | _CABillPrntBillData | $projection.CAInvoicingDocument = _CABillPrntBillData.CAInvoicingDocument |
| [0..1] | I_CACorrespondenceHeader | _CACorrespondenceHeader | $projection.CAInvoicingDocument = _CACorrespondenceHeader.Correspondence2ndEntityData and $projection.CAInvcgProcess = _CACorrespondenceHeader.Correspondence1stEntityData |
| [0..1] | I_CABillPrntInvcgDocHeader | _CABillPrntInvcgDocHeader | $projection.CAInvoicingDocument = _CABillPrntInvcgDocHeader.CAInvoicingDocument |
| [0..*] | I_BusinessPartnerBank | _BusinessPartnerBank | $projection.BusinessPartner = _BusinessPartnerBank.BusinessPartner |
| [0..*] | I_Bank_2 | _Bank | _Bank.BankCountry = '' |
| [0..*] | I_Businesspartnertaxnumber | _BusinessPartnerTaxNumber | $projection.BusinessPartner = _BusinessPartnerTaxNumber.BusinessPartner |
| [0..1] | I_CAPaymentMethod | _CAPaymentMethod | $projection.CAPaymentCompanyCodeCountry = _CAPaymentMethod.Country and $projection.CAPaymentMethod = _CAPaymentMethod.CAPaymentMethod |
| [0..1] | E_CAInvcgDocHeader | _Extension | $projection.CAInvoicingDocument = _Extension.CAInvoicingDocument |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| VDM.viewType | #COMPOSITE | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.modelingPattern | #NONE | view | |
| ObjectModel.representativeKey | CAInvoicingDocument | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Fakt.beleg für Rechnungsausgabe | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (80)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CAInvoicingDocument | I_CAInvcgDocHeader | CAInvoicingDocument | |
| CAInvcgReferenceObject | ||||
| CAOfficialDocumentNumber | I_CAInvcgDocHeader | CAOfficialDocumentNumber | ||
| BusinessPartner | I_CAInvcgDocHeader | BusinessPartner | ||
| ContractAccount | I_CAInvcgDocHeader | ContractAccount | ||
| CAInvcgType | I_CAInvcgDocHeader | CAInvcgType | ||
| CAInvcgDocPeriodDate | I_CAInvcgDocHeader | CAInvcgDocPeriodDate | ||
| DocumentDate | I_CAInvcgDocHeader | DocumentDate | ||
| TransactionCurrency | I_CAInvcgDocHeader | TransactionCurrency | ||
| CAAmountInTransactionCurrency | I_CAInvcgDocHeader | CAAmountInTransactionCurrency | ||
| CAInvcgProcess | I_CAInvcgDocHeader | CAInvcgProcess | ||
| CAInvcgDocumentType | I_CAInvcgDocHeader | CAInvcgDocumentType | ||
| CADunningCounter | I_CAInvcgDocHeader | CADunningCounter | ||
| CAInvcgDocHasControlDoc | I_CAInvcgDocHeader | CAInvcgDocHasControlDoc | ||
| ApplicationForm | I_CAInvcgDocHeader | ApplicationForm | ||
| CAInvcgDocumentPrintDate | I_CAInvcgDocHeader | CAInvcgDocumentPrintDate | ||
| CAInvcgDocIsLockedForPrinting | I_CAInvcgDocHeader | CAInvcgDocIsLockedForPrinting | ||
| CANetDueDate | I_CAInvcgDocHeader | CANetDueDate | ||
| CAInvcgDocumentReversalReason | I_CAInvcgDocHeader | CAInvcgDocumentReversalReason | ||
| CAInvcgIsDocumentPosted | I_CAInvcgDocHeader | CAInvcgIsDocumentPosted | ||
| CAInvcgIsDocumentPreliminary | I_CAInvcgDocHeader | CAInvcgIsDocumentPreliminary | ||
| CAInvcgIsDocumentSimulated | I_CAInvcgDocHeader | CAInvcgIsDocumentSimulated | ||
| CAPostingDate | I_CAInvcgDocHeader | CAPostingDate | ||
| CAApplicationArea | I_CAInvcgDocHeader | CAApplicationArea | ||
| CAInvcgTechnicalDocumentType | I_CAInvcgDocHeader | CAInvcgTechnicalDocumentType | ||
| CAInvcgTargetProcess | I_CAInvcgDocHeader | CAInvcgTargetProcess | ||
| 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 | ||
| CACashDiscountDueDate | I_CAInvcgDocHeader | CACashDiscountDueDate | ||
| CACashDiscountRate | I_CAInvcgDocHeader | CACashDiscountRate | ||
| CAInvcgPreliminaryCategory | I_CAInvcgDocHeader | CAInvcgPreliminaryCategory | ||
| CAPrelimInvcgDocValue | I_CAInvcgDocHeader | CAPrelimInvcgDocValue | ||
| CAPreliminaryInvcgDocStatus | I_CAInvcgDocHeader | CAPreliminaryInvcgDocStatus | ||
| CAInvcgCategory | I_CAInvcgDocHeader | CAInvcgCategory | ||
| CAInvcgReversalDocument | I_CAInvcgDocHeader | CAInvcgReversalDocument | ||
| CAInvcgReversedDocument | I_CAInvcgDocHeader | CAInvcgReversedDocument | ||
| CAInvcgCorrectionCategory | I_CAInvcgDocHeader | CAInvcgCorrectionCategory | ||
| CAPaymentMethod | I_CAInvcgDocHeader | CAPaymentMethod | ||
| CAPaymentFormNumber | I_CAInvcgDocHeader | CAPaymentFormNumber | ||
| CAInvcgDocFormID | I_CAInvcgDocHeader | CAInvcgDocFormID | ||
| FormIDForAttachedPaymentMedium | I_CAInvcgDocHeader | FormIDForAttachedPaymentMedium | ||
| CAKeyIdentification | I_CAInvcgDocHeader | CAKeyIdentification | ||
| 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 | ||
| CAInvcgDocPeriodStartDate | I_CAInvcgDocHeader | CAInvcgDocPeriodStartDate | ||
| CAInvcgDocHasChargeOrDiscItems | I_CAInvcgDocHeader | CAInvcgDocHasChargeOrDiscItems | ||
| 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 | ||
| CAPaymentCompanyCodeCountry | ||||
| _CAInvcgTypeProcText | _CAInvcgTypeProcText | |||
| _BusinessPartner | _BusinessPartner | |||
| _BusinessPartnerBank | _BusinessPartnerBank | |||
| _Bank | _Bank | |||
| _BusinessPartnerTaxNumber | _BusinessPartnerTaxNumber | |||
| _ContractAccountPartner | _ContractAccountPartner | |||
| _ContractAccountHeader | _ContractAccountHeader | |||
| _CACorrespondenceHeader | _CACorrespondenceHeader | |||
| _CABillPrntBillData | _CABillPrntBillData | |||
| _CABillPrntInvcgDocHeader | _CABillPrntInvcgDocHeader | |||
| _ProviderContract | _ProviderContract | |||
| _CAPaymentMethod | _CAPaymentMethod | |||
| CAClassificationKey | I_CAInvcgDocHeader | CAClassificationKey |
@VDM.viewType: #COMPOSITE
@ObjectModel: {
usageType: {
serviceQuality: #D,
sizeCategory: #XL,
dataClass: #TRANSACTIONAL
},
modelingPattern: #NONE,
representativeKey: 'CAInvoicingDocument'
}
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Fakt.beleg für Rechnungsausgabe'
@Metadata.ignorePropagatedAnnotations: true
define view entity I_CABillPrntInvcgDocHeader
as select from I_CAInvcgDocHeader as _CAInvcgDocHeader
// association [1..*] to I_CABillPrntInvcgDocItem as _CABillPrntInvcgDocItem on $projection.CAInvoicingDocument = _CABillPrntInvcgDocItem.CAInvoicingDocument
association [0..*] to I_CAInvcgTypeProcText as _CAInvcgTypeProcText on $projection.CAInvcgType = _CAInvcgTypeProcText.CAInvcgType
and $projection.CAApplicationArea = _CAInvcgTypeProcText.CAApplicationArea
and $projection.CAInvcgProcess = _CAInvcgTypeProcText.CAInvcgProcess
association [0..1] to I_BusinessPartner as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
association [0..1] to I_ContractAccountHeader as _ContractAccountHeader on $projection.ContractAccount = _ContractAccountHeader.ContractAccount
association [0..1] to I_ContractAccountPartner as _ContractAccountPartner on $projection.ContractAccount = _ContractAccountPartner.ContractAccount
and $projection.BusinessPartner = _ContractAccountPartner.BusinessPartner
// association [0..*] to I_CABillPrntInvcgDocBillgReq as _CABillPrntInvcgDocBillgReq on $projection.CAInvoicingDocument = _CABillPrntInvcgDocBillgReq.CAInvoicingDocument
// and $projection.CAInvcgReferenceObject = _CABillPrntInvcgDocBillgReq.CAInvcgReferenceObject
association [0..1] to I_CABillPrntBillData as _CABillPrntBillData on $projection.CAInvoicingDocument = _CABillPrntBillData.CAInvoicingDocument
association [0..1] to I_CACorrespondenceHeader as _CACorrespondenceHeader on $projection.CAInvoicingDocument = _CACorrespondenceHeader.Correspondence2ndEntityData
and $projection.CAInvcgProcess = _CACorrespondenceHeader.Correspondence1stEntityData
association [0..1] to I_CABillPrntInvcgDocHeader as _CABillPrntInvcgDocHeader on $projection.CAInvoicingDocument = _CABillPrntInvcgDocHeader.CAInvoicingDocument
association [0..*] to I_BusinessPartnerBank as _BusinessPartnerBank on $projection.BusinessPartner = _BusinessPartnerBank.BusinessPartner
association [0..*] to I_Bank_2 as _Bank on _Bank.BankCountry = ''
association [0..*] to I_Businesspartnertaxnumber as _BusinessPartnerTaxNumber on $projection.BusinessPartner = _BusinessPartnerTaxNumber.BusinessPartner
// fkeys (not part of basic view due to complexity)
association [0..1] to I_CAPaymentMethod as _CAPaymentMethod on $projection.CAPaymentCompanyCodeCountry = _CAPaymentMethod.Country
and $projection.CAPaymentMethod = _CAPaymentMethod.CAPaymentMethod
// extension
association [0..1] to E_CAInvcgDocHeader as _Extension on $projection.CAInvoicingDocument = _Extension.CAInvoicingDocument
{
//INVDOCNO
key _CAInvcgDocHeader.CAInvoicingDocument,
cast( 'BILLREQ' as inv_refobjvalue_kk ) as CAInvcgReferenceObject,
//EXBEL
_CAInvcgDocHeader.CAOfficialDocumentNumber,
//GPART
_CAInvcgDocHeader.BusinessPartner,
//VKONT
_CAInvcgDocHeader.ContractAccount,
//INV_TYPE
_CAInvcgDocHeader.CAInvcgType,
//INVPERIOD
_CAInvcgDocHeader.CAInvcgDocPeriodDate,
//BLDAT
_CAInvcgDocHeader.DocumentDate,
//Amount and Currency
_CAInvcgDocHeader.TransactionCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
_CAInvcgDocHeader.CAAmountInTransactionCurrency,
//INV_PROCESS
_CAInvcgDocHeader.CAInvcgProcess,
//DOCTYPE
_CAInvcgDocHeader.CAInvcgDocumentType,
//MAZAE
_CAInvcgDocHeader.CADunningCounter,
//CFCSIMULATED
_CAInvcgDocHeader.CAInvcgDocHasControlDoc,
//FORMKEY
_CAInvcgDocHeader.ApplicationForm,
//PRINTDATE
_CAInvcgDocHeader.CAInvcgDocumentPrintDate,
//PRINTLOCK
_CAInvcgDocHeader.CAInvcgDocIsLockedForPrinting,
//FAEDN - Due date for net payment
_CAInvcgDocHeader.CANetDueDate,
//REVREASON - Reversal Reason
_CAInvcgDocHeader.CAInvcgDocumentReversalReason,
//INVOICED
_CAInvcgDocHeader.CAInvcgIsDocumentPosted,
//PRELIMINARY
_CAInvcgDocHeader.CAInvcgIsDocumentPreliminary,
//SIMULATED
_CAInvcgDocHeader.CAInvcgIsDocumentSimulated,
//BUDAT
_CAInvcgDocHeader.CAPostingDate,
//APPLK
_CAInvcgDocHeader.CAApplicationArea,
//TECHDOCTYPE
_CAInvcgDocHeader.CAInvcgTechnicalDocumentType,
//TARGPROCESS
_CAInvcgDocHeader.CAInvcgTargetProcess,
//MDCAT
_CAInvcgDocHeader.CAInvcgMasterDataType,
//ABWVK
_CAInvcgDocHeader.AltvContractAcctForCollvBills,
//ABWBL
_CAInvcgDocHeader.CASubstituteDocumentNumber,
//CRNAME
_CAInvcgDocHeader.CreatedByUser,
//CRDATE
_CAInvcgDocHeader.CAInvcgCreationDate,
//CRTIME
_CAInvcgDocHeader.CAInvcgCreationTime,
//CRMODE
_CAInvcgDocHeader.CAInvcgDocCreationMode,
//RECNUM
_CAInvcgDocHeader.CAInvcgNmbrOfInvoicingDocItems,
//INVRUNNO
_CAInvcgDocHeader.CAInvcgDocInternalNumber,
//FIKEY
_CAInvcgDocHeader.CAReconciliationKey,
//FAEDS
_CAInvcgDocHeader.CACashDiscountDueDate,
//SKTPZ
_CAInvcgDocHeader.CACashDiscountRate,
//PRLINV_CAT
_CAInvcgDocHeader.CAInvcgPreliminaryCategory,
//PRLINV_CNT
_CAInvcgDocHeader.CAPrelimInvcgDocValue,
//PRLINV_STATUS
_CAInvcgDocHeader.CAPreliminaryInvcgDocStatus,
//INV_CATEGORY
_CAInvcgDocHeader.CAInvcgCategory,
//REVERSALDOC
_CAInvcgDocHeader.CAInvcgReversalDocument,
//REVERSEDDOC
_CAInvcgDocHeader.CAInvcgReversedDocument,
//CORRCAT
_CAInvcgDocHeader.CAInvcgCorrectionCategory,
//PYMET
_CAInvcgDocHeader.CAPaymentMethod,
//NRZAS
_CAInvcgDocHeader.CAPaymentFormNumber,
//FORM_ID
_CAInvcgDocHeader.CAInvcgDocFormID,
//ZLSCH
_CAInvcgDocHeader.FormIDForAttachedPaymentMedium,
//EXKID
_CAInvcgDocHeader.CAKeyIdentification,
//PTSRL
_CAInvcgDocHeader.CAPartnerSettlementRule,
//BUKRS
_CAInvcgDocHeader.CompanyCode,
//BUPLA
_CAInvcgDocHeader.BusinessPlace,
//VTREF
_CAInvcgDocHeader.CAContract,
//SUBAP
_CAInvcgDocHeader.CASubApplication,
//INVOICE_BASEDATE
_CAInvcgDocHeader.CAInvcgBaseDate,
//INVPERCAT
_CAInvcgDocHeader.CAInvcgDocPeriodCategory,
//INVPERIOD
_CAInvcgDocHeader.CAInvcgDocPeriodStartDate,
//CHGDOC_EX
_CAInvcgDocHeader.CAInvcgDocHasChargeOrDiscItems,
//BOLLOTAX
_CAInvcgDocHeader.CAInvcgBolloTaxPostStatus,
//XSUBINV
_CAInvcgDocHeader.CAInvcgDocIsPartOfList,
//XINVDOC_X
_CAInvcgDocHeader.CAInvcgDocHasObjectRelation,
//SEPA_PRENOT
_CAInvcgDocHeader.CAInvcgDocHasSEPAPreNotif,
//EXT_INVDOCNO
_CAInvcgDocHeader.CAInvcgDocExternal,
//ADJUSTMENTDOC
_CAInvcgDocHeader.CAInvcgAdjustmentDocument,
//ADJUSTEDDOC
_CAInvcgDocHeader.CAInvcgAdjustedDocument,
_ContractAccountPartner._CompCodeGroup._CompanyCode.Country as CAPaymentCompanyCodeCountry,
// Make association public
// _CABillPrntInvcgDocItem,
_CAInvcgTypeProcText,
_BusinessPartner,
_BusinessPartnerBank,
_Bank,
_BusinessPartnerTaxNumber,
_ContractAccountPartner,
_ContractAccountHeader,
// _CABillPrntInvcgDocBillgReq,
_CACorrespondenceHeader,
_CABillPrntBillData,
_CABillPrntInvcgDocHeader,
_ProviderContract,
_CAPaymentMethod,
// Moved from Extension View X_S4C_I_CABILLPRNTINVCGDOCHDR
_CAInvcgDocHeader.CAClassificationKey
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA