Bill Documents for Bill Header

DataSource Attributes: 0UC_INVDOC

This DataSource supports navigation to SAP BW via all fields in the TINV_INV_DOC database table (bill document for bill header).

Technical Data

Application Component	0IS_UC_IDE
Available as of Release	mySAP ERP 2005
Shipment
Content Versions	No content versions exist.
RemoteCube-Capable	No
Delta-Capable	Yes
Extraction from Archives	No
Verifiable

Data Modeling

Delta Update

Direct access to data is supported.
Delta procedure: AIM

Fields of Origin for the Extract Structure
Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
`MANDT`	Client	`TINV_INV_DOC`	`MANDT`
`INT_INV_DOC_NO`	Internal Number of Bill Document/Payment Advice Note Document	`TINV_INV_DOC`	`INT_INV_DOC_NO`
`INT_INV_NO`	Internal Number of Bill/Payment Advice Note	`TINV_INV_DOC`	`INT_INV_NO`
`DOC_NR`	Sequential Number of Document for Document Header	`TINV_INV_DOC`	`DOC_NR`
`EXT_PARTNER`	Business Partner Number in External System	`TINV_INV_DOC`	`EXT_PARTNER`
`INT_IDENT_TYPE`	Type of Internal Identifier	`TINV_INV_DOC`	`INT_IDENT_TYPE`
`INT_IDENT`	Internal Identification of Document	`TINV_INV_DOC`	`INT_IDENT`
`INT_PARTNER`	Business partner number	`TINV_INV_DOC`	`INT_PARTNER`
`INVOICE_DATE`	Date of Bill or Payment Advice Note	`TINV_INV_DOC`	`INVOICE_DATE`
`INVPERIOD_START`	Start of Period, for Which the Bill/Payment Advice Note Is Valid	`TINV_INV_DOC`	`INVPERIOD_START`
`INVPERIOD_END`	End of Period, for Which the Bill/Payment Advice Note Is Valid	`TINV_INV_DOC`	`INVPERIOD_END`
`EXT_INVOICE_NO`	External Bill Number/Payment Advice Note Number	`TINV_INV_DOC`	`EXT_INVOICE_NO`
`DOC_TYPE`	Document Type	`TINV_INV_DOC`	`DOC_TYPE`
`DATE_OF_PAYMENT`	Due Date	`TINV_INV_DOC`	`DATE_OF_PAYMENT`
`PAYMENTDATE`	Date of Payment	`TINV_INV_DOC`	`PAYMENTDATE`
`VTREF`	Reference Data from Contract	`TINV_INV_DOC`	`VTREF`
`CURRENCY`	Currency Key	`TINV_INV_DOC`	`CURRENCY`
`INV_DOC_STATUS`	Status of Document	`TINV_INV_DOC`	`INV_DOC_STATUS`
`INT_INV_BKID`	Internal Key for Bank Details	`TINV_INV_DOC`	`INT_INV_BKID`
`INV_BVT`	Bank Details ID for Sender	`TINV_INV_DOC`	`INV_BVT`
`INT_INV_BKID_R`	Internal Key for Bank Details	`TINV_INV_DOC`	`INT_INV_BKID_R`
`INV_BVT_R`	Bank Details Identification for Recipient	`TINV_INV_DOC`	`INV_BVT_R`
`INV_CANCEL_RSN`	Reversal Reason	`TINV_INV_DOC`	`INV_CANCEL_RSN`
`INV_CANCEL_DOC`	Number of Document, Which Reverses Current Document	`TINV_INV_DOC`	`INV_CANCEL_DOC`
`CREATED_BY`	Name of Agent Who Added the Object	`TINV_INV_DOC`	`CREATED_BY`
`CREATED_ON`	Date, On Which Record Was Added	`TINV_INV_DOC`	`CREATED_ON`
`CHANGED_BY`	Name of Agent Who Changed the Object	`TINV_INV_DOC`	`CHANGED_BY`
`CHANGED_ON`	Date of Last Change	`TINV_INV_DOC`	`CHANGED_ON`
`INVOICE_TYPE`	Type of Bill/Payment Advice Note	`TINV_INV_DOC`	`INVOICE_TYPE`
`RSTGR`	Reason Code for Payments	`TINV_INV_DOC`	`RSTGR`
`INT_INV_BKID_BW`	Internal Key for Bank Details in BW		`Konvertiert aus TINV_INV_DOC-INT_INV_BKID`
`INT_INV_BKIDR_BW`	Internal Key for Bank Details in BW	`Table of origin`	`Konvertiert aus TINV_INV_DOC-INT_INV_BKIDR`
`RODMUPDMOD`	BW Delta Procedure: Record Mode
`LOEVM`	Deletion Indicator
`.INCLUDE`	CI_BIW_INVOICE_DOC	`TINV_INV_DOC`	`.INCLUDE CI_INVOICE_DOC`

Extractor Logic

The INT_INV_BKID_BW (GUID_C32) field is converted from the TINV_INV_DOC-INT_INV_BKID (GUID_C22) field.
The INT_INV_BKIDR_BW (GUID_C32) field is converted from the TINV_INV_DOC-INT_INV_BKIDR (GUID_C22) field.