2018年10月30日 星期二

ATP SAP標準檔案 RESB 保留量存放

RESB is a standard SAP Table which is used to store Reservation/dependent requirements information. 
This is available within R/3 SAP systems depending on the version and release level. 

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about Table RESB and the data within it using relevant SAP transactions such as SE11SE80 or SE16. Also check out the Contribute section below to view or add related contributions and example screen shots. 

Delivery Class: A - Application table containing master and transaction data 

Display/Maintenance via SM30: Yes but with Restrictions 

Enhancement category i: Can be enhanced (character-type or numeric) 
See here for more information about this and other SAP enhancement categories 


FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3T000Client
RSNUMRSNUMNUMC10Number of Reservation/Dependent Requirement
RSPOSRSPOSNUMC4Item Number of Reservation/Dependent Requirement
RSARTRSARTCHAR1Record type
BDARTBDARTCHAR2Requirement type
RSSTARSSTACHAR1Status of reservation
XLOEKXLOEKCHAR1Item is Deleted
XWAOKXWAOKCHAR1Goods Movement for Reservation Allowed
KZEARKZEARCHAR1Final Issue for This Reservation
XFEHLXFEHLCHAR1Missing Part
MATNRMATNRCHAR18MARAMaterial NumberMATN1
WERKSWERKS_DCHAR4T001WPlant
LGORTLGORT_DCHAR4T001LStorage Location
PRVBEPRVBECHAR10
*
Production Supply Area
CHARGCHARG_DCHAR10MCHABatch Number
PLPLAPLPLACHAR10Distribution of Differences
SOBKZSOBKZCHAR1T148Special Stock Indicator
BDTERBDTERDATS8Requirement Date for the Component
BDMNGBDMNGQUAN13(3)Requirement Quantity
MEINSMEINSUNIT3T006Base Unit of MeasureCUNIT
SHKZGSHKZGCHAR1Debit/Credit Indicator
FMENGFMENGCHAR1Quantity is Fixed
ENMNGENMNGQUAN13(3)Quantity Withdrawn
ENWRTENWRTCURR13(2)Value Withdrawn
WAERSWAERSCUKY5TCURCCurrency Key
ERFMGERFMGQUAN13(3)Quantity in Unit of Entry
ERFMEERFMEUNIT3T006Unit of EntryCUNIT
PLNUMPLNUMCHAR10PLAFPlanned order numberALPHA
BANFNBANFNCHAR10Purchase Requisition NumberALPHA
BNFPOBNFPONUMC5EBANItem Number of Purchase Requisition
AUFNRAUFNRCHAR12AUFKOrder NumberALPHA
BAUGRBAUGRCHAR18MARAMaterial number of higher-level assemblyMATN1
SERNRSERNRCHAR8SNUMBOM explosion number
KDAUFKDAUFCHAR10VBUKSales Order NumberALPHA
KDPOSKDPOSNUMC6Item Number in Sales Order
KDEINKDEINNUMC4Delivery Schedule for Sales Order
PROJNPROJNCHAR16Old: Project number : No longer used --> PS_POSNR
BWARTBWARTCHAR3T156Movement Type (Inventory Management)
SAKNRSAKNRCHAR10
*
G/L Account NumberALPHA
GSBERGSBERCHAR4TGSBBusiness Area

UMWRKUMWRKCHAR4T001WReceiving/Issuing Plant
UMLGOUMLGOCHAR4T001LReceiving/Issuing Storage Location
NAFKZNAFKZCHAR1Indicator: follow-up material active/not active
NOMATNOMATCHAR18MARAFollow-Up/Original MaterialMATN1
NOMNGNOMNGQUAN13(3)Required quantity
POSTPPOSTPCHAR1T418Item Category (Bill of Material)
POSNRAPOSNCHAR4BOM item numberNUMCV
ROMS1ROMS1QUAN13(3)Size 1
ROMS2ROMS2QUAN13(3)Size 2
ROMS3ROMS3QUAN13(3)Size 3
ROMEIROMEIUNIT3T006Unit of measure for sizes 1 to 3CUNIT
ROMENROMENQUAN13(3)Quantity of variable-size item
SGTXTSGTXTCHAR50Item Text
LMENGLMENGQUAN13(3)Required quantity for mat.management in stockkeeping units
ROHPSROHPSCHAR1Variable-sized item indicator
RFORMRFORMCHAR2T418FFormula key
ROANZROANZQUAN13(3)Number of variable-size items
FLMNGFLMNGQUAN13(3)Shortfall quantity of the component in the order
STLTYSTLTYCHAR1BOM category
STLNRSTNUMCHAR8Bill of materialNUMCV
STLKNSTLKNNUMC8BOM item node number
STPOZCIM_COUNTNUMC8Internal counter
LTXSPLTXSPLANG1T002Language: The long text was stored in this languageISOLA
POTX1POTX1CHAR40BOM Item Text (Line 1)
POTX2POTX2CHAR40BOM item text (line 2)
SANKACK_SELKZCHAR1TCK08Indicator for Relevancy to Costing
ALPOSALTPSCHAR1Alternative item indicator
EWAHREWAHRDEC3Usage probability in % (alternative item)
AUSCHKAUSFDEC5(2)Component scrap in percent
AVOAUAVOAUDEC5(2)Operation scrap
NETAUNETAUCHAR1Indicator: Net scrap
NLFZTNLFZTDEC3Lead-time offset
AENNRAENNRCHAR12AENRChange NumberAENNR
UMREZUMREZDEC5Numerator for Conversion to Base Units of Measure
UMRENUMRENDEC5Denominator for conversion to base units of measure
SORTFSORTPCHAR10Sort String
SBTERSBTERDATS8Latest requirements date
VERTISA_VERTLCHAR4T437VMRP Distribution Key
SCHGTSCHGTCHAR1Indicator: Bulk Material
UPSKZUPSKZCHAR1Indicator: sub-items exist

