SAP FDM_COLL_INVOICE_BW table - BI Extract Structure: Invoice details in SAP

SAP FDM_COLL_INVOICE_BW table summary

Object Name: FDM_COLL_INVOICE_BW
Dictionary Type: Structure
Description: BI Extract Structure: Invoice

Field list for FDM_COLL_INVOICE_BW table on an S/4 SAP system

Details

FDM_COLL_INVOICE_BW-COMP_CODE table field - Company Code ▼

Description: Company Code
Field Name: COMP_CODE
Data Element: BUKRS
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: BUKRS
MemoryID: BUK
AppClass: FB
SHLP: C_T001
SHLP Field: BUKRS
ConvExit:

See all SAP tables containing field COMP_CODE

FDM_COLL_INVOICE_BW-INVOICE_NO table field - Accounting Document Number ▼

Description: Accounting Document Number
Field Name: INVOICE_NO
Data Element: BELNR_D
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: BELNR
MemoryID: BLN
AppClass: FB
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field INVOICE_NO

FDM_COLL_INVOICE_BW-FISCAL_YEAR table field - Fiscal Year ▼

Description: Fiscal Year
Field Name: FISCAL_YEAR
Data Element: GJAHR
Data Type: NUMC
length (Dec): 4(0)
Check table:
Conversion Routine: GJAHR
Domain Name: GJAHR
MemoryID: GJR
AppClass: SAP
SHLP:
SHLP Field:
ConvExit: GJAHR

See all SAP tables containing field FISCAL_YEAR

FDM_COLL_INVOICE_BW-DOC_ITEM table field - Number of Line Item Within Accounting Document ▼

Description: Number of Line Item Within Accounting Document
Field Name: DOC_ITEM
Data Element: BUZEI
Data Type: NUMC
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: BUZEI
MemoryID: BUZ
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DOC_ITEM

FDM_COLL_INVOICE_BW-CUSTOMER table field - Customer Number ▼

Description: Customer Number
Field Name: CUSTOMER
Data Element: KUNNR
Data Type: CHAR
length (Dec): 10(0)
Check table: *
Conversion Routine: ALPHA
Domain Name: KUNNR
MemoryID: KUN
AppClass: V
SHLP: C_KUNNR
SHLP Field: KUNNR
ConvExit: ALPHA

See all SAP tables containing field CUSTOMER

FDM_COLL_INVOICE_BW-LOGSYS table field - Logical system ▼

Description: Logical system
Field Name: LOGSYS
Data Element: LOGSYS
Data Type: CHAR
length (Dec): 10(0)
Check table: *
Conversion Routine: ALPHA
Domain Name: LOGSYS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field LOGSYS

FDM_COLL_INVOICE_BW-FISCAL_VAR table field - Fiscal Year Variant ▼

Description: Fiscal Year Variant
Field Name: FISCAL_VAR
Data Element: PERIV
Data Type: CHAR
length (Dec): 2(0)
Check table: *
Conversion Routine:
Domain Name: PERIV
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FISCAL_VAR

FDM_COLL_INVOICE_BW-BILLING_DOC table field - Billing Document ▼

Description: Billing Document
Field Name: BILLING_DOC
Data Element: VBELN_VF
Data Type: CHAR
length (Dec): 10(0)
Check table: *
Conversion Routine: ALPHA
Domain Name: VBELN
MemoryID: VF
AppClass: V
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field BILLING_DOC

FDM_COLL_INVOICE_BW-INVOICE_STATUS table field - Invoice Status ▼

Description: Invoice Status
Field Name: INVOICE_STATUS
Data Element: FDM_BW_INVOICE_STATUS
Data Type: NUMC
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: FDM_BW_INVOICE_STATUS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INVOICE_STATUS

FDM_COLL_INVOICE_BW-POSTING_DATE table field - Posting Date in the Document ▼

Description: Posting Date in the Document
Field Name: POSTING_DATE
Data Element: BUDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSTING_DATE

FDM_COLL_INVOICE_BW-INV_DATE table field - Document Date in Document ▼

Description: Document Date in Document
Field Name: INV_DATE
Data Element: BLDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INV_DATE

FDM_COLL_INVOICE_BW-DUE_DATE table field - Net Due Date ▼

Description: Net Due Date
Field Name: DUE_DATE
Data Element: FAEDT_FPOS
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DUE_DATE

