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 |