DBSKZDBSKZCHAR1Direct procurement indicator
TXTPSTXTPSCHAR1Item text indicator
DUMPSDUMPSCHAR1Phantom item indicator
BEIKZBEIKZCHAR1T417Material Provision Indicator
ERSKZERSKZCHAR1T413Indicator: spare part
AUFSTAUFSTNUMC2Order level
AUFWGAUFWGNUMC2Order path
BAUSTBAUSTNUMC2Assembly order level
BAUWGBAUWGNUMC2Assembly order path
AUFPSAUFPSCHAR2Order item number
EBELNEBELNCHAR10EKKOPurchasing Document NumberALPHA
EBELPEBELPNUMC5EKPOItem Number of Purchasing Document
EBELEEETENNUMC4EKETDelivery Schedule Line Counter
KNTTPKNTTPCHAR1T163KAccount Assignment Category
KZVBRKZVBRCHAR1Consumption Posting
PSPELPS_POSNRNUMC8
*
WBS ElementABPSP
AUFPLCO_AUFPLNUMC10Routing number of operations in the order
PLNFLPLNFOLGECHAR6SequenceALPHA
VORNRVORNRCHAR4Operation/Activity NumberNUMCV
APLZLCIM_COUNTNUMC8Internal counter
OBJNRJ_OBJNRCHAR22ONR00Object number
FLGATFOLGENARTCHAR1TCA07Sequence category
GPREISPPCOMPCURR15(2)Price in component currency
FPREISOPREIFXCURR15(2)Fixed Price in Foreign Currency
PEINHPEINHDEC5Price Unit
RGEKZRGEKZCHAR1Indicator: Backflush
EKGRPEKGRPCHAR3T024Purchasing Group
ROKMEROKMEUNIT3T006Unit of measure for variable-size componentCUNIT
ZUMEIDZUMEIUNIT3T006Unit for cutting measuresCUNIT
ZUMS1DZUMS1QUAN13(3)Cutting measure 1
ZUMS2DZUMS2QUAN13(3)Cutting measure 2
ZUMS3DZUMS3QUAN13(3)Cutting measure 3
ZUDIVDZUDIVNUMC5Integral divisor for cutting measures
VMENGVMENGQUAN15(3)Confirmed quantity for availability check in SKU
PRREGPRREGCHAR2T441RChecking Rule for Availability Check
LIFZTLIFZTDEC3Delivery time in days
CUOBJCUOBJNUMC18Configuration (internal object number)
KFPOSKFPOSCHAR1Indicator: "configurable item"
REVLVREVLVCHAR2Revision LevelNUMCV
BERKZBERKZCHAR1Material Staging Indicator for Production Supply
LGNUMLGNUMCHAR3T300Warehouse Number / Warehouse Complex
LGTYPLGTYPCHAR3T301Storage Type
LGPLALGPLACHAR10LAGPStorage Bin
TBMNGTBMNGQUAN13(3)Transfer requirement quantity already requested
NPTXTKYTXTKYCHAR12Internal text number (12-character)
KBNKZKBNKZCHAR1Kanban Indicator
KZKUPKZKUPCHAR1Indicator: co-product
AFPOSCO_POSNRNUMC4Order Item Number
NO_DISPNO_DISP_PLUSCHAR1Effective for Materials Planning
BDZTPBDZTPTIMS6Time that reservation quantity required
ESMNGESMNGFLTP16(16)Usage quantity per order unit of measure
ALPGRCS_ALPGRCHAR2Alternative item: group
ALPRFCS_ALPRFNUMC2Alternative item: ranking order
ALPSTCS_ALPSTCHAR1Alternative item: strategy
KZAUSAUSLFCHAR1Discontinuation type
NFEAGCS_NFEAGCHAR2Discontinuation group
NFPKZCS_KZNFPCHAR1Indicator: Follow-Up Item
NFGRPCS_NFGRPCHAR2Follow-up group
NFUMLNFUMLDEC5(4)NOT USED: Quantity transfer factor for follow-up material
ADRNRCADNRCHAR10
*
Addresses: Address NumberALPHA
CHOBJCUOBJ_CHNUMC18Internal object number of the batch classification
SPLKZCHSPLITCHAR1Batch key
SPLRVRSPOSNUMC4Item Number of Reservation/Dependent Requirement
KNUMHKNUMH_CHCHAR10Number of condition record from batch determination
WEMPFWEMPFCHAR12Goods Recipient/Ship-To Party
ABLADABLADCHAR25Unloading Point
HKMATHKMATCHAR1Material-related origin
HRKFTHRKFTCHAR4
*
Origin Group as Subdivision of Cost Element
VORABVORABKZCHAR1Ind: Preliminary order
MATKLMATKLCHAR9T023Material Group
FRUNVFRUNVCHAR1Indicator: External procurement data incomplete
CLAKZCLAKZCHAR1Indicator: classification exists
INPOSINPOSCHAR1Indicator: intra material
WEBAZWEBAZDEC3Goods Receipt Processing Time in Days
LIFNRLIFNRCHAR10LFA1Account Number of Vendor or CreditorALPHA
FLGEXFLGEXCHAR1Indicator: External procurement
FUNCTCY_FUNCTCHAR3TC29VDistribution function
GPREIS_2PPGXXXCURR15(2)Total Price in Local Currency
FPREIS_2PPFXXXCURR15(2)Fixed Price in Local Currency
PEINH_2PEINHDEC5Price Unit
INFNRINFNRCHAR10EINANumber of Purchasing Info RecordALPHA
KZECHKZECHCHAR1Determination of batch entry in the production/process order
KZMPFKZMPFCHAR1Manual Maintenance of Requirement Date
STLALSTALTCHAR2Alternative BOMALPHA
PBDNRPBDNRCHAR10Requirements Plan Number
STVKNSTVKNNUMC8Inherited node number of BOM item
KTOMAKTOMACHAR1Acct entered manually
VRPLAVRPLACHAR1Indicator: planning without final assembly
KZBWSKZBWSCHAR1Valuation of Special Stock
NLFZVCS_NLFZVDEC3Lead-time offset for operation
NLFMVCS_NLFMVUNIT3T006Unit for lead-time offset for operationCUNIT
TECHSTECHSCHAR12Parameter Variant/Standard Variant
OBJTYPEOCM_OBJ_TYPECHAR1Change indicator
CH_PROCOCM_CH_PROCCHAR1Process that has lead to the change of an object
FXPRUCK_FIXPRKUCHAR1Fixed-Price Co-Product
UMSOKUMSOKCHAR1
*
Special Stock Indicator for Physical Stock Transfer
VORAB_SMVORAB_SMCHAR1Advance Shipment Indicator
FIPOSFIPOSCHAR14
*
Commitment ItemFMCIS
FIPEXFM_FIPEXCHAR24
*
Commitment ItemFMCIL
FISTLFISTLCHAR16
*
Funds Center
GEBERBP_GEBERCHAR10
*
Fund
GRANT_NBRGM_GRANT_NBRCHAR20GrantALPHA
FKBERFKBERCHAR16
*
Functional Area
PRIO_URGPRIO_URGNUMC2PURGRequirement Urgency
PRIO_REQPRIO_REQNUMC3PREQRequirement Priority
KBLNRKBLNRCHAR10
*
Document Number for Earmarked FundsALPHA
KBLPOSKBLPOSNUMC3
*
Earmarked Funds: Document Item
BUDGET_PDFM_BUDGET_PERIODCHAR10
*
FM: Budget Period
SC_OBJECT_ID/SRMERP/OBJECT_IDCHAR10Object ID - Document Number
SC_ITM_NO/SRMERP/SC_ITM_NOINT410Internal Shopping Cart Item Number
ADVCODE/ISDFPS/ADVCODECHAR2/ISDFPS/ADVCODE1Advice Code
.APPENDADMPN_RBA_RESBAppend to RESB for Interchangeability
.INCLUDEADMPN_RBA_STRUC_NODEexternal structure node for rules-based ATP
STRUC_CODEADMPN_RBA_STRUC_CODECHAR40Structure Node for APO ATP Check
STRUC_CLASSKLASSE_DCHAR18Class number
STRUC_CLASSTYPKLASSENARTCHAR3
*
Class Type
.APPENDMILL_MMEnhancement for IBU MPW
MILL_UCDETMILL_UCDETCHAR1Batch Determination for Original Batches
.APPENDWTYSC_RESB_AS## RESB #
.INCLUDEWTYSC_S_WTY_INDICATORWarranty Indicator
WTY_INDWTYSC_WTY_INDICATORCHAR1Warranty indicator
.INCLUDEWTYSC_S_RETURN_PART_INDICATORReturn Part Indicator
R_PART_INDICATORWTYSC_RETURN_PART_INDICATORCHAR1Return Part Indicator
.INCLUDEWTYSC_S_CLMITEMClaim Item Data
WTYSC_CLMITEMWTYSC_CLMITEMCHAR16Claim item number


