I_RU_INVOICEJOURNALDOCLINK
Link between outgoing and incoming invc.
I_RU_INVOICEJOURNALDOCLINK is a CDS View in S/4HANA. Link between outgoing and incoming invc.. It contains 20 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_RU_LinkedCommsnTradeInvoice0 | view | from | CONSUMPTION | Linked Commission Trade Invoices - Preparing 0 |
Fields (20)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | InternalTableKeyField | InternalTableKeyField | 1 |
| CommsnTradeInvcLinkedVATAmount | CommsnTradeInvcLinkedVATAmount | 1 | |
| CompanyCode | CompanyCode | 1 | |
| CorrectionInvoice | CorrectionInvoice | 1 | |
| CorrectionInvoiceYear | CorrectionInvoiceYear | 1 | |
| IncgOriglInvoiceRevisionNumber | IncgOriglInvoiceRevisionNumber | 1 | |
| IncomingCorrectionInvoice | IncomingCorrectionInvoice | 1 | |
| IncomingCorrectionInvoiceYear | IncomingCorrectionInvoiceYear | 1 | |
| IncomingRevisionInvoice | IncomingRevisionInvoice | 1 | |
| IncomingRevisionInvoiceYear | IncomingRevisionInvoiceYear | 1 | |
| IncomingRevisionNumber | IncomingRevisionNumber | 1 | |
| Invoice | Invoice | 1 | |
| InvoiceYear | InvoiceYear | 1 | |
| OriginalInvoiceRevisionNumber | OriginalInvoiceRevisionNumber | 1 | |
| RevisionInvoice | RevisionInvoice | 1 | |
| RevisionInvoiceYear | RevisionInvoiceYear | 1 | |
| RevisionNumber | RevisionNumber | 1 | |
| RU_IncomingInvoiceCompanyCode | RU_IncomingInvoiceCompanyCode | 1 | |
| RU_IncomingInvoiceFiscalYear | RU_IncomingInvoiceFiscalYear | 1 | |
| RU_IncomingInvoiceNumber | RU_IncomingInvoiceNumber | 1 |
@AbapCatalog.sqlViewName: 'IRUINCJRNLLINK'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@EndUserText.label: 'Link between outgoing and incoming invc.'
@VDM.viewType: #BASIC
define view I_RU_InvoiceJournalDocLink as select from firud_invj_link {
key db_key as InternalTableKeyField,
bukrs_out as CompanyCode,
belnr_out as Invoice,
gjahr_out as InvoiceYear,
corrdoc_out as CorrectionInvoice,
corryear_out as CorrectionInvoiceYear,
revisnum_out as RevisionNumber,
revisdoc_out as RevisionInvoice,
revisyear_out as RevisionInvoiceYear,
revisnumorig_out as OriginalInvoiceRevisionNumber,
belnr_in as RU_IncomingInvoiceNumber,
bukrs_in as RU_IncomingInvoiceCompanyCode,
gjahr_in as RU_IncomingInvoiceFiscalYear,
corrdoc_in as IncomingCorrectionInvoice,
corryear_in as IncomingCorrectionInvoiceYear,
revisnum_in as IncomingRevisionNumber,
revisdoc_in as IncomingRevisionInvoice,
revisyear_in as IncomingRevisionInvoiceYear,
revisnumorig_in as IncgOriglInvoiceRevisionNumber,
linked_amount as CommsnTradeInvoiceLinkedAmount,
linked_vat as CommsnTradeInvcLinkedVATAmount,
linking_curr as Currency
}