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".

Fields for table J_3RSEXTRACTD

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
ENAMEExtract NameXJ_3RS_EXTRACTCHAR20
EPOSNumeric field: Length 6XNUM06NUMC12
.INCLUDEJ_3RSTOTALTABLE0
CONTRACTContract NumberJ_3RSCBELNRCHAR20
CBUZEISales Document ItemPOSNR_VANUMC12
CDATEContract dateJ_3RS_CDATEDATS16
BORDEROrder numberJ_3RSOBELNRCHAR20
OBUZEISales Document ItemPOSNR_VANUMC12
ODATEOrder dateJ_3RS_ODATEDATS16
DELIVERYDelivery numberJ_3RSDBELNRCHAR20
DBUZEIDelivery ItemPOSNR_VLNUMC12
DDATEDelivery dateJ_3RS_DDATEDATS16
PGTDPreliminary cargo customs declaration numberJ_3RSPGBELNRCHAR20
PGBUZEIBilling ItemPOSNR_VFNUMC12
PGDATEPreliminary cargo customs declaration dateJ_3RS_PGDATEDATS16
GTDCargo customs declaration numberJ_3RSGBELNRCHAR20
GBUZEIBilling ItemPOSNR_VFNUMC12
GDATECargo customs declaration dateJ_3RS_GDATEDATS16
INVOICE_SDInvoice number (SD)J_3RSIBELNR_SDCHAR20
IBUZEI_SDBilling ItemPOSNR_VFNUMC12
IDATE_SDInvoice dateJ_3RS_IDATEDATS16
INVOICE_FIInvoice Document Number in Financial AccountingJ_3RSIBELNR_FICHAR20
IBUZEI_FINumber of Line Item Within Accounting DocumentBUZEINUMC6
IDATE_FIInvoice dateJ_3RS_IDATEDATS16
PAYMENTPayment numberJ_3RSPBELNRCHAR20
PBUZEINumber of Line Item Within Accounting DocumentBUZEINUMC6
PDATEPayment dateJ_3RS_PDATEDATS16
CWRBTRAmount in Document CurrencyWRBTR_CSCURR7
CWAERSCurrency KeyWAERSCUKY10*
OWRBTRAmount in Document CurrencyWRBTR_CSCURR7
OWAERSCurrency KeyWAERSCUKY10*
DWRBTRAmount in Document CurrencyWRBTR_CSCURR7
DWAERSCurrency KeyWAERSCUKY10*
GWRBTRAmount in Document CurrencyWRBTR_CSCURR7
GWAERSCurrency KeyWAERSCUKY10*
PGWRBTRAmount in Document CurrencyWRBTR_CSCURR7
PGWAERSCurrency KeyWAERSCUKY10*
ISDWRBTRAmount in Document CurrencyWRBTR_CSCURR7
ISDWAERSCurrency KeyWAERSCUKY10*
IFIWRBTRAmount in Document CurrencyWRBTR_CSCURR7
IFIWAERSCurrency KeyWAERSCUKY10*
PWRBTRAmount in Document CurrencyWRBTR_CSCURR7
PWAERSCurrency KeyWAERSCUKY10*
CZMENGContract amountJ_3RSMENGEQUAN7
CZIEMEUnit of measureJ_3RSMEINSUNIT6*
OZMENGContract amountJ_3RSMENGEQUAN7
OZIEMEUnit of measureJ_3RSMEINSUNIT6*
DLFIMGActual quantity delivered (in sales units)LFIMGQUAN7
DVRKMESales unitVRKMEUNIT6*
GFKIMGActual billed quantityFKIMGQUAN7
GVRKMESales unitVRKMEUNIT6*
PGFKIMGActual billed quantityFKIMGQUAN7
PGVRKMESales unitVRKMEUNIT6*
ISDFKIMGActual billed quantityFKIMGQUAN7
ISDVRKMESales unitVRKMEUNIT6*
.INCLUDEJ_3RSTOTALTABLE_COMMON0
MATNRMaterial NumberMATNRCHAR80
MAKTXMaterial DescriptionMAKTXCHAR80
CYCLE_DAYDays from Contract to PaymentJ_3RS_CYCLE_DAYNUMC10
TOTAL_DAYDays Since ContractJ_3RS_TOTAL_DAYNUMC10
CONFIRM_DATEConfirmation DateJ_3RS_CONFIRM_DATEDATS16
CONFIRM_DAYDays from Contract to ConfirmationJ_3RS_CONFIRM_DAYNUMC10
SECEVT_DATESecondary Event DateJ_3RS_SECEVENT_DATEDATS16
GTDSEC_DAYDays from Customs Declaration to Secondary EventJ_3RS_GTD_TO_SECEVENTNUMC10
GTDPAY_DAYDays from Customs Declaration to PaymentJ_3RS_GTD_TO_PAYMENTNUMC10
GTDCONF_DAYDays from Customs Declaration to ConfirmationJ_3RS_GTD_TO_CONFIRMNUMC10
TAXTR_DOCTax Transfer Document NumberJ_3RS_TAX_DOCCHAR20
KUNNRCustomer NumberKUNNRCHAR20
KUNNR_DPP_BLSingle-Character FlagCHAR1CHAR2
CONF_AMTQualifying AmountJ_3RS_CONFIRMED_AMOUNTCURR7
UNCONF_AMTNonqualifying AmountJ_3RS_UNCONFIRMED_AMOUNTCURR7
CONF_QTYQualifying QuantityJ_3RS_CONFIRMED_QUANTITYQUAN7
UNCONF_QTYQuantity Not QualifyingJ_3RS_UNCONFIRMED_QUANTITYQUAN7
WRBTR_G2Amount in Document CurrencyWRBTR_CSCURR7
.INCLUDEJ_3RSTOTALTABLE_GTD0
BEHOE_P1Code of Registering Customs OfficeJ_3RS_BEHOECHAR20
DATE_P2Customs Declaration Registration DateJ_3RS_DATEDATS16
EXTN_P3Customs Declaration External Document NumberJ_3RS_EXTNUMCHAR20
CRBDRCross Border DateJ_3RS_CRBRDERDATS16
EXPORT_ALLOWEDExport Approval DateJ_3RS_EXPALDATS16
CORR_CCDCustoms Declaration Document NumberJ_3RS_CCD_BELNCHAR20
CORR_BEHOE_P1Code of Registering Customs OfficeJ_3RS_BEHOECHAR20
CORR_DATE_P2Customs Declaration Registration DateJ_3RS_DATEDATS16
CORR_EXTN_P3Customs Declaration External Document NumberJ_3RS_EXTNUMCHAR20
CORR_CRBDRCross Border DateJ_3RS_CRBRDERDATS16
CORR_ITEMCustoms Declaration Item NumberJ_3RS_CCDITEMIDNUMC6
CORR_EXP_ALLOWExport Approval DateJ_3RS_EXPALDATS16
Privacy Policy