Key field
Non-key field

用SQL 從後端資料庫讀出定義檔

TABNAME,FIELDNAME,POSITION,INTTYPE,INTLEN,DATATYPE,LENG,DECIMALS,DOMNAME,DDLANGUAGE,DDTEXT,ROLLNAME,DDTEXT_1

RESB,MANDT,1,C,6,CLNT,3,0,MANDT,,,MANDT,Client

RESB,RSNUM,2,N,20,NUMC,10,0,RSNUM,,,RSNUM,Number of Reservation/Dependent Requirement
RESB,RSPOS,3,N,8,NUMC,4,0,RSPOS,,,RSPOS,Item Number of Reservation/Dependent Requirement
RESB,RSART,4,C,2,CHAR,1,0,RSART,,,RSART,Record type
RESB,BDART,5,C,4,CHAR,2,0,BDART,,,BDART,Requirement type
RESB,RSSTA,6,C,2,CHAR,1,0,STATR,,,RSSTA,Status of reservation
RESB,XLOEK,7,C,2,CHAR,1,0,XFELD,,,XLOEK,Item is Deleted
RESB,XWAOK,8,C,2,CHAR,1,0,XFELD,,,XWAOK,Goods Movement for Reservation Allowed
RESB,KZEAR,9,C,2,CHAR,1,0,XFELD,,,KZEAR,Final Issue for This Reservation
RESB,XFEHL,10,C,2,CHAR,1,0,XFELD,,,XFEHL,Missing Part
RESB,MATNR,11,C,36,CHAR,18,0,MATNR,,,MATNR,Material Number
RESB,WERKS,12,C,8,CHAR,4,0,WERKS,,,WERKS_D,Plant
RESB,LGORT,13,C,8,CHAR,4,0,LGORT,,,LGORT_D,Storage Location
RESB,PRVBE,14,C,20,CHAR,10,0,PRVBE,,,PRVBE,Production Supply Area
RESB,CHARG,15,C,20,CHAR,10,0,CHARG,,,CHARG_D,Batch Number
RESB,PLPLA,16,C,20,CHAR,10,0,PLPLA,,,PLPLA,Distribution of Differences
RESB,SOBKZ,17,C,2,CHAR,1,0,SOBKZ,,,SOBKZ,Special Stock Indicator
RESB,BDTER,18,D,16,DATS,8,0,DATUM,,,BDTER,Requirement Date for the Component
RESB,BDMNG,19,P,7,QUAN,13,3,MENG13,,,BDMNG,Requirement Quantity
RESB,MEINS,20,C,6,UNIT,3,0,MEINS,,,MEINS,Base Unit of Measure
RESB,SHKZG,21,C,2,CHAR,1,0,SHKZG,,,SHKZG,Debit/Credit Indicator
RESB,FMENG,22,C,2,CHAR,1,0,XFELD,,,FMENG,Quantity is Fixed
RESB,ENMNG,23,P,7,QUAN,13,3,MENG13,,,ENMNG,Quantity Withdrawn
RESB,ENWRT,24,P,7,CURR,13,2,VWERT13,,,ENWRT,Value Withdrawn
RESB,WAERS,25,C,10,CUKY,5,0,WAERS,,,WAERS,Currency Key
RESB,ERFMG,26,P,7,QUAN,13,3,MENG13,,,ERFMG,Quantity in Unit of Entry
RESB,ERFME,27,C,6,UNIT,3,0,MEINS,,,ERFME,Unit of Entry
RESB,PLNUM,28,C,20,CHAR,10,0,PLNUM,,,PLNUM,Planned order number
RESB,BANFN,29,C,20,CHAR,10,0,BANFN,,,BANFN,Purchase Requisition Number
RESB,BNFPO,30,N,10,NUMC,5,0,BNFPO,,,BNFPO,Item Number of Purchase Requisition
RESB,AUFNR,31,C,24,CHAR,12,0,AUFNR,,,AUFNR,Order Number
RESB,BAUGR,32,C,36,CHAR,18,0,MATNR,,,BAUGR,Material number of higher-level assembly
RESB,SERNR,33,C,16,CHAR,8,0,SERNR,,,SERNR,BOM explosion number
RESB,KDAUF,34,C,20,CHAR,10,0,VBELN,,,KDAUF,Sales Order Number
RESB,KDPOS,35,N,12,NUMC,6,0,NUM06,,,KDPOS,Item Number in Sales Order
RESB,KDEIN,36,N,8,NUMC,4,0,NUM04,,,KDEIN,Delivery Schedule for Sales Order
RESB,PROJN,37,C,32,CHAR,16,0,PROJN,,,PROJN,Old: Project number : No longer used --> PS_POSNR
RESB,BWART,38,C,6,CHAR,3,0,BWART,,,BWART,Movement Type (Inventory Management)
RESB,SAKNR,39,C,20,CHAR,10,0,SAKNR,,,SAKNR,G/L Account Number
RESB,GSBER,40,C,8,CHAR,4,0,GSBER,,,GSBER,Business Area
RESB,UMWRK,41,C,8,CHAR,4,0,WERKS,,,UMWRK,Receiving/Issuing Plant
RESB,UMLGO,42,C,8,CHAR,4,0,LGORT,,,UMLGO,Receiving/Issuing Storage Location
RESB,NAFKZ,43,C,2,CHAR,1,0,XFELD,,,NAFKZ,Indicator: follow-up material active/not active
RESB,NOMAT,44,C,36,CHAR,18,0,MATNR,,,NOMAT,Follow-up/original material
RESB,NOMNG,45,P,7,QUAN,13,3,MENG13,,,NOMNG,Required quantity
RESB,POSTP,46,C,2,CHAR,1,0,POSTP,,,POSTP,Item Category (Bill of Material)
RESB,POSNR,47,C,8,CHAR,4,0,SPOSN,,,APOSN,BOM item number
RESB,ROMS1,48,P,7,QUAN,13,3,MENG13,,,ROMS1,Size 1
RESB,ROMS2,49,P,7,QUAN,13,3,MENG13,,,ROMS2,Size 2
RESB,ROMS3,50,P,7,QUAN,13,3,MENG13,,,ROMS3,Size 3
RESB,ROMEI,51,C,6,UNIT,3,0,MEINS,,,ROMEI,Unit of measure for sizes 1 to 3
RESB,ROMEN,52,P,7,QUAN,13,3,MENG13,,,ROMEN,Quantity of variable-size item
RESB,SGTXT,53,C,100,CHAR,50,0,TEXT50,,,SGTXT,Item Text
RESB,LMENG,54,P,7,QUAN,13,3,MENG13,,,LMENG,Required quantity for mat.management in stockkeeping units
RESB,ROHPS,55,C,2,CHAR,1,0,XFELD,,,ROHPS,Variable-sized item indicator
RESB,RFORM,56,C,4,CHAR,2,0,RFORM,,,RFORM,Formula key
RESB,ROANZ,57,P,7,QUAN,13,3,MENG13,,,ROANZ,Number of variable-size items
RESB,FLMNG,58,P,7,QUAN,13,3,MENG13,,,FLMNG,Shortfall quantity of the component in the order
RESB,STLTY,59,C,2,CHAR,1,0,STLTY,,,STLTY,BOM category
RESB,STLNR,60,C,16,CHAR,8,0,STNUM,,,STNUM,Bill of material
RESB,STLKN,61,N,16,NUMC,8,0,KNTNR,,,STLKN,BOM item node number
RESB,STPOZ,62,N,16,NUMC,8,0,CIM_COUNT,,,CIM_COUNT,Internal counter
RESB,LTXSP,63,C,2,LANG,1,0,SPRAS,,,LTXSP,Language: The long text was stored in this language
RESB,POTX1,64,C,80,CHAR,40,0,TEXT40,,,POTX1,BOM Item Text (Line 1)
RESB,POTX2,65,C,80,CHAR,40,0,TEXT40,,,POTX2,BOM item text (line 2)
RESB,SANKA,66,C,2,CHAR,1,0,CK_SELKZ,,,CK_SELKZ,Indicator for Relevancy to Costing
RESB,ALPOS,67,C,2,CHAR,1,0,XFELD,,,ALTPS,Alternative item indicator
RESB,EWAHR,68,P,2,DEC,3,0,DEC3,,,EWAHR,Usage probability in % (alternative item)
RESB,AUSCH,69,P,3,DEC,5,2,DEC3_2,,,KAUSF,Component scrap in percent
RESB,AVOAU,70,P,3,DEC,5,2,DEC3_2,,,AVOAU,Operation scrap
RESB,NETAU,71,C,2,CHAR,1,0,XFELD,,,NETAU,Indicator: Net scrap
RESB,NLFZT,72,P,2,DEC,3,0,NLFZT,,,NLFZT,Lead-time offset
RESB,AENNR,73,C,24,CHAR,12,0,AENNR,,,AENNR,Change Number
RESB,UMREZ,74,P,3,DEC,5,0,UMBSZ,,,UMREZ,Numerator for Conversion to Base Units of Measure
RESB,UMREN,75,P,3,DEC,5,0,UMBSN,,,UMREN,Denominator for conversion to base units of measure
RESB,SORTF,76,C,20,CHAR,10,0,CHAR10,,,SORTP,Sort String
RESB,SBTER,77,D,16,DATS,8,0,DATUM,,,SBTER,Latest requirements date
RESB,VERTI,78,C,8,CHAR,4,0,SA_VERTL,,,SA_VERTL,MRP Distribution Key
RESB,SCHGT,79,C,2,CHAR,1,0,XFELD,,,SCHGT,Indicator: Bulk Material
RESB,UPSKZ,80,C,2,CHAR,1,0,XFELD,,,UPSKZ,Indicator: sub-items exist
RESB,DBSKZ,81,C,2,CHAR,1,0,DBSKZ,,,DBSKZ,Direct procurement indicator
RESB,TXTPS,82,C,2,CHAR,1,0,XFELD,,,TXTPS,Item text indicator
RESB,DUMPS,83,C,2,CHAR,1,0,XFELD,,,DUMPS,Phantom item indicator
RESB,BEIKZ,84,C,2,CHAR,1,0,BEIKZ,,,BEIKZ,Material Provision Indicator
RESB,ERSKZ,85,C,2,CHAR,1,0,ERSKZ,,,ERSKZ,Indicator: spare part
RESB,AUFST,86,N,4,NUMC,2,0,AUFST,,,AUFST,Order level
RESB,AUFWG,87,N,4,NUMC,2,0,AUFWG,,,AUFWG,Order path
RESB,BAUST,88,N,4,NUMC,2,0,AUFST,,,BAUST,Assembly order level
RESB,BAUWG,89,N,4,NUMC,2,0,AUFWG,,,BAUWG,Assembly order path
RESB,AUFPS,90,C,4,CHAR,2,0,CHAR2,,,AUFPS,Order item number
RESB,EBELN,91,C,20,CHAR,10,0,EBELN,,,EBELN,Purchasing Document Number
RESB,EBELP,92,N,10,NUMC,5,0,EBELP,,,EBELP,Item Number of Purchasing Document
RESB,EBELE,93,N,8,NUMC,4,0,EETEN,,,EETEN,Delivery Schedule Line Counter
RESB,KNTTP,94,C,2,CHAR,1,0,KNTTP,,,KNTTP,Account Assignment Category
RESB,KZVBR,95,C,2,CHAR,1,0,KZVBR,,,KZVBR,Consumption Posting
RESB,PSPEL,96,N,16,NUMC,8,0,PS_POSNR,,,PS_POSNR,WBS Element
RESB,AUFPL,97,N,20,NUMC,10,0,AUFPL,,,CO_AUFPL,Routing number of operations in the order
RESB,PLNFL,98,C,12,CHAR,6,0,PLNFOLGE,,,PLNFOLGE,Sequence
RESB,VORNR,99,C,8,CHAR,4,0,VORNR,,,VORNR,Operation/Activity Number
RESB,APLZL,100,N,16,NUMC,8,0,CIM_COUNT,,,CIM_COUNT,Internal counter
RESB,OBJNR,101,C,44,CHAR,22,0,J_OBJNR,,,J_OBJNR,Object number
RESB,FLGAT,102,C,2,CHAR,1,0,FLGAT,,,FOLGENART,Sequence category
RESB,GPREIS,103,P,8,CURR,15,2,WERTV8,,,PPCOMP,Price in component currency
RESB,FPREIS,104,P,8,CURR,15,2,WERTV8,,,OPREIFX,Fixed Price in Foreign Currency
RESB,PEINH,105,P,3,DEC,5,0,PACK3,,,PEINH,Price Unit
RESB,RGEKZ,106,C,2,CHAR,1,0,XFELD,,,RGEKZ,Indicator: Backflush
RESB,EKGRP,107,C,6,CHAR,3,0,EKGRP,,,EKGRP,Purchasing Group
RESB,ROKME,108,C,6,UNIT,3,0,MEINS,,,ROKME,Unit of measure for variable-size component
RESB,ZUMEI,109,C,6,UNIT,3,0,MEINS,,,DZUMEI,Unit for cutting measures
RESB,ZUMS1,110,P,7,QUAN,13,3,MENG13,,,DZUMS1,Cutting measure 1
RESB,ZUMS2,111,P,7,QUAN,13,3,MENG13,,,DZUMS2,Cutting measure 2
RESB,ZUMS3,112,P,7,QUAN,13,3,MENG13,,,DZUMS3,Cutting measure 3
RESB,ZUDIV,113,N,10,NUMC,5,0,ZUDIV,,,DZUDIV,Integral divisor for cutting measures
RESB,VMENG,114,P,8,QUAN,15,3,MENG15,,,VMENG,Confirmed quantity for availability check in SKU
RESB,PRREG,115,C,4,CHAR,2,0,PRREG,,,PRREG,Checking Rule for Availability Check
RESB,LIFZT,116,P,2,DEC,3,0,DEC3,,,LIFZT,Delivery time in days
RESB,CUOBJ,117,N,36,NUMC,18,0,CUOBJ,,,CUOBJ,Configuration (internal object number)
RESB,KFPOS,118,C,2,CHAR,1,0,XFLAG,,,KFPOS,Indicator: "configurable item"
RESB,REVLV,119,C,4,CHAR,2,0,REVLV,,,REVLV,Revision Level
RESB,BERKZ,120,C,2,CHAR,1,0,LVS_BERKZ,,,BERKZ,Material Staging Indicator for Production Supply
RESB,LGNUM,121,C,6,CHAR,3,0,LGNUM,,,LGNUM,Warehouse Number / Warehouse Complex
RESB,LGTYP,122,C,6,CHAR,3,0,LGTYP,,,LGTYP,Storage Type
RESB,LGPLA,123,C,20,CHAR,10,0,LGPLA,,,LGPLA,Storage Bin
RESB,TBMNG,124,P,7,QUAN,13,3,MENG13,,,TBMNG,Transfer requirement quantity already requested
RESB,NPTXTKY,125,C,24,CHAR,12,0,CHAR12,,,TXTKY,Internal text number (12-character)
RESB,KBNKZ,126,C,2,CHAR,1,0,KBNKZ,,,KBNKZ,Kanban Indicator
RESB,KZKUP,127,C,2,CHAR,1,0,XFELD,,,KZKUP,Indicator: co-product
RESB,AFPOS,128,N,8,NUMC,4,0,CO_POSNR,,,CO_POSNR,Order Item Number
RESB,NO_DISP,129,C,2,CHAR,1,0,NO_DISP_PLUS,,,NO_DISP_PLUS,Effective for Materials Planning
RESB,BDZTP,130,T,12,TIMS,6,0,BDZTP,,,BDZTP,Time that reservation quantity required
RESB,ESMNG,131,F,8,FLTP,16,16,ESMNG,,,ESMNG,Usage quantity per order unit of measure
RESB,ALPGR,132,C,4,CHAR,2,0,CHAR2,,,CS_ALPGR,Alternative item: group
RESB,ALPRF,133,N,4,NUMC,2,0,NUM2,,,CS_ALPRF,Alternative item: ranking order
RESB,ALPST,134,C,2,CHAR,1,0,CS_ALPST,,,CS_ALPST,Alternative item: strategy
RESB,KZAUS,135,C,2,CHAR,1,0,AUSLF,,,AUSLF,Discontinuation type
RESB,NFEAG,136,C,4,CHAR,2,0,CHAR2,,,CS_NFEAG,Discontinuation group
RESB,NFPKZ,137,C,2,CHAR,1,0,XFELD,,,CS_KZNFP,Indicator: Follow-Up Item
RESB,NFGRP,138,C,4,CHAR,2,0,CHAR2,,,CS_NFGRP,Follow-up group
RESB,NFUML,139,P,3,DEC,5,4,NFUML,,,NFUML,NOT USED: Quantity transfer factor for follow-up material
RESB,ADRNR,140,C,20,CHAR,10,0,CADRNR,,,CADNR,Addresses: Address Number
RESB,CHOBJ,141,N,36,NUMC,18,0,CUOBJ,,,CUOBJ_CH,Internal object number of the batch classification
RESB,SPLKZ,142,C,2,CHAR,1,0,CHSPLIT,,,CHSPLIT,Batch key
RESB,SPLRV,143,N,8,NUMC,4,0,RSPOS,,,RSPOS,Item Number of Reservation/Dependent Requirement
RESB,KNUMH,144,C,20,CHAR,10,0,KNUMB,,,KNUMH_CH,Number of condition record from batch determination
RESB,WEMPF,145,C,24,CHAR,12,0,WEMPF,,,WEMPF,Goods Recipient/Ship-To Party
RESB,ABLAD,146,C,50,CHAR,25,0,TEXT25,,,ABLAD,Unloading Point
RESB,HKMAT,147,C,2,CHAR,1,0,HKMAT,,,HKMAT,Material-related origin
RESB,HRKFT,148,C,8,CHAR,4,0,HRKFT,,,HRKFT,Origin Group as Subdivision of Cost Element
RESB,VORAB,149,C,2,CHAR,1,0,XFELD,,,VORABKZ,Ind: Preliminary order
RESB,MATKL,150,C,18,CHAR,9,0,MATKL,,,MATKL,Material Group
RESB,FRUNV,151,C,2,CHAR,1,0,KREUZ,,,FRUNV,Indicator: External procurement data incomplete
RESB,CLAKZ,152,C,2,CHAR,1,0,XFELD,,,CLAKZ,Indicator: classification exists
RESB,INPOS,153,C,2,CHAR,1,0,XFELD,,,INPOS,Indicator: intra material
RESB,WEBAZ,154,P,2,DEC,3,0,DEC3,,,WEBAZ,Goods Receipt Processing Time in Days
RESB,LIFNR,155,C,20,CHAR,10,0,LIFNR,,,LIFNR,Account Number of Vendor or Creditor
RESB,FLGEX,156,C,2,CHAR,1,0,XFELD,,,FLGEX,Indicator: External procurement
RESB,FUNCT,157,C,6,CHAR,3,0,CY_FUNC,,,CY_FUNCT,Distribution function
RESB,GPREIS_2,158,P,8,CURR,15,2,WERTV8,,,PPGXXX,Total Price in Local Currency
RESB,FPREIS_2,159,P,8,CURR,15,2,WERTV8,,,PPFXXX,Fixed Price in Local Currency
RESB,PEINH_2,160,P,3,DEC,5,0,PACK3,,,PEINH,Price Unit
RESB,INFNR,161,C,20,CHAR,10,0,INFNR,,,INFNR,Number of Purchasing Info Record
RESB,KZECH,162,C,2,CHAR,1,0,KZECH,,,KZECH,Determination of batch entry in the production/process order
RESB,KZMPF,163,C,2,CHAR,1,0,XFELD,,,KZMPF,Manual Maintenance of Requirement Date
RESB,STLAL,164,C,4,CHAR,2,0,ALTNR,,,STALT,Alternative BOM
RESB,PBDNR,165,C,20,CHAR,10,0,CHAR10,,,PBDNR,Requirements Plan Number
RESB,STVKN,166,N,16,NUMC,8,0,KNTNR,,,STVKN,Inherited node number of BOM item
RESB,KTOMA,167,C,2,CHAR,1,0,CHAR1,,,KTOMA,Acct entered manually
RESB,VRPLA,168,C,2,CHAR,1,0,XFELD,,,VRPLA,Indicator: planning without final assembly
RESB,KZBWS,169,C,2,CHAR,1,0,KZBWS,,,KZBWS,Valuation of Special Stock
RESB,NLFZV,170,P,2,DEC,3,0,NLFZT,,,CS_NLFZV,Lead-time offset for operation
RESB,NLFMV,171,C,6,UNIT,3,0,MEINS,,,CS_NLFMV,Unit for lead-time offset for operation
RESB,TECHS,172,C,24,CHAR,12,0,TECHS,,,TECHS,Parameter Variant/Standard Variant
RESB,OBJTYPE,173,C,2,CHAR,1,0,OCM_OBJ_TYPE,,,OCM_OBJ_TYPE,Change indicator
RESB,CH_PROC,174,C,2,CHAR,1,0,OCM_CH_PROC,,,OCM_CH_PROC,Process that has lead to the change of an object
RESB,FXPRU,175,C,2,CHAR,1,0,XFELD,,,CK_FIXPRKU,Fixed-Price Co-Product
RESB,UMSOK,176,C,2,CHAR,1,0,SOBKZ,,,UMSOK,Special Stock Indicator for Physical Stock Transfer
RESB,VORAB_SM,177,C,2,CHAR,1,0,VORAB_SM,,,VORAB_SM,Advance Shipment Indicator
RESB,FIPOS,178,C,28,CHAR,14,0,FIPOS,,,FIPOS,Commitment Item
RESB,FIPEX,179,C,48,CHAR,24,0,FM_FIPEX,,,FM_FIPEX,Commitment Item
RESB,FISTL,180,C,32,CHAR,16,0,FISTL,,,FISTL,Funds Center
RESB,GEBER,181,C,20,CHAR,10,0,BP_GEBER,,,BP_GEBER,Fund
RESB,GRANT_NBR,182,C,40,CHAR,20,0,GM_GRANT_NBR,,,GM_GRANT_NBR,Grant
RESB,FKBER,183,C,32,CHAR,16,0,FKBER,,,FKBER,Functional Area
RESB,PRIO_URG,184,N,4,NUMC,2,0,PRIO_URG,,,PRIO_URG,Requirement Urgency
RESB,PRIO_REQ,185,N,6,NUMC,3,0,PRIO_REQ,,,PRIO_REQ,Requirement Priority
RESB,KBLNR,186,C,20,CHAR,10,0,KBLNR,,,KBLNR,Document Number for Earmarked Funds
RESB,KBLPOS,187,N,6,NUMC,3,0,KBLPOS,,,KBLPOS,Earmarked Funds: Document Item
RESB,BUDGET_PD,188,C,20,CHAR,10,0,FM_BUDGET_PERIOD,,,FM_BUDGET_PERIOD,FM: Budget Period
RESB,SC_OBJECT_ID,189,C,20,CHAR,10,0,/SRMERP/OBJECT_ID,,,/SRMERP/OBJECT_ID,Object ID -  Document Number
RESB,SC_ITM_NO,190,X,4,INT4,10,0,INT4,,,/SRMERP/SC_ITM_NO,Internal Shopping Cart Item Number
RESB,.INCLU--AP,191, ,0, ,0,0, ,,, ,
RESB,ADVCODE,192,C,4,CHAR,2,0,/ISDFPS/ADVCODE,,,/ISDFPS/ADVCODE,Advice Code




 RELATIONS BETWEEN RESB AND OTHER TABLES
