I_CABillPrntInvcgDocHeader

DDL: I_CABILLPRNTINVCGDOCHEADER Type: view_entity COMPOSITE Package: FKKINV_VDM_INV

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)

SourceAliasJoin Type
I_CAInvcgDocHeader _CAInvcgDocHeader from

Associations (12)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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
}