Fi-Sl Special Purpose Ledger Under Data Transfer Programs

As a part of Project Training it is important for SAP consultants to know about Interfaces and IDOCs. This session is applicable to all module consultants. SAP Explore Blogs. This report will take delivery document number and delivery date from user and fetches details from delivery table and fetchescorresponding sales order details and billing details  and displays sales order details with ALV list. Report salesorderreport. Table declarations. TABLES likp. SD Document Delivery Header  DataSelection Screen Elements. SELECT OPTIONS sdeldoc FOR likp vbeln, Deliverysdldate FOR likp lfdat. Delivery Date Type declaration of the structure to hold specified delivery header data YPES BEGIN OF typeslikp,vbeln TYPE likp vbeln, Deliverylfdat TYPE likp lfdat, Delivery Datekunnr TYPE likp kunnr, Ship to party. Fi-Sl Special Purpose Ledger Under Data Transfer Programs' title='Fi-Sl Special Purpose Ledger Under Data Transfer Programs' />END OF typeslikp. Type declaration of the structure to hold specified delivery item  data      YPES BEGIN OF typeslips,vbeln TYPE lips vbeln, Deliveryposnr TYPE lips posnr, Delivery Itemvgbel TYPE lips vgbel, Document number of the  reference documentvgpos TYPE lips vgpos, Item number of the reference  itemlfimg TYPE lips lfimg, Actual quantity delivered insales unitsvrkme TYPE lips vrkme, Sales unit. END OF typeslips. Type declaration of the structure to hold specified data in Customer Master YPES BEGIN OF typeskna. TYPE kna. 1 kunnr, Customer Number 1name. TYPE kna. 1 name. Name 1. END OF typeskna. Type declarations. Type declaration of the structure to hold specified sales document  header data YPES BEGIN OF typesvbak,vbeln TYPE vbak vbeln, Sales Documenterdat TYPE vbak erdat, Date on Which Record Was  Createdaufnr TYPE vbak aufnr, Order Number. SAP Executable ABAP Report SAPF100 documentation and ABAP source code. I completed upto define and. Young The Giant Mind Over Matter Zip there. Subtopic. Question. Release. Answer. Material Valuation Material Ledger Integration How will material valuation work if only the company currency is configured The following section contains an overview of the formats that are supported for the electronic bank statement. Creating Actual Documents Use. You can enter a document for Local company codes When you enter a document for a local company code, the document is posted to all. END OF typesvbak. Type declaration of the structure to hold specified sales document   item data YPES BEGIN OF typesvbap,vbeln TYPE vbak vbeln, Sales Documentposnr TYPE vbap posnr, Sales Document Itemmatnr TYPE vbap matnr, Material Numberarktx TYPE vbap arktx, Short text for sales orderitemkwmeng TYPE vbap kwmeng, Cumulative Order Quantity in sales Unitsvrkme TYPE vbap vrkme, Sales unit. END OF typesvbap. Type declaration of the structure to hold specified billing item  data                YPES BEGIN OF typesvbrp,vbeln TYPE vbrp vbeln, Billing Documentposnr TYPE vbrp posnr, Billing itemvgbel TYPE vbrp vgbel, Document number of the reference documentvgpos TYPE vbrp vgpos, Item number of the reference itemfklmg TYPE vbrp fklmg, Billing quantity in stockkeeping unitvrkme TYPE vbrp vrkme, Sales unit. END OF typesvbrp. Type declaration of the structure to hold specified sales socument                      header,sales document item data,delivery item data,billing item data            YPES BEGIN OF typesorder,vbeln TYPE vbap vbeln, Sales Documentposnr TYPE vbap posnr, Sales Document Itemerdat TYPE vbak erdat, Date on Which Record Was Createdkunnr TYPE likp kunnr, Sold to partyname. TYPE kna. 1 name. Name 1aufnr TYPE vbak aufnr, Order Numbermatnr TYPE vbap matnr, Material Numberarktx TYPE vbap arktx, Short text for sales orderitemkwmeng TYPE vbap kwmeng, Cumulative Order Quantity in sales Unitsvrkme TYPE vbap vrkme, Sales unitvbeln. Fi-Sl Special Purpose Ledger Under Data Transfer Programs' title='Fi-Sl Special Purpose Ledger Under Data Transfer Programs' />TYPE lips vbeln, Deliveryposnr. TYPE lips posnr, Delivery Itemlfimg TYPE lips lfimg, Actual quantity delivered in sales unitsvrkme. TYPE lips vrkme, Sales unitvbeln. TYPE vbrp vbeln, Billing Documentposnr. TYPE vbrp posnr, Billing itemfklmg TYPE vbrp fklmg, Billing quantity in stockkeeping unitvrkme. TYPE vbrp vrkme, Sales unit. END OF typesorder. Data declarations. Work variables                                                                                                  ATA wcontainer TYPE REF TO clguicustomcontainer, Reference variable for                                                                                   containerwgrid TYPE REF TO clguialvgrid. Reference variable for grid Field String declarations. Field string variable to hold sales socument header,sales document              item data,delivery item data,billing item data,fieldcatalog,layout  record          ATA fskna. TYPE typeskna. 1, Holds Customer master recordfsvbak TYPE typesvbak, Holds sales header recordfsvbap TYPE typesvbap, Holds sales item recordfslikp TYPE typeslikp, Holds delivery header recordfslips TYPE typeslips, Holds delivery item recordfsvbrp TYPE typesvbrp, Holds billing item recordfsorder TYPE typesorder, Holds sales order recordfscat TYPE lvcsfcat, Holds fieldcatalog recordfslay TYPE lvcslayo. Tcodes here with report also. T Code Report HeaderDescription. VA0. 0 MENUVA0. 0 Initial Sales MenuVA0. SAPMV4. 5A Create Sales OrderVA0. SAPMV4. 5A Change Sales OrderVA0. SAPMV4. 5A Display Sales OrderVA0. SAPMV7. 5A List of Sales OrdersVA0. SDBANF0. 2 Compare Sales Purchasing OrderVA0. SDBANF0. 1 Compare Sales Purchasing Org. Dt. VA1. 1 SAPMV4. A Create InquiryVA1. SAPMV4. 5A Change InquiryVA1. SAPMV4. 5A Display InquiryVA1. L SDLIEFSPE Sales Documents Blocked for DeliverVA1. SAPMV7. 5A Inquiries ListVA2. SAPMV4. 5A Create QuotationVA2. SAPMV4. 5A Change QuotationVA2. SAPMV4. 5A Display QuotationVA2. SAPMV7. 5A Quotations List. VA2. 6 SAPMV7. 5A Collective Processing for Quotation. VA3. 1 SAPMV4. 5A Create Scheduling Agreement. VA3. 2 SAPMV4. 5A Change Scheduling Agreement. VA3. 3 SAPMV4. 5A Display Scheduling Agreement. VA3. 5 SAPMV7. 5A List of Scheduling Agreements. VA4. 1 SAPMV4. 5A Create Contract. VA4. 2 SAPMV4. 5A Change Contract. VA4. 2W SAPMV4. 5A Workflow for master contract. VA4. 3 SAPMV4. 5A Display Contract. VA4. 4 SAPLKAZB Actual Overhead Sales Order. VA4. 5 SAPMV7. 5A List of Contracts. VA4. 6 SAPMV7. 5A Coll. Subseq. Processing f. Contracts. VA5. 1 SAPMV4. A Create Item Proposal. VA5. 2 SAPMV4. 5A Change Item Proposal. VA5. 3 SAPMV4. 5A Display Item Proposal. VA5. 5 SAPMV7. 5A List of Item Proposals. VA8. 8 SAPLKO7. 1 Actual Settlement Sales Orders. VA9. 4 RVEXSOVA Load Commodity Codes for Japan. VA9. 4X RVEXSOJ2 Load Commodity Codes for Japan. VA9. 5 RVEXREOR Merge Commodity CodeImport Code No. VBD RV1. 5C0. 05 Rebate Agreement Settlement. VB1 SAPMSNUM Rebate number ranges. VB7 RV1. 5C0. 01 Rebate Agreement Settlement. VB8 RV1. 5C0. 02 List Rebate Agreements. VBG1 SAPMV2. 3N Create Material Grouping. VBG2 SAPMV2. 3N Change Material Grouping. VBG3 SAPMV2. 3N Display Material Grouping. VBKB SAPMV1. 2A Bonus Buy Create Condition Table. VBKC SAPMV1. 2A Bonus Buy Display Condition Table. VBK0 MENUVBK0 Bonus Buy Selection. VBK1 SAPMV1. 3N Create Bonus Buy. VBK2 SAPMV1. 3N Change Bonus Buy. VBK3 SAPMV1. 3N Display Bonus Buy. VBK6 BBYDELETE Delete Bonus Buy. VBN1 SAPMV1. 3N Free goods Create SDVBN2 SAPMV1. N Free goods Change SDVBN3 SAPMV1. N Free goods Display SDVBOE RV1. C0. 06 Currency conversion rebate agreemnt. VBOF SDBONT0. 6 Rebate Update Billing Documents. VBO1 SAPMV1. 3A Create Rebate Agreement. VBO2 SAPMV1. 3A Change Rebate Agreement. VBO3 SAPMV1. 3A Display Rebate Agreement. VB0. 1 SAPMV1. 3G Create Material ListingExclusion. VB0. 2 SAPMV1. 3G Change Material ListingExclusion. VB0. 3 SAPMV1. 3G Display Material ListingExclusion. VB0. 4 SAPMV1. 3G Reference Material ListingExclusio. VB1. 1 SAPMV1. 3D Create Material Substitution. VB1. 2 SAPMV1. 3D Change Material Substitution. VB1. 3 SAPMV1. 3D Display Material Substitution. VB1. 4 SAPMV1. 3D Reference Material Substitution. VB2. 1 SAPMV1. 3A Create Sales Deal. VB2. 2 SAPMV1. 3A Change Sales Deal. VB2. 3 SAPMV1. 3A Display Sales Promotion. VB2. 5 RV1. 5C0. 04 List of Sales Deals. VB3. 1 SAPMV1. 3A Create Promotion. VB3. 2 SAPMV1. 3A Change Promotion. VB3. 3 SAPMV1. 3A Display Promotion. VB3. 5 RV1. 5C0. 03 Promotions List. VB4. 1 SAPMV1. 3D Create cross selling. VB4. 2 SAPMV1. 3D Change cross selling. VB4. 3 SAPMV1. 3D Display cross selling. VB4. 4 SAPMV1. 3D Copy cross selling. VCA SAPL0. 43. B Sales Activity Description 0. VCB SAPL0. 43. B Sales Activity Description 0. VCC SAPL0. 43. B Sales Activity Description 0. VCD SAPL0. 43. B Sales Activity Description 0. VCE SAPL0. 43. B Sales Activity Description 0. VCF SAPL0. 43. B Sales Activity Description 0. VCG SAPL0. 43. B Sales Activity Description 0. VCH SAPL0. 43. B Sales Activity Description 0. VCI SAPL0. 43. B Sales Activity Description 0. VCJ SAPL0. 43. B Sales Activity Description 1. VC1 RVDEB0. 01 List of Customers. VC2 RVKUSTA1 Customer Master Data Sheet. VCC1 RV2. 1A0. 01 Payment Cards Worklist. VCH1 SAPMV1. 3H Create Batch Search Strategy. VCH2 SAPMV1. 3H Change Batch Search Strategy. VCH3 SAPMV1. 3H Display Batch Search Strategy. VCR1 SDWETTMAT Competitive products. VCUAC SAPMV1. 3A Display Anti dumping Qty dependen. VCUAE SAPMV1. 3A Display Anti dumping Weight depen. VCUDC SAPMV1. 3A Display 3rd Country Qty dependent. VCUDE SAPMV1. 3A Display 3rd Country Weight depend. VCUPC SAPMV1. 3A Display Pharma. Prod. Qty dependen. VCUPF SAPMV1. 3A Display Pharma. Prod. Weight depen. VCUP1 SAPMV1. 3A Display Preference Qty dependent. VCUP2 SAPMV1. 3A Display Preference Weight depend. VCUZC SAPMV1. 3A Display Quota Quantity dependent. VCUZE SAPMV1. 3A Display Quota Weight dependent. VCUZP SAPMV1. 3A Display Ceilings Percentage. VCUZ1 SAPMV1. 3A Display Ceiling Quantity dependen. VCUZ2 SAPMV1. 3A Display Ceiling Weight dependent. VC0. 0 MENUVC0. 0 Sales Support. VC0. 1 SAPMV4. 3A Create Sales Activity. VC0. 1N SDCONTACTMAINEdit Sales Activity. VC0. 2 SAPMV4. 3A Change Sales Activity. VC0. 3 SAPMV4. 3A Display Sales Activity. VC0. 5 SDCAS7. 5C Sales support monitor. VC0. 6 SAPMV4. 3M Parallel Processing for Address Lis. VC1. 5 SDCASCROSSMATCrossmatching. VDDI SDEWUDEB EMU currency conversion cust. VDH1 RVKNVH0. 0 Customer Hierarchy Maintenance SDVDH1. N RVCUSTOMERHIEDisplayMaintain Customer Hierarchy. VDH2 RVKNVH0. 0 Display Customer Hierarchy. VDH2. N RVCUSTOMERHIEDisplay customer hierarchy. VD0. 1 SAPMF0. 2D Create Customer SalesVD0. SAPMF0. 2D Change Customer SalesVD0. SAPMF0. 2D Display Customer SalesVD0. SAPMF0. 1A Customer Changes SDVD0. SAPMF0. 2D Block customer salesVD0. SAPMF0. 2D Mark customer for deletion salesVD0. SAPL0. ORG Ref. doc. VD5. 1 SAPMV1. 0A Maintain Customer Material Info. VD5. 2 SAPMV1. 0A Maintain Cust Mat. Info wSelect. Scr. VD5. 3 SAPMV1. 0A Display Customer Material Info. VD5. 4 SAPMV1. 0A Display Customer Material Info. VD5. 9 RV1. 0A1. 00 List customer material info. VEA3 RVEXDEIF EXTRASTAT File Version France. VEA4 RVEXDEIF EXTRASTAT File Version France. VEA5 RVEXDEIF EXTRASTAT File Version France. VEB1 RVEX0. MAB Period end Closings Control. VEB2 RVEX0. MAB Dt. A Special Rule CountriesRegions. VEB5 RMPREF0. 4 Calculate Assemblies Individually. VEB6 RMPREF0. 3 Calculate Assemblies Collectively. VEB9 SAPMSMOD Customer Exits Print Control. VECN MENUVECN Profitability and Sales Accounting. VEFU RVEXVEF1 Foreign Trade Add INTRASTAT Data. VEFUX RVEXVEFU FT GOV Change transaction INTRASTAVEIA RVEXCUSE Create INTRASTAT CUSDEC EDI SEVEIAE RVEXCORA EXTRASTAT Archiving. VEIAI RVEXCORA INTRASTAT Archiving. VEIB RVEXCUPT Create INTRASTAT CUSDEC EDI PTVEIC RVEXCUFI Create INTRASTAT CUSDEC EDI FIVEID RVEXCULU Create INTRASTAT CUSDEC EDI LUVEIV RVEXVEX1 Foreign Trade Add EXTRASTAT Data. VEIW RVEXNAID Create file INTRAEXTRAKOBRAVEIX RVEXNAID Create file INTRAEXTRAKOBRAVEIY RVEXNAID Create file INTRAEXTRAKOBRAVEIZ RVEXNAID Create file INTRAEXTRAKOBRAVEI0 RVEXCUIE Create INTRASTAT CUSDEC EDI IEVEI1 RVEXIDCA Display IDoc Import. VEI2 RVEXIDCA Display IDoc Export. VEI3 SAPMV1. 3A Display Stat. Value Subcontracting. VEI4 RVEXREOR Merge Remaining Commodity Codes. VEI5 SAPMV1. 3A Create value limit subcontracting. VEI6 RSEIDOCD EDI IDoc List Import Basis. VEI7 RVEXCUGB Create INTRASTAT CUSDEC EDI GBVEI8 RVEXCUSA Create INTRASTAT CUSDEC EDI ATVEI9 RVEXCUES Create INTRASTAT CUSDEC EDI ESVEKU RVEXVEKU For. Trade Change KOBRA Documents. VEM4 RVEXREOR Merge EU Commodity Code. VEPR RMPREFDI Customs log. VEU4 RVEXSOVA Load Commodity Code Other Countries. VEU4. X RVEXSOS2 Load Commodity Code Other Countries.