有關聯的Table


EBANR-Header Table, Purchase Requisition, for Archiving 
     EBAN-Purchase Requisition 
          EBKN-Purchase Requisition Account Assignment 
     CDHDR-Change Document Header 
          CDPOS-Change Document Items 
     STXH-STXD SAPscript Text File Header 
          STXL-STXD SAPscript Text File Lines 
     EBUB-Index for Stock Transport Requisitions f. Material 
     RESB-Reservation/Dependent Requirements 

解釋關聯

EBANR SAP Header Table, Purchase Requisition, for Archiving Structure
..EBANR is an SAP Structure so does not store data like a database table does but can be used to process "Header Table, Purchase Requisition, for Archiving" INFORMATION WITHIN SAP ABAP PROGRAMS. THIS IS DONE BY DECLARING ABAP INTERNAL TABLES, WORK AREAS OR DATABASE TABLES based on this Structure. These can then be used to store and process the required data appropriately.Below is the documentation avaialable and full details of the fields which make up this Structure. You can view further information via relevant transactions such as SE11 or SE80. Also check out the Contributesection below to view or add related contributions and example screen shots. 



i.e. DATA: wa_EBANR TYPE EBANR .



Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Not classified
See here for more information about this and other SAP enhancement categories

==>View Table relationships


Dictionary fields for SAP Structure EBANR




