J_3RSEXTRACTD - Exctract details (obsolete)
Exctract details (obsolete) information is stored in SAP table J_3RSEXTRACTD.
It is part of development package J3RS in software component FI-LOC-SD-RU. This development package consists of objects that can be grouped under "Localization Russia: SD".
It is part of development package J3RS in software component FI-LOC-SD-RU. This development package consists of objects that can be grouped under "Localization Russia: SD".
Fields for table J_3RSEXTRACTD
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| ENAME | Extract Name | X | J_3RS_EXTRACT | CHAR | 20 | |
| EPOS | Numeric field: Length 6 | X | NUM06 | NUMC | 12 | |
| .INCLUDE | J_3RSTOTALTABLE | 0 | ||||
| CONTRACT | Contract Number | J_3RSCBELNR | CHAR | 20 | ||
| CBUZEI | Sales Document Item | POSNR_VA | NUMC | 12 | ||
| CDATE | Contract date | J_3RS_CDATE | DATS | 16 | ||
| BORDER | Order number | J_3RSOBELNR | CHAR | 20 | ||
| OBUZEI | Sales Document Item | POSNR_VA | NUMC | 12 | ||
| ODATE | Order date | J_3RS_ODATE | DATS | 16 | ||
| DELIVERY | Delivery number | J_3RSDBELNR | CHAR | 20 | ||
| DBUZEI | Delivery Item | POSNR_VL | NUMC | 12 | ||
| DDATE | Delivery date | J_3RS_DDATE | DATS | 16 | ||
| PGTD | Preliminary cargo customs declaration number | J_3RSPGBELNR | CHAR | 20 | ||
| PGBUZEI | Billing Item | POSNR_VF | NUMC | 12 | ||
| PGDATE | Preliminary cargo customs declaration date | J_3RS_PGDATE | DATS | 16 | ||
| GTD | Cargo customs declaration number | J_3RSGBELNR | CHAR | 20 | ||
| GBUZEI | Billing Item | POSNR_VF | NUMC | 12 | ||
| GDATE | Cargo customs declaration date | J_3RS_GDATE | DATS | 16 | ||
| INVOICE_SD | Invoice number (SD) | J_3RSIBELNR_SD | CHAR | 20 | ||
| IBUZEI_SD | Billing Item | POSNR_VF | NUMC | 12 | ||
| IDATE_SD | Invoice date | J_3RS_IDATE | DATS | 16 | ||
| INVOICE_FI | Invoice Document Number in Financial Accounting | J_3RSIBELNR_FI | CHAR | 20 | ||
| IBUZEI_FI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 6 | ||
| IDATE_FI | Invoice date | J_3RS_IDATE | DATS | 16 | ||
| PAYMENT | Payment number | J_3RSPBELNR | CHAR | 20 | ||
| PBUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 6 | ||
| PDATE | Payment date | J_3RS_PDATE | DATS | 16 | ||
| CWRBTR | Amount in Document Currency | WRBTR_CS | CURR | 7 | ||
| CWAERS | Currency Key | WAERS | CUKY | 10 | * | |
| OWRBTR | Amount in Document Currency | WRBTR_CS | CURR | 7 | ||
| OWAERS | Currency Key | WAERS | CUKY | 10 | * | |
| DWRBTR | Amount in Document Currency | WRBTR_CS | CURR | 7 | ||
| DWAERS | Currency Key | WAERS | CUKY | 10 | * | |
| GWRBTR | Amount in Document Currency | WRBTR_CS | CURR | 7 | ||
| GWAERS | Currency Key | WAERS | CUKY | 10 | * | |
| PGWRBTR | Amount in Document Currency | WRBTR_CS | CURR | 7 | ||
| PGWAERS | Currency Key | WAERS | CUKY | 10 | * | |
| ISDWRBTR | Amount in Document Currency | WRBTR_CS | CURR | 7 | ||
| ISDWAERS | Currency Key | WAERS | CUKY | 10 | * | |
| IFIWRBTR | Amount in Document Currency | WRBTR_CS | CURR | 7 | ||
| IFIWAERS | Currency Key | WAERS | CUKY | 10 | * | |
| PWRBTR | Amount in Document Currency | WRBTR_CS | CURR | 7 | ||
| PWAERS | Currency Key | WAERS | CUKY | 10 | * | |
| CZMENG | Contract amount | J_3RSMENGE | QUAN | 7 | ||
| CZIEME | Unit of measure | J_3RSMEINS | UNIT | 6 | * | |
| OZMENG | Contract amount | J_3RSMENGE | QUAN | 7 | ||
| OZIEME | Unit of measure | J_3RSMEINS | 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 | * | |
| .INCLUDE | J_3RSTOTALTABLE_COMMON | 0 | ||||
| MATNR | Material Number | MATNR | CHAR | 80 | ||
| MAKTX | Material Description | MAKTX | CHAR | 80 | ||
| CYCLE_DAY | Days from Contract to Payment | J_3RS_CYCLE_DAY | NUMC | 10 | ||
| TOTAL_DAY | Days Since Contract | J_3RS_TOTAL_DAY | NUMC | 10 | ||
| CONFIRM_DATE | Confirmation Date | J_3RS_CONFIRM_DATE | DATS | 16 | ||
| CONFIRM_DAY | Days from Contract to Confirmation | J_3RS_CONFIRM_DAY | NUMC | 10 | ||
| SECEVT_DATE | Secondary Event Date | J_3RS_SECEVENT_DATE | DATS | 16 | ||
| GTDSEC_DAY | Days from Customs Declaration to Secondary Event | J_3RS_GTD_TO_SECEVENT | NUMC | 10 | ||
| GTDPAY_DAY | Days from Customs Declaration to Payment | J_3RS_GTD_TO_PAYMENT | NUMC | 10 | ||
| GTDCONF_DAY | Days from Customs Declaration to Confirmation | J_3RS_GTD_TO_CONFIRM | NUMC | 10 | ||
| TAXTR_DOC | Tax Transfer Document Number | J_3RS_TAX_DOC | CHAR | 20 | ||
| KUNNR | Customer Number | KUNNR | CHAR | 20 | ||
| KUNNR_DPP_BL | Single-Character Flag | CHAR1 | CHAR | 2 | ||
| CONF_AMT | Qualifying Amount | J_3RS_CONFIRMED_AMOUNT | CURR | 7 | ||
| UNCONF_AMT | Nonqualifying Amount | J_3RS_UNCONFIRMED_AMOUNT | CURR | 7 | ||
| CONF_QTY | Qualifying Quantity | J_3RS_CONFIRMED_QUANTITY | QUAN | 7 | ||
| UNCONF_QTY | Quantity Not Qualifying | J_3RS_UNCONFIRMED_QUANTITY | QUAN | 7 | ||
| WRBTR_G2 | Amount in Document Currency | WRBTR_CS | CURR | 7 | ||
| .INCLUDE | J_3RSTOTALTABLE_GTD | 0 | ||||
| BEHOE_P1 | Code of Registering Customs Office | J_3RS_BEHOE | CHAR | 20 | ||
| DATE_P2 | Customs Declaration Registration Date | J_3RS_DATE | DATS | 16 | ||
| EXTN_P3 | Customs Declaration External Document Number | J_3RS_EXTNUM | CHAR | 20 | ||
| CRBDR | Cross Border Date | J_3RS_CRBRDER | DATS | 16 | ||
| EXPORT_ALLOWED | Export Approval Date | J_3RS_EXPAL | DATS | 16 | ||
| CORR_CCD | Customs Declaration Document Number | J_3RS_CCD_BELN | CHAR | 20 | ||
| CORR_BEHOE_P1 | Code of Registering Customs Office | J_3RS_BEHOE | CHAR | 20 | ||
| CORR_DATE_P2 | Customs Declaration Registration Date | J_3RS_DATE | DATS | 16 | ||
| CORR_EXTN_P3 | Customs Declaration External Document Number | J_3RS_EXTNUM | CHAR | 20 | ||
| CORR_CRBDR | Cross Border Date | J_3RS_CRBRDER | DATS | 16 | ||
| CORR_ITEM | Customs Declaration Item Number | J_3RS_CCDITEMID | NUMC | 6 | ||
| CORR_EXP_ALLOW | Export Approval Date | J_3RS_EXPAL | DATS | 16 |