FDM_COLL_INVOICE_BW-PAYMENT_DATE table field - Date of Last Incoming Payment for Invoice ▼

Description: Date of Last Incoming Payment for Invoice
Field Name: PAYMENT_DATE
Data Element: FDM_LAST_PAYMENT_DATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAYMENT_DATE

FDM_COLL_INVOICE_BW-DUNNING_DATE table field - Date of Last Dunning Notice for Invoice ▼

Description: Date of Last Dunning Notice for Invoice
Field Name: DUNNING_DATE
Data Element: FDM_LAST_DUNNING_DATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DUNNING_DATE

FDM_COLL_INVOICE_BW-CURRENCY table field - Currency Key ▼

Description: Currency Key
Field Name: CURRENCY
Data Element: WAERS
Data Type: CUKY
length (Dec): 5(0)
Check table: *
Conversion Routine:
Domain Name: WAERS
MemoryID: FWS
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CURRENCY

FDM_COLL_INVOICE_BW-INVOICE_AMOUNT table field - Original Amount of Invoice or Credit ▼

Description: Original Amount of Invoice or Credit
Field Name: INVOICE_AMOUNT
Data Element: FDM_INVOICE_AMOUNT
Data Type: CURR
length (Dec): 15(2)
Check table:
Conversion Routine:
Domain Name: WERTV8
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INVOICE_AMOUNT

FDM_COLL_INVOICE_BW-PAID_AMOUNT table field - Amount Paid ▼

Description: Amount Paid
Field Name: PAID_AMOUNT
Data Element: BDM_PAID_AMOUNT
Data Type: CURR
length (Dec): 15(2)
Check table:
Conversion Routine:
Domain Name: WERT8
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAID_AMOUNT

FDM_COLL_INVOICE_BW-OPEN_AMOUNT table field - Open Amount ▼

Description: Open Amount
Field Name: OPEN_AMOUNT
Data Element: FDM_OPEN_AMOUNT
Data Type: CURR
length (Dec): 15(2)
Check table:
Conversion Routine:
Domain Name: WERTV8
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPEN_AMOUNT

FDM_COLL_INVOICE_BW-CREDITED_AMOUNT table field - Total of All Credits for Selected Invoice ▼

Description: Total of All Credits for Selected Invoice
Field Name: CREDITED_AMOUNT
Data Element: FDM_CREDIT_AMOUNT
Data Type: CURR
length (Dec): 13(2)
Check table:
Conversion Routine:
Domain Name: WERT7
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREDITED_AMOUNT

FDM_COLL_INVOICE_BW-DUNNING_AMOUNT table field - Dunned Amount ▼

Description: Dunned Amount
Field Name: DUNNING_AMOUNT
Data Element: FDM_DUNNING_AMOUNT
Data Type: CURR
length (Dec): 15(2)
Check table:
Conversion Routine:
Domain Name: WERTV8
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DUNNING_AMOUNT

FDM_COLL_INVOICE_BW-PAYMENT_ARRANGED table field - Amount Arranged for Payment ▼

Description: Amount Arranged for Payment
Field Name: PAYMENT_ARRANGED
Data Element: FDM_PAYMENT_ARRANGED
Data Type: CURR
length (Dec): 13(2)
Check table:
Conversion Routine:
Domain Name: WERT7
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAYMENT_ARRANGED

FDM_COLL_INVOICE_BW-TIME_STAMP table field - Time Stamp for Upload of BI Delta ▼

Description: Time Stamp for Upload of BI Delta
Field Name: TIME_STAMP
Data Element: FDM_BW_TIME_STAMP
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: FDM_BW_TIME_STAMP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TIME_STAMP

FDM_COLL_INVOICE_BW-COLL_DEBITOR table field - Customer Number ▼

Description: Customer Number
Field Name: COLL_DEBITOR
Data Element: KUNNR
Data Type: CHAR
length (Dec): 10(0)
Check table: *
Conversion Routine: ALPHA
Domain Name: KUNNR
MemoryID: KUN
AppClass: V
SHLP: C_KUNNR
SHLP Field: KUNNR
ConvExit: ALPHA

See all SAP tables containing field COLL_DEBITOR

View list of all SAP tables(S4H/ECC)

Select data from SAP table