Field
Component Type
Data Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3T000Client
BANFNBANFNCHAR10Purchase Requisition NumberALPHA


Key field
Non-key field


RELATIONS BETWEEN EBANR AND OTHER TABLES


EBANR-Header Table, Purchase Requisition, for Archiving
     EBAN-Purchase Requisition
          EBKN-Purchase Requisition Account Assignment
     CDHDR-Change Document Header
          CDPOS-Change Document Items
     STXH-STXD SAPscript Text File Header
          STXL-STXD SAPscript Text File Lines
     EBUB-Index for Stock Transport Requisitions f. Material
     RESB-Reservation/Dependent Requirements 


EBANNUMALL SAP Number Switch: Creation of Requisition Structure

EBANNUMALL is an SAP Structure so does not store data like a database table does but can be used to process "Number Switch: Creation of Requisition" INFORMATION WITHIN SAP ABAP PROGRAMS. THIS IS DONE BY DECLARING ABAP INTERNAL TABLES, WORK AREAS OR DATABASE TABLES based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_EBANNUMALL TYPE EBANNUMALL .

Below is the documentation avaialable and full details of the fields which make up this Structure. You can view further information via relevant transactions such as SE11 or SE80. Also check out the Contributesection below to view or add related contributions and example screen shots.

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Cannot Be Enhanced
See here for more information about this and other SAP enhancement categories


