J_1USEXTRACTD SAP (EXTRACTD) Table details

Dictionary Type: Table
Description: EXTRACTD




ABAP Code to SELECT data from J_1USEXTRACTD
Related tables to J_1USEXTRACTD
Access table J_1USEXTRACTD




Table field list including key, data, relationships and ABAP select examples

J_1USEXTRACTD is a standard SAP Table which is used to store EXTRACTD data and is available within R/3 SAP systems depending on the version and release level.

The J_1USEXTRACTD table consists of various fields, each holding specific information or linking keys about EXTRACTD data available in SAP. These include ENAME (), EPOS (Numeric field: Length 6), CONTRACT (), CBUZEI (Sales Document Item).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP J_1USEXTRACTD table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
ENAME J_1US_EXTRACTCHAR10CHAR10
EPOSNumeric field: Length 6 NUM06NUMC6NUM06
CONTRACT J_1USCBELNRCHAR10ALPHABELNR
CBUZEISales Document Item POSNR_VANUMC6Assigned to domainPOSNRAPO
CDATE J_1US_CDATEDATS8DATE
BORDER J_1USOBELNRCHAR10ALPHABELNR
OBUZEISales Document Item POSNR_VANUMC6Assigned to domainPOSNRAPO
ODATE J_1US_ODATEDATS8DATE
DELIVERY J_1USDBELNRCHAR10ALPHABELNR
DBUZEIDelivery Item POSNR_VLNUMC6Assigned to domainPOSNR
DDATE J_1US_DDATEDATS8DATE
PGTD J_1USPGBELNRCHAR10ALPHABELNR
PGBUZEIBilling item POSNR_VFNUMC6Assigned to domainPOSNR
PGDATE J_1US_PGDATEDATS8DATE
GTD J_1USGBELNRCHAR10ALPHABELNR
GBUZEIBilling item POSNR_VFNUMC6Assigned to domainPOSNR
GDATE J_1US_GDATEDATS8DATE
INVOICE_SD J_1USIBELNR_SDCHAR10ALPHABELNR
IBUZEI_SDBilling item POSNR_VFNUMC6Assigned to domainPOSNR
IDATE_SD J_1US_IDATEDATS8DATE
INVOICE_FI J_1USIBELNR_FICHAR10ALPHABELNR
IBUZEI_FINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
IDATE_FI J_1US_IDATEDATS8DATE
PAYMENT J_1USPBELNRCHAR10ALPHABELNR
PBUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
PDATE J_1US_PDATEDATS8DATE
CWRBTRAmount in document currency WRBTRCURR13(2) WERT7
CWAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
OWRBTRAmount in document currency WRBTRCURR13(2) WERT7
OWAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
DWRBTRAmount in document currency WRBTRCURR13(2) WERT7
DWAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
GWRBTRAmount in document currency WRBTRCURR13(2) WERT7
GWAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
PGWRBTRAmount in document currency WRBTRCURR13(2) WERT7
PGWAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
ISDWRBTRAmount in document currency WRBTRCURR13(2) WERT7
ISDWAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
IFIWRBTRAmount in document currency WRBTRCURR13(2) WERT7
IFIWAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
PWRBTRAmount in document currency WRBTRCURR13(2) WERT7
PWAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
CZMENG J_1USMENGEQUAN13(3) MENG13
CZIEME J_1USMEINSUNIT3Assigned to domainCUNITMEINS
OZMENG J_1USMENGEQUAN13(3) MENG13
OZIEME J_1USMEINSUNIT3Assigned to domainCUNITMEINS
DLFIMGActual quantity delivered (in sales units) LFIMGQUAN13(3) MENG13
DVRKMESales unit VRKMEUNIT3Assigned to domainCUNITMEINS
GFKIMGActual Invoiced Quantity FKIMGQUAN13(3) MENG13
GVRKMESales unit VRKMEUNIT3Assigned to domainCUNITMEINS
PGFKIMGActual Invoiced Quantity FKIMGQUAN13(3) MENG13
PGVRKMESales unit VRKMEUNIT3Assigned to domainCUNITMEINS
ISDFKIMGActual Invoiced Quantity FKIMGQUAN13(3) MENG13
ISDVRKMESales unit VRKMEUNIT3Assigned to domainCUNITMEINS
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
MAKTXMaterial Description (Short Text) MAKTXCHAR40TEXT40
CYCLE_DAY J_1US_CYCLE_DAYNUMC5J_1US_DAY
TOTAL_DAY J_1US_TOTAL_DAYNUMC5J_1US_DAY
CONFIRM_DATE J_1US_CONFIRM_DATEDATS8DATUM
CONFIRM_DAY J_1US_CONFIRM_DAYNUMC5J_1US_DAY
SECEVT_DATE J_1US_SECEVENT_DATEDATS8DATS
GTDSEC_DAY J_1US_GTD_TO_SECEVENTNUMC5J_1US_DAY
GTDPAY_DAY J_1US_GTD_TO_PAYMENTNUMC5J_1US_DAY
GTDCONF_DAY J_1US_GTD_TO_CONFIRMNUMC5J_1US_DAY
TAXTR_DOC J_1US_TAX_DOCCHAR10ALPHABELNR
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR

Key field Non-key field



How do I retrieve data from SAP table J_1USEXTRACTD using ABAP code

The following ABAP code Example will allow you to do a basic selection on J_1USEXTRACTD to SELECT all data from the table
DATA: WA_J_1USEXTRACTD TYPE J_1USEXTRACTD.

SELECT SINGLE *
FROM J_1USEXTRACTD
INTO CORRESPONDING FIELDS OF WA_J_1USEXTRACTD
WHERE...

How to access SAP table J_1USEXTRACTD

Within an ECC or HANA version of SAP you can also view further information about J_1USEXTRACTD and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!