J_1USEXTRACTD - Extract data

Extract data information is stored in SAP table J_1USEXTRACTD.
It is part of development package J1US in software component FI-LOC-FI-UA. This development package consists of objects that can be grouped under "Country-specific functions for Ukraine (SD, MM)".

Fields for table J_1USEXTRACTD

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
ENAME	Extract code	X	J_1US_EXTRACT	CHAR	20
EPOS	Numeric field: Length 6	X	NUM06	NUMC	12
.INCLUDE				J_1USTOTALTABLE	0
CONTRACT	Contract number		J_1USCBELNR	CHAR	20
CBUZEI	Sales Document Item		POSNR_VA	NUMC	12
CDATE	Contracte date		J_1US_CDATE	DATS	16
BORDER	Order number		J_1USOBELNR	CHAR	20
OBUZEI	Sales Document Item		POSNR_VA	NUMC	12
ODATE	Date of order		J_1US_ODATE	DATS	16
DELIVERY	Delivery number		J_1USDBELNR	CHAR	20
DBUZEI	Delivery Item		POSNR_VL	NUMC	12
DDATE	Date of delivery		J_1US_DDATE	DATS	16
PGTD	Preliminary GTD number		J_1USPGBELNR	CHAR	20
PGBUZEI	Billing Item		POSNR_VF	NUMC	12
PGDATE	Prelimenary GTD date		J_1US_PGDATE	DATS	16
GTD	GTD number		J_1USGBELNR	CHAR	20
GBUZEI	Billing Item		POSNR_VF	NUMC	12
GDATE	Date of CCD		J_1US_GDATE	DATS	16
INVOICE_SD	Invoice number (SD)		J_1USIBELNR_SD	CHAR	20
IBUZEI_SD	Billing Item		POSNR_VF	NUMC	12
IDATE_SD	Date of invoice		J_1US_IDATE	DATS	16
INVOICE_FI	Invoice number (FI)		J_1USIBELNR_FI	CHAR	20
IBUZEI_FI	Number of Line Item Within Accounting Document		BUZEI	NUMC	6
IDATE_FI	Date of invoice		J_1US_IDATE	DATS	16
PAYMENT	Payment`s number		J_1USPBELNR	CHAR	20
PBUZEI	Number of Line Item Within Accounting Document		BUZEI	NUMC	6
PDATE	Date of payment		J_1US_PDATE	DATS	16
CWRBTR	Amount in document currency		WRBTR	CURR	12
CWAERS	Currency Key		WAERS	CUKY	10	*
OWRBTR	Amount in document currency		WRBTR	CURR	12
OWAERS	Currency Key		WAERS	CUKY	10	*
DWRBTR	Amount in document currency		WRBTR	CURR	12
DWAERS	Currency Key		WAERS	CUKY	10	*
GWRBTR	Amount in document currency		WRBTR	CURR	12
GWAERS	Currency Key		WAERS	CUKY	10	*
PGWRBTR	Amount in document currency		WRBTR	CURR	12
PGWAERS	Currency Key		WAERS	CUKY	10	*
ISDWRBTR	Amount in document currency		WRBTR	CURR	12
ISDWAERS	Currency Key		WAERS	CUKY	10	*
IFIWRBTR	Amount in document currency		WRBTR	CURR	12
IFIWAERS	Currency Key		WAERS	CUKY	10	*
PWRBTR	Amount in document currency		WRBTR	CURR	12
PWAERS	Currency Key		WAERS	CUKY	10	*
CZMENG	Contract quantity		J_1USMENGE	QUAN	7
CZIEME	Unit of measure		J_1USMEINS	UNIT	6	*
OZMENG	Contract quantity		J_1USMENGE	QUAN	7
OZIEME	Unit of measure		J_1USMEINS	UNIT	6	*
DLFIMG	Actual quantity delivered (in sales units)		LFIMG	QUAN	7
DVRKME	Sales unit		VRKME	UNIT	6	*
GFKIMG	Actual billed quantity		FKIMG	QUAN	7
GVRKME	Sales unit		VRKME	UNIT	6	*
PGFKIMG	Actual billed quantity		FKIMG	QUAN	7
PGVRKME	Sales unit		VRKME	UNIT	6	*
ISDFKIMG	Actual billed quantity		FKIMG	QUAN	7
ISDVRKME	Sales unit		VRKME	UNIT	6	*
MATNR	Material Number		MATNR	CHAR	80
MAKTX	Material Description		MAKTX	CHAR	80
CYCLE_DAY	Day from first document to last document		J_1US_CYCLE_DAY	NUMC	10
TOTAL_DAY	Day from first document to now		J_1US_TOTAL_DAY	NUMC	10
CONFIRM_DATE	Date of confirmation of tax departament		J_1US_CONFIRM_DATE	DATS	16
CONFIRM_DAY	Day from first doc. to date of confirmation of tax depar.		J_1US_CONFIRM_DAY	NUMC	10
SECEVT_DATE	Secondary Event Creation Date		J_1US_SECEVENT_DATE	DATS	16
GTDSEC_DAY	Time period between GTD and secondary event creation		J_1US_GTD_TO_SECEVENT	NUMC	10
GTDPAY_DAY	Time period between GTD date and payment date		J_1US_GTD_TO_PAYMENT	NUMC	10
GTDCONF_DAY	Time period between GTD date and confirmation date		J_1US_GTD_TO_CONFIRM	NUMC	10
TAXTR_DOC	Tax transfer document number		J_1US_TAX_DOC	CHAR	20
KUNNR	Customer Number		KUNNR	CHAR	20