Dictionary fields for SAP Structure EBANNUMALL




Field
Component Type
Data Typelength (Decimals)Check tableDescriptionConversion Routine
INTBANFNBANFNCHAR10Purchase Requisition NumberALPHA
ORGBANFNBANFNCHAR10Purchase Requisition NumberALPHA
BNFPOBNFPONUMC5
*
Item Number of Purchase Requisition
AUFNRAUFNRCHAR12
*
Order NumberALPHA
PS_PSP_PNRPS_PSP_PNRNUMC8
*
Work Breakdown Structure Element (WBS Element)ABPSP
NPLNRNPLNRCHAR12
*
Network Number for Account AssignmentALPHA
AUFPLCO_AUFPLNUMC10Routing number of operations in the order
ARSNRARSNRNUMC10Settlement reservation number
VBELNVBELNCHAR10
*
Sales and Distribution Document NumberALPHA



EKKO-Purchasing Document Header 
     EKPO-Purchasing Document Item 
          EKBE-History per Purchasing Document 
          EKBZ-History per Purchasing Document: Delivery Costs 
          EKAB-Release (Order) Documentation 
     EKKN-Account Assignment in Purchasing Document 
     EKET-Scheduling Agreement Schedule Lines 
     ESSR-Service Entry Sheet Header Data 
     ESKN-Account Assignment in Service Package 
     A019-Contract Header 
     A016-Contract Item 
     A068-Outline Agreement Item: Plant-Dependent 
     KONM-Conditions (1-Dimensional Quantity Scale) 
     KONW-Conditions (1-Dimensional Value Scale) 
     KONP-Conditions (Item) 
     KONH-Conditions (Header) 
     KONV-Conditions (Transaction Data) 
     STXH-STXD SAPscript Text File Header 
          STXL-STXD SAPscript Text File Lines 
     CDHDR-Change Document Header 
          CDPOS-Change Document Items 
     EIKP-Foreign Trade: Export/Import: Header Data 
          EIPO-Foreign Trade: Export/Import: Item Data 
     NAST-Message Status 
     EKUB-Index for Stock Transport Orders for Material 
     EKPV-SD-Specific Data f. Stock Transfer for Purch. Doc. 
     RESB-Reservation/Dependent Requirements 
     EKES-Vendor Confirmations 
     EKPA-Partner Roles in Purchasing 
     EKBEH-Order History, Scheduling Agreement (Reorganized) 
     EKBZH-Delivery Costs History, Sched. Agreement (Reorg) 
     EKETH-Scheduling Agreement Schedule Lines (Reorganized) 
     EKEK-Scheduling Agreement Release History, Header 
     EKEH-Scheduling Agreement Release History, Sched. Lines 


