J_3RSEXTRACTD is a SAP table coming under FI module and SAP_APPL component.View details, Fields & related tables of J_3RSEXTRACTD in SAP.
- Table description : Exctract details (obsolete)
- Module : FI-LOC
- Parent Module : FI
- Package : J3RS
- Software Component : SAP_APPL
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP J_3RSEXTRACTD Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| ENAME | Extract Name | J_3RS_EXTRACT | CHAR10 |
| EPOS | Numeric field: Length 6 | NUM06 | NUM06 |
| .INCLUDE | Structure contained document chains | ||
| CONTRACT | Contract Number | J_3RSCBELNR | BELNR |
| CBUZEI | Sales Document Item | POSNR_VA | POSNR |
| CDATE | Contract date | J_3RS_CDATE | DATE |
| BORDER | Order number | J_3RSOBELNR | BELNR |
| OBUZEI | Sales Document Item | POSNR_VA | POSNR |
| ODATE | Order date | J_3RS_ODATE | DATE |
| DELIVERY | Delivery number | J_3RSDBELNR | BELNR |
| DBUZEI | Delivery Item | POSNR_VL | POSNR |
| DDATE | Delivery date | J_3RS_DDATE | DATE |
| PGTD | Preliminary cargo customs declaration number | J_3RSPGBELNR | BELNR |
| PGBUZEI | Billing item | POSNR_VF | POSNR |
| PGDATE | Preliminary cargo customs declaration date | J_3RS_PGDATE | DATE |
| GTD | Cargo customs declaration number | J_3RSGBELNR | BELNR |
| GBUZEI | Billing item | POSNR_VF | POSNR |
| GDATE | Cargo customs declaration date | J_3RS_GDATE | DATE |
| INVOICE_SD | Invoice number (SD) | J_3RSIBELNR_SD | BELNR |
| IBUZEI_SD | Billing item | POSNR_VF | POSNR |
| IDATE_SD | Invoice date | J_3RS_IDATE | DATE |
| INVOICE_FI | Invoice Document Number in Financial Accounting | J_3RSIBELNR_FI | BELNR |
| IBUZEI_FI | Number of Line Item Within Accounting Document | BUZEI | BUZEI |
| IDATE_FI | Invoice date | J_3RS_IDATE | DATE |
| PAYMENT | Payment number | J_3RSPBELNR | BELNR |
| PBUZEI | Number of Line Item Within Accounting Document | BUZEI | BUZEI |
| PDATE | Payment date | J_3RS_PDATE | DATE |
| CWRBTR | Amount in document currency | WRBTR | WERT7 |
| CWAERS | Currency Key | WAERS | WAERS |
| OWRBTR | Amount in document currency | WRBTR | WERT7 |
| OWAERS | Currency Key | WAERS | WAERS |
| DWRBTR | Amount in document currency | WRBTR | WERT7 |
| DWAERS | Currency Key | WAERS | WAERS |
| GWRBTR | Amount in document currency | WRBTR | WERT7 |
| GWAERS | Currency Key | WAERS | WAERS |
| PGWRBTR | Amount in document currency | WRBTR | WERT7 |
| PGWAERS | Currency Key | WAERS | WAERS |
| ISDWRBTR | Amount in document currency | WRBTR | WERT7 |
| ISDWAERS | Currency Key | WAERS | WAERS |
| IFIWRBTR | Amount in document currency | WRBTR | WERT7 |
| IFIWAERS | Currency Key | WAERS | WAERS |
| PWRBTR | Amount in document currency | WRBTR | WERT7 |
| PWAERS | Currency Key | WAERS | WAERS |
| CZMENG | Contract amount | J_3RSMENGE | MENG13 |
| CZIEME | Unit of measure | J_3RSMEINS | MEINS |
| OZMENG | Contract amount | J_3RSMENGE | MENG13 |
| OZIEME | Unit of measure | J_3RSMEINS | MEINS |
| DLFIMG | Actual quantity delivered (in sales units) | LFIMG | MENG13 |
| DVRKME | Sales unit | VRKME | MEINS |
| GFKIMG | Actual billed quantity | FKIMG | MENG13 |
| GVRKME | Sales unit | VRKME | MEINS |
| PGFKIMG | Actual billed quantity | FKIMG | MENG13 |
| PGVRKME | Sales unit | VRKME | MEINS |
| ISDFKIMG | Actual billed quantity | FKIMG | MENG13 |
| ISDVRKME | Sales unit | VRKME | MEINS |
| .INCLUDE | Common structure for total tables (export sales) | ||
| MATNR | Material Number | MATNR | MATNR |
| MAKTX | Material description | MAKTX | TEXT40 |
| CYCLE_DAY | Days from Contract to Payment | J_3RS_CYCLE_DAY | J_3RS_DAY |
| TOTAL_DAY | Days Since Contract | J_3RS_TOTAL_DAY | J_3RS_DAY |
| CONFIRM_DATE | Confirmation Date | J_3RS_CONFIRM_DATE | DATUM |
| CONFIRM_DAY | Days from Contract to Confirmation | J_3RS_CONFIRM_DAY | J_3RS_DAY |
| SECEVT_DATE | Secondary Event Date | J_3RS_SECEVENT_DATE | DATS |
| GTDSEC_DAY | Days from Customs Declaration to Secondary Event | J_3RS_GTD_TO_SECEVENT | J_3RS_DAY |
| GTDPAY_DAY | Days from Customs Declaration to Payment | J_3RS_GTD_TO_PAYMENT | J_3RS_DAY |
| GTDCONF_DAY | Days from Customs Declaration to Confirmation | J_3RS_GTD_TO_CONFIRM | J_3RS_DAY |
| TAXTR_DOC | Tax Transfer Document Number | J_3RS_TAX_DOC | BELNR |
| KUNNR | Customer Number | KUNNR | KUNNR |
| CONF_AMT | Qualifying Amount | J_3RS_CONFIRMED_AMOUNT | WERT7 |
| UNCONF_AMT | Nonqualifying Amount | J_3RS_UNCONFIRMED_AMOUNT | WERT7 |
| CONF_QTY | Qualifying Quantity | J_3RS_CONFIRMED_QUANTITY | MENG13 |
| UNCONF_QTY | Quantity Not Qualifying | J_3RS_UNCONFIRMED_QUANTITY | MENG13 |
| WRBTR_G2 | Amount in document currency | WRBTR | WERT7 |
| ZMENG_G2 | Contract amount | J_3RSMENGE | MENG13 |
| .INCLUDE | Curgo customs declaration | ||
| BEHOE_P1 | Code of Registering Customs Office | J_3RS_BEHOE | BEHOE |
| DATE_P2 | Customs Declaration Registration Date | J_3RS_DATE | DATUM |
| EXTN_P3 | Customs Declaration External Document Number | J_3RS_EXTNUM | J_3RS_CCD_NUM |
| CRBDR | Cross Border Date | J_3RS_CRBRDER | DATUM |
| EXPORT_ALLOWED | Export Approval Date | J_3RS_EXPAL | DATUM |
| CORR_CCD | Customs Declaration Document Number | J_3RS_CCD_BELN | J_3RS_CCD_BELN |
| CORR_BEHOE_P1 | Code of Registering Customs Office | J_3RS_BEHOE | BEHOE |
| CORR_DATE_P2 | Customs Declaration Registration Date | J_3RS_DATE | DATUM |
| CORR_EXTN_P3 | Customs Declaration External Document Number | J_3RS_EXTNUM | J_3RS_CCD_NUM |
| CORR_CRBDR | Cross Border Date | J_3RS_CRBRDER | DATUM |
| CORR_ITEM | Customs Declaration Item Number | J_3RS_CCDITEMID | J_3RS_CCD_ID |
| CORR_EXP_ALLOW | Export Approval Date | J_3RS_EXPAL | DATUM |
J_3RSEXTRACTD related tables
| Table | Note |
|---|---|
| J_3RSEXTRACTD | Exctract details (obsolete) |
| J_3RBUE_BK_TXT | Text POOL for EXCTRACT |
| TFREP | Reports with Form Details and Sender Details |
| ESH_CO_QLOGQ | OBSOLETE: Search Request Log - Query Details |
| /MRSS/C_DEM_GRP | OBSOLETE DB Table - Demand Group and PM Activity Details |
| ACMACAVIEWDETAIL | ACM: Access-Condition Authorization-View Details |
| ACMASPPFCGDETAIL | ACM: Details for PFCG_AUTH-Aspects |
| ACMTSTASPPFCGDET | ACMTST: PFCG_AUTH-Aspect-Details (Expected results) |
| ACTCMBDET_TAB | Table for status combination details |
| AD01WIP_DTL | WIP Details |
| AD01WIP_REV | WIP Details |
| ADFSH_FLGTDET | Flight Scheduling: Flight Schedule Details |
| AGS_BPCA_ISECT | BPCA: Result Item Details |
| AGS_TBOM_AT_BT | Business Transaction Details for a testcase |
| AIDEPCDTL | Obsolite: EPC Details |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP