SD Transaction code

转自:http://www.sap-img.com/sap-sd/sap-sd-transaction-codes-list.htm

 

The most frequently used transaction codes are as follows:
1. VS00 – Master data
2. VC00 – Sales Support
3. VA00 – Sales
4. VL00 – Shipping
5. VT00 – Transportation
6. VF00 – Billing


Others as follows:

 

At Configuration:
1. VOV8 – Define Sales documents type (header)
2. OVAZ – Assigning Sales area to sales documents type

<!-more->
3. OVAU – Order reasons
4. VOV4 – Assign Item categoreies(Item cat determination)
5. VOV6 – Scedule line categories
6. OVAL – To assign blocks to relevant sales documents type
7. OVLK – Define delivery types
8. V/06 – Pricing
9. V/08 – Maintain pricing procedure
10.OVKP – Pricing proc determination
11.V/07 – Access sequence

 

Enduser:
1. Customer Master Creation-VD01 and XD01 (for full inclu company code)
    VD02 – Change Customer
    VD03 – Display Customer
    VD04 – Customer Account Changes
    VD06 – Flag for Deletion Customer
    XD01 – Create Customer
    XD02 – Modify Customer
    XD03 – Display Customer
2. Create Other material —-MM00
3. VB11- To create material determination condition record
4. CO09- Material availability Overview
5. VL01 – Create outbound delivery with ref sales order
6. VL04 – Collective processing of delivery
7. VA11 – Create Inquiry
    VA12 – Change Inquiry
    VA13 – Display Inquiry

 

Sales & Distribution

 

Sales order / Quote / Sched Agreement / Contract
· VA01 – Create Order
· VA02 – Change Order
· VA03 – Display Order
· VA02 – Sales order change
· VA05 – List of sales orders
· VA32 – Scheduling agreement change
· VA42 – Contract change
· VA21 – Create Quotation
· VA22 – Change Quotation
· VA23 – Display Quotation

 

Billing
· VF02 – Change billing document
· VF11 – Cancel Billing document
· VF04 – Billing due list
· FBL5N – Display Customer invoices by line
· FBL1N – Display Vendor invoices by line

 

Delivery
· VL02N – Change delivery document
· VL04 – Delivery due list
· VKM5 – List of deliveries
· VL06G – List of outbound deliveries for goods issue
· VL06P – List of outbound deliveries for picking
· VL09 – Cancel goods issue
· VT02N – Change shipment
· VT70 – Output for shipments

 

General
· VKM3, VKM4 – List of sales documents
· VKM1 – List of blocked SD documents
· VD52  – Material Determination

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
insert overwrite table discountdw.dwd_sd_adds_order_bill_inc partition(dt = '2023-06-06') select t1.order_bill_id, t1.counterfoil_no, t1.acceptor, date_format(to_utc_timestamp(cast(t1.expiry_date as bigint) ,'GMT-8'),'YYYY-MM-dd'), t2.company_id, t1.cert_no, t1.company_name, t1.third_order_id, t1.counterfoil_amt/10000, t1.transaction_amt/10000, t1.rate, '3bp' as service_tariffing, ((DATEDIFF(to_utc_timestamp(t1.expiry_date ,'GMT-8'),to_utc_timestamp(t1.transaction_date ,'GMT-8') ) + adjust_days)* 0.0003 *(counterfoil_amt))/ 360 as service_fee, 360 as total_days, DATEDIFF(to_utc_timestamp(t1.expiry_date ,'GMT-8'),to_utc_timestamp(t1.transaction_date ,'GMT-8') ) + adjust_days as modulation_date, t3.channel_type, t3.bank_name, date_format(to_utc_timestamp(cast(t1.transaction_date as bigint) ,'GMT-8'),'YYYY-MM-dd'), t1.order_status_code, t1.order_status_msg, t4.fee_amt, t4.status, t1.tenant_id, t5.revenue, to_utc_timestamp(cast(t1.create_date as bigint) ,'GMT-8'), to_utc_timestamp(cast(t1.update_date as bigint) ,'GMT-8') from (select * from discountdw.ods_adds_order_bill_inc where dt ='2023-06-06' and channel_id=101110004 )t1 left join (select * from mecdw.ods_company_full where platform_id='sdpjw')t2 on t1.cert_no=t2.cert_no and t1.tenant_id=t2.tenant_id left join discountdw.dim_adds_product_full t3 on t1.partner_id=t3.partner_id and t1.product_id=t3.product_id left join (select * from mecdw.dwd_sc_fee_record_full where dt='2023-06-06' and biz_type=2 ) t4 on t1.order_bill_id=t4.third_id left join (select * from discountdw.ods_sd_order_ext_inc where dt='2023-06-06') t5 on t1.order_bill_id=t5.order_bill_id left join sdpjwdw.dim_holiday_info_full t6 on date_format(to_utc_timestamp(t1.expiry_date ,'GMT-8'),'YYYY-MM-dd') = t6.civic_holiday ;
06-09
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值