Flashback de MTV Microsoft Launcher 5.3 Announced with Redesigned Widgets Samsung foldable phone release rumored for Q3 2017 How To Get Reaper For Free (Working As Of 2019) MacOSX Global Xiaomi Redmi 4 receives stable MIUI 9 FIFA20 CRACK WIN.OS Free Download full game on PC MAC OS MacOSX Drivers for Flashing Samsung Cell Phones (Odin) Pluraleyes 4 1 4 serial Macro Recorder 5.0.3.6 With Crack For PC Cara Mendaftar e-mail di Yahoo! Indonesia
HiWrite a quey by joining two tablesEQUI and EQBS EQUI is having the material number for that serial numberEQBS is the serial number stock tablein IQ09/IQ03 ESTO status indicates that the serial numbers are in stock(in IQ09/IQ03 or EQBS consider 01 stock type as unrestricted,04 as intransit,07 as blocked,02 as quality inspection)accordingly tally the material serial number stock with the MB52/MMBE stock reportRegardsAmuthan M\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":7829255,\"creationDate\":1288156948000,\"activeRevisionId\":8955078,\"lastActivity\":1288156948000,\"parentId\":7829023,\"originalParentId\":7828903,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false}]}}"); const simplifiedQuestionView = JSON.parse("true"); (function() window.pageContext = mergeDeep(pageContext, question: id: 7828903, plug: "retrieve-serial-numbers-for-stock", votes: 0, questionTitle: "Retrieve Serial Numbers for Stock", isClosed: false, isLocked: false, isRedirected: false, redirectedFromTitle: "", redirectedFromId: "", closedStatusData: JSON.parse(""), userVoted: false, relations: JSON.parse("\"canClose\":false,\"canUnredirect\":false,\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"canReopen\":false,\"type\":\"question\",\"canVoteUpOrCancel\":false,\"canViewRevisions\":true,\"canUnlock\":false,\"reported\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canCancelReport\":false,\"canComment\":true,\"isCurrentUserAuthor\":false,\"canViewReports\":false"), isQuestionAccepted: false , childToViewInfo: id: "" , comments: JSON.parse("\"7829030\":\"rootParentId\":7829030,\"commentsCount\":2,\"comments\":[\"body\":\"HiWrite a quey by joining two tablesEQUI and EQBS EQUI is having the material number for that serial numberEQBS is the serial number stock tablein IQ09/IQ03 ESTO status indicates that the serial numbers are in stock(in IQ09/IQ03 or EQBS consider 01 stock type as unrestricted,04 as intransit,07 as blocked,02 as quality inspection)accordingly tally the material serial number stock with the MB52/MMBE stock reportRegardsAmuthan M\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":7829255,\"creationDate\":1288156948000,\"activeRevisionId\":8955078,\"lastActivity\":1288156948000,\"parentId\":7829023,\"originalParentId\":7828903,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false]"), answerPager: answersCount: 4, page: 1, pageSize: 10, pageCount: 1, sort: "votes" , answers: JSON.parse("[\"body\":\"HI,\\n\\n You try using IQ09 txn. there enter ur plant and Sloc.. It will show the Serial number based on Stk available at the Sloc.\\n\\nRegards\\nGK.\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":7829235,\"posted\":1288156532000,\"votes\":1,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"score\":1,\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"You are able to get the serial nos through EQUI by giving the date range and material.afterthat you pass the equipment no here you can get the plant and s loc.\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":7828992,\"posted\":1288151642000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"Hi,\\n\\nThank you for your answer. The entries EQUI does not indicate the Serial Numbers exactly that are in Stock especially when the Plant and Storage Location here are not maintained (I tried one material to get the serial numbers but unfortunately, the plant and storage location fields are blank)\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":7829030,\"posted\":1288152768000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"Used FM 'GET_SERNOS_OF_DOCUMENT' to get the Serial Numbers based on the Material Documents retrieved and get the status by FM 'BAPI_EQUI_GETSTATUS'. Since I have to get the Plant and Storage Location also, I have to do a query to EQBS.\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":7844104,\"posted\":1288663630000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[]]"), answerForm: formAction: "/answers/7828903/post.json", textareaName: "body", textareaErrors: "", isAttachmentsEnabled: true, answerEditorialGuideline: title: "Before answering", content: "You should only submit an answer when you are proposing a solution to the poster\'s problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that your answer complies with our Rules of Engagement.", links: [ title: "Rules of Engagement", href: " -of-engagement.html", ] , answerMinBodyLength: '10', answerMaxBodyLength: '20000' , currentUser: sapInternalId: '', permissions: canVoteUpOrCancel: false, canVoteDownOrCancel: false, canModerate: false, , isVotedUp: false, isVotedDown: false , alerts: alertModeratorMinLength : "It should be given a proper explanation about why the content is inappropriate.", alertModeratorMinLengthValue : "10", alreadyReportedMessage : "You already have an active moderator alert for this content." , url: profileApiBaseUrl: ' -api.services.sap.com', followUnfollowQuestion: '/sap/nodeSubscription.json', isFollowingQuestion: '/sap/isFollowingNode.json', vote: voteUp: '/commands/0/voteup.json', voteDown: '/commands/0/votedown.json', cancelVote: '/commands/0/cancelvote.json' , rss: answers: '/feed/7828903/answers.rss', answersAndComments: '/feed/7828903/comments-and-answers.rss' , authorizeUploadContext: type: 'answer' , atMention: userSearchServiceUrl: ' ', currentUserName: '', useNewUSSCORS: true, atMentionDelayMs: 100, showMentionInRedactor: true , attachmentSettings: commentMaxAttachments: '2', answerMaxAttachments: '10', commentMaxAttachmentSizeBytes: '1048576', answerMaxAttachmentSizeBytes: '1048576', commentAttachmentsSizeBytesTotal: '2097152', answerAttachmentsSizeBytesTotal: '10485760' , editor: editorClipboardUploadEnabled: true ) )(); Home
Community
Ask a Question
Write a Blog Post
Login / Sign-up Search Questions and Answers 0 Former Member Oct 27, 2010 at 03:25 AM Retrieve Serial Numbers for Stock 2126 Views Follow RSS Feed HI Experts,
Serial Para Stockbase 15
hi\\n\\ni agree with ur logic \\n\\nJOIN SER03 AND OBJKON OBKNR = OBKNRAND MATNR = MATNR\\n\\nBut I having 1 material code having 10 quantity so it generate 10 serial number .suppose I have to select 5 qty with serial number for consumption then i have to give validation on object counter in OBJK table so please provide this link between object counter & material & serial nmber so that I perfectly fetch data.\",\"author\":\"username\":\"prashant.kale\",\"displayName\":\"Ragini sap\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"sjeevan\",\"displayName\":\"Jeevan Sagar\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":9496410,\"creationDate\":1345646807000,\"activeRevisionId\":10291040,\"lastActivity\":1345646807000,\"parentId\":9494301,\"originalParentId\":9481498,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false}]}}"); const simplifiedQuestionView = JSON.parse("true"); (function() window.pageContext = mergeDeep(pageContext, question: id: 9481498, plug: "link-between-stock--serial-number-table", votes: 0, questionTitle: "Link between stock & serial number table", isClosed: false, isLocked: false, isRedirected: false, redirectedFromTitle: "", redirectedFromId: "", closedStatusData: JSON.parse(""), userVoted: false, relations: JSON.parse("\"canClose\":false,\"canUnredirect\":false,\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"canReopen\":false,\"type\":\"question\",\"canVoteUpOrCancel\":false,\"canViewRevisions\":true,\"canUnlock\":false,\"reported\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canCancelReport\":false,\"canComment\":true,\"isCurrentUserAuthor\":false,\"canViewReports\":false"), isQuestionAccepted: false , childToViewInfo: id: "" , comments: JSON.parse("\"9484000\":\"rootParentId\":9484000,\"commentsCount\":7,\"comments\":[\"body\":\"hi\\n\\ni agree with ur logic \\n\\nJOIN SER03 AND OBJKON OBKNR = OBKNRAND MATNR = MATNR\\n\\nBut I having 1 material code having 10 quantity so it generate 10 serial number .suppose I have to select 5 qty with serial number for consumption then i have to give validation on object counter in OBJK table so please provide this link between object counter & material & serial nmber so that I perfectly fetch data.\",\"author\":\"username\":\"prashant.kale\",\"displayName\":\"Ragini sap\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"sjeevan\",\"displayName\":\"Jeevan Sagar\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":9496410,\"creationDate\":1345646807000,\"activeRevisionId\":10291040,\"lastActivity\":1345646807000,\"parentId\":9494301,\"originalParentId\":9481498,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false]"), answerPager: answersCount: 5, page: 1, pageSize: 10, pageCount: 1, sort: "votes" , answers: JSON.parse("[\"body\":\"hi\\n\\nWhen I am see stock in mb5b ,6 quantity on 10 august 2012 so in which table i will get the stock quantity 06 with 06 serial number on 10 august 2012 ? please help to solve.\\n\\nthanks in advance.\",\"author\":\"username\":\"prashant.kale\",\"displayName\":\"Ragini sap\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":9484000,\"posted\":1345030029000,\"votes\":1,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"score\":1,\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"HI,Refer the table SERI, it stores the material number with the serial number./Manoj\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":9481759,\"posted\":1344936287000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"Below are the tables for Serial numbers, Check which is useful to you, Also check RIPW0, SERI & EQSE tablesSER00General Header Table for Serial Number ManagementSER01Document Header for Serial Numbers for DeliverySER02Document Header for Serial Nos for Maint.Contract (SD Order)SER03Document Header for Serial Numbers for Goods MovementsSER04Document Header for Serial Numbers for Inspection LotSER05Document Header for Serial Numbers for PP OrderSER06Document Header for Serial Numbers for Handling Unit-ContentSER07Document Header for Serial Numbers in Physical InventorySER08Document Header for Purchase Order Item Serial NumbersSER09Doc. Header for Serial Numbers for Purchase Requisition Item\",\"author\":\"username\":\"tej.yadav\",\"displayName\":\"Tej Yadav\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":9481875,\"posted\":1344937482000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"hi\\n\\nCan you provide link between object counter & equipment number & material for OBJK table So that i can fetch data for report\",\"author\":\"username\":\"prashant.kale\",\"displayName\":\"Ragini sap\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":9493707,\"posted\":1345561088000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"This message was moderated.\",\"author\":\"username\":\"nareshk\",\"displayName\":\"NARESH NAIDU\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":12411810,\"posted\":1464276057000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[]]"), answerForm: formAction: "/answers/9481498/post.json", textareaName: "body", textareaErrors: "", isAttachmentsEnabled: true, answerEditorialGuideline: title: "Before answering", content: "You should only submit an answer when you are proposing a solution to the poster\'s problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that your answer complies with our Rules of Engagement.", links: [ title: "Rules of Engagement", href: " -of-engagement.html", ] , answerMinBodyLength: '10', answerMaxBodyLength: '20000' , currentUser: sapInternalId: '', permissions: canVoteUpOrCancel: false, canVoteDownOrCancel: false, canModerate: false, , isVotedUp: false, isVotedDown: false , alerts: alertModeratorMinLength : "It should be given a proper explanation about why the content is inappropriate.", alertModeratorMinLengthValue : "10", alreadyReportedMessage : "You already have an active moderator alert for this content." , url: profileApiBaseUrl: ' -api.services.sap.com', followUnfollowQuestion: '/sap/nodeSubscription.json', isFollowingQuestion: '/sap/isFollowingNode.json', vote: voteUp: '/commands/0/voteup.json', voteDown: '/commands/0/votedown.json', cancelVote: '/commands/0/cancelvote.json' , rss: answers: '/feed/9481498/answers.rss', answersAndComments: '/feed/9481498/comments-and-answers.rss' , authorizeUploadContext: type: 'answer' , atMention: userSearchServiceUrl: ' ', currentUserName: '', useNewUSSCORS: true, atMentionDelayMs: 100, showMentionInRedactor: true , attachmentSettings: commentMaxAttachments: '2', answerMaxAttachments: '10', commentMaxAttachmentSizeBytes: '1048576', answerMaxAttachmentSizeBytes: '1048576', commentAttachmentsSizeBytesTotal: '2097152', answerAttachmentsSizeBytesTotal: '10485760' , editor: editorClipboardUploadEnabled: true ) )(); Home
Community
Ask a Question
Write a Blog Post
Login / Sign-up Search Questions and Answers 0 Ragini sap Aug 14, 2012 at 07:14 AM Link between stock & serial number table 4867 Views Follow RSS Feed hi 2ff7e9595c
Comments