1 / 21

Data Structure

Data Structure. Check data structure from user interface Naming Standard Basic master data structure Sales and purchase transaction table Inventory transaction table Financial transaction table Manufacturing table Cost accounting table. Check data structure from user interface.

nuala
Download Presentation

Data Structure

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Structure Check data structure from user interface Naming Standard Basic master data structure Sales and purchase transaction table Inventory transaction table Financial transaction table Manufacturing table Cost accounting table

  2. Check data structure from user interface

  3. From user interface view data table Click this icon Put the cursor into field

  4. From user interface view data table Click this button On title information bar, the table and column information showing: The format of the information is MODULE_NAME.TABLE_NAME.COLUMN STKMAS.STK_MAS.STK_C We can tell the table name is STK_MAS and column is STK_C Note: The most situation does follow this pattern to check the table structure. But sometime, there is a exception

  5. The Exception 2. Click this icon 1. Place the cursor in this field 2. Message showing. Note: CONTROL is not the table name in this case. The number field in all GeO document relates to CONTROL data block 1. Click this button

  6. Use TOAD to view table structure 6. Check the data of the table 1. Input table name 4. Check the constraint of the table 5. Check the index of the table 2. Double click on table name 3. Table column will show

  7. Summary of Pre-Post and After-Post Control Package Table Naming Standard

  8. General short form in table name ORG Organization LOC Location WH Warehouse DEPT Department PROJ Project ANA Analysis Code ACC Account STK Stock CAT Category REF Reference field BRAND Brand BOM Bill of material OPT Operation node SP Sales and Purchase IO Stock in/out ROB Reserve, On order, Back order ADJ Adjustment CHG Change Note MAT Material FGR Finished Goods WO Work order MPS Master product planning CURR Currency code MAS: Master or document header ITEM: Document item LOT: Lot detail for item SOURCE Source document SRC Source document APP Application module AGE Ageing CAGE Customer Ageing DTL Detail TZ Time Zone PB Price Book GRP Group SUMP Summary M Monthly DISC Discount VOU GL Voucher PRE Previous ROUTE Routing SC System control ZONE Zone VAL Value QTY Quantity QC Quality control RES Resource CRP Capacity of Resource Planning JOB Job MRES Resource Master MPRO Process Master (Operation master) UOM Unit of Measurement ALT Alternative SIO Manufacturing stock in out document. Use with WO RECPAY Official Receipt and Payment CHK Cheque

  9. System control table naming standard System Control Table SCxxxx: Start with ‘SC’ SCORG: Organization Master Table SCAPPLOC: Location Master Table SCUSER: Internal User or external user master table SCGRPUSER Group and user master table SCAPPUSER: Access control. Application modules and user. SCAPPMODULE: Application privilege and user SCAPP: Application module list table SCAPP_GROUP: Application group master list ….:

  10. Accounting master data table Accounting Short Form:ACC, ACCOUNT ACCOUNT_MAS: GL Account master data ACC_CAT1 GL Account category 1 master ACC_CAT2 GL Account category 2 master …. ACC_CAT11 Customer or supplier type 1 ACC_CAT12 Customer or supplier type 2 ACC_ANA_CODE Analysis code setting table ACC_AGE_SEG Customer ageing segment

  11. Warehouse master data table Short Form:WH WH_MAS Warehouse master WH_ZONE Zone in warehouse WH_BIN BIN master data …. WH_IO_MAS Warehouse Transfer Note header WH_IO_ITEM Warehouse transfer note item WH_IO_ITEM_LOT Warehouse transfer note item lot detail ….

  12. Stock related table Short Form:STK STK_MAS : Stock master STK_CAT Stock category 1 master STK_CAT2 Stock category 2 master STK_BRAND Stock brand master …. STK_UOM_REF Stock alternative UOM Stock transaction document STK_IO_MAS Stock receive and issue document header STK_IO_ITEM Stock receive and issue item STK_IO_ITEM_LOT Stock receive and issue item lot STK_TAKE_MAS Stock take doucment header STK_TAKE_ITEM Stock take document item Backend table STK_DETAIL Store all stock in/out transactions STK_DTL Store current stock balance quantity STK_ROB_DTL Store reserve, back order status STK_WH Stock in warehouse

  13. BOM related table Short Form:BOM BOM_STK_MAS Finished or semi finished in BOM BOM_MAT_MAS Components defined in BOM BOM_DTL The flat list of BOM BOM_ROUTE_MAS Routing master BOM_OPT_MAS Bill of routing component BOM_MAT_ALT …. MRES_MAS Resource master MPRO_MAS Process (Operation) master

  14. Document Table – Sales and Purchase Transaction Table Short Form:SP SP_MAS Sales and Purchase document header. SP_ITEM Document item SP_ITEM_LOT Item lot SP_ITEM_PRICE Price detail in document Document cover Sales: Purchase Quotation RFQ Pre Sales Order Purchase Order Sales Order Shipment Schedule Delivery Schedule Goods Receive Note Delivery Order Return to Supplier Note Customer Return Note Supplier Invoice Sales Invoice Supplier Credit Note Credit Note Commercial Invoice Short Form: SPCHG SPCHG_MAS Sales and Purchase Order Change Note header SPCHG_ITEM Original item SPCHG_ITEM_DTL Detail item list after change for the original item

  15. Document Table – Inventory transaction table Short Form:STK_IO, STK_TAKE STK_IO_MAS Stock receive and issue document header. STK_IO_ITEM Document item STK_IO_ITEM_LOT Item lot Document cover Stock Issue Requisition Stock Receive Requisition Stock Issue Note Stock Receive Note Stock Transfer Requisition Stock Transfer Receive Note Stock Transfer Issue Note STK_TAKE_MAS Stock take document header STK_TAKE_ITEM Stock take document item Document cover Stock take slip Stock take Stock value adjustment

  16. Document Table – Manufacturing transaction table Short Form:MPS, WO MPS_MAS Master Production Scheduling or Job order header. MPS_MAT_ITEM Summary of finished goods or semi finished goods under header MPS_SO_ITEM Consolidation items form SO in MPS document. MPS_SO_DTL Item details for SO item in MPS document. Documents Master Production Schedule (Module No 73120) Job Order (Module No: 73110) WO_MAS Work order document header WO_MAT_ITEM Material list in Work Order document WO_OPT_ITEM Operation item (Routing process) in Work Order WO_FG_ITEM Finished goods item in Work Order Documents Work Order

  17. Document Table – Manufacturing transaction table Short Form:WO WO_SIO_MAS Stock in-out document in manufacturing system. WO_SIO_ITEM Stock in-out document item WO_SIO_LOT Stock item lot in stock in-out manufacturing document. Documents Finished Goods Receive Note Finished Goods Receive Batch Note Material Issue Note Material Issue Batch Note Material Return Note Material Return Batch Note Outsource Return Issue Note Outsource Return Receive Note

  18. Document Table – Accounting transaction table (AR) Short Form:AR AR_CHK_MAS AR Cheque receive and process document header AR_CHK_ITEM AR Cheque receive and process item AR_CHK_ITEM_OTHER Other GL entry in AR Cheque document AR_DOWNPAY_ITEM_CLR Down payment offset item in AR Cheque AR_CHK_ITEM_CLR Item offset to AR Cheque Documents AR Cheque Receive AR Cheque Receive Process AR Cheque Collection AR Cheque Withdraw AR Cheque Exchange AR Cheque Encash

  19. Document Table – Accounting transaction table (AP) Short Form:AP_CHK AP_CHK_MAS AR Cheque receive and process document header AP_CHK_ITEM AP Cheque receive and process item AP_CHK_ITEM_OTHER Other GL entry in AP Cheque document AP_DOWNPAY_ITEM_CLR Down payment offset item in AP Cheque AP_CHK_ITEM_CLR Item offset to AP Cheque Documents AP Cheque Issue AP Cheque Issue Process AP Cheque Exchange AP Cheque Encash Short Form:AP_EXP AP_EXP_MAS AP Expense Payment document header AP_EXP_ITEM Item in AP Expense Payment AP_EXP_TAX Tax detail in AP Expense Payment AP_PRE_ITEM Pre-payment offset in AP Expense Payment Documents Expense Payment Batch

  20. Document Table – Accounting transaction table (GL) Short Form:BATCH BATCH_MAS Some types of GL process document header BATCH_ITEM Item in GL document GRP_CLR_ITEM Item in group clearing batch and contra batch ORG_ITEM Unrealized currency gain and lost item data. Documents Group clearing batch Contra batch Currency evaluation batch Unrealized currency gain and lost batch Short Form:VOU VOU_MAS GL Voucher document header VOU_ITEM Voucher Item Documents GL Voucher

  21. Backed tables Inventory transaction table STK_DETAIL Stock transaction STK_DTL Inventory balance status STK_ROB_DTL Stock reserve, on order and back order detail Documents All stock in and out transactions store in STK_DETAIL table The current balance status of inventory Account transaction table ACC_DETAIL Financial transaction detail table ACC_SUMMARY Financial Summary amount by fiscal year and period ACC_CLEAR_DTL AR,AP Clearing detail table. Offset record PK No and clearing amount are stored in this table. Documents All financial transactions (Journal entry, AR, AP) are stored into ACC_DETAIL The summary figure of financial records Cost Accounting STK_M_DETAIL Material cost, labor, operating, overhead cost are stored in this table after monthly cost refreshment STK_M_SUMP Summary of STK_M_DETAIL by fiscal year and period.

More Related