EKKO-Purchasing Document Header 
     EKPO-Purchasing Document Item 
          EKKN-Account Assignment in Purchasing Document 
          EKES-Vendor Confirmations 
          EKAB-Release Documentation 
          EKBZ-History per Purchasing Document: Delivery Costs 
          EKBE-History per Purchasing Document 
          EKEK-Header Data for Scheduling Agreement Releases 
               EKEH-Scheduling Agreement Release Documentation 
          EKET-Scheduling Agreement Schedule Lines 
          T160T-Description of Selection Parameters 
          RESB-Reservation/Dependent Requirements 
          PRPS-PSP (Project Structure Plan) Element Master Data 


RKPF-Header Data for Reservation 
     PRPS-Internal Use: WBS Element on Selection Screen 
     RESB-Item Data for Reservation 
          T156T-Text for Movement Type 
          MAKT-Material Short Text 


CAUFVD-Dialog structure for order headers and items 
     AFPO-Order Item 
     AFFLD-Order: Dialog table for operation sequence (AFFL) 
          MOPER-Operation for production order - logical DB 
               KBED-Capacity requirements records 
               AFRU-Order Confirmations 
               AFFHD-Structure of the PRTs in orders 
               RESB-Reservation/dependent requirements 
               SOPER-Sub-operation for production order - log. DB 
                    SKBED-Capacity requirements for sub-operation - log. DB 
                    SAFRU-Sib-operation confirmations - log. DB 


CAUFV-Generated Table for View CAUFV 
     AFFL-Work order sequence 
          MOPER-Operation for production order - logical DB 
               KBED-Capacity requirements records 
               AFRU-Order Confirmations 
               AFFH-PRT assignment data for the work order 
               RESB-Reservation/dependent requirements 
               SOPER-Sub-operation for production order - log. DB 
                    SKBED-Capacity requirements for sub-operation - log. DB 
                    SAFRU-Sib-operation confirmations - log. DB 
     AFPO-Order Item 

MMBE: How to get SAP Stock Overview

沒有留言:

張貼留言