S4 HANA BP 相关表及其对应BP业务操作（一般视图、公司视图、采购视图、销售分销视图）

喜欢ヅ旅行 2023-06-08 03:25 17阅读 0赞

*  **1、BP 一般数据 - BUT000**

创建BP数据时，外部给号，需要校验是否已经存在。如果存在使用系统标准的partner\_guid，

不存在的情况下使用方法类自动生成cl\_system\_uuid=>create\_uuid\_x16\_static( )

data: CS_BPDATA TYPE CVIS_EI_EXTERN.
    
        SELECT SINGLE partner_guid
            INTO @DATA(lv_guid)
            FROM but000
            WHERE partner = @lv_partner.
          IF sy-subrc NE 0 .
            lv_guid = cl_system_uuid=>create_uuid_x16_static( ).
          ENDIF.
    
          cs_bpdata-partner-header-object_instance-bpartnerguid = lv_guid.

*  **2、BP地址 - BUT020**

BP地址数据维护（新建或修改）时，需要基本此表进行相关的判断

DATA:
          ls_addr  TYPE bus_ei_bupa_address.
    
          SELECT SINGLE address_guid
            INTO @DATA(lv_addrguid)
            FROM but020
            WHERE partner = @cs_bpdata-partner-header-object_instance-bpartner.
          ls_addr-data_key-guid = lv_addrguid.

如果存在则获取原地址的addrguid，实现对应存在地址的更新

没有查询到地址数据的情况下，ls\_addr-data\_key-guid没有值，系统自动生成一个新的addrguid

*  **3、BP 角色 - BUT100**

存放BP数据对应的角色数据，常用角色如下:

客户角色：FLCU00 / FLCU01

供应商角色：FLVN00 / FLVN01

![20191016092314861.jpg][]

FLCU00角色中创建客户的公司代码数据

![20191016092914105.jpg][]

FLCU01角色中创建客户的销售和分销数据

![20191016092949822.jpg][]

一般通过如下代码校验客商的角色是否存在

data: ls_role   TYPE bus_ei_bupa_roles,
                CS_BPDATA TYPE CVIS_EI_EXTERN.
    "检查角色是否已经存在
          SELECT COUNT(*)
            FROM but100
            WHERE partner = is_data-partner
            AND   rltyp   = 'FLVN00'.
          IF sy-subrc NE 0.
            CLEAR ls_role.
            ls_role-task            = 'I'.
            "供应商（公司代码）
            ls_role-data_key        = cn_role_flvn00.
            ls_role-data-valid_from = sy-datum.
            ls_role-data-valid_to   = '99991231'.
            APPEND ls_role TO cs_bpdata-partner-central_data-role-roles.
          ENDIF.

*  **4、BP 银行明细 - BUT0BK**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmdsZWk4ODA1MjY_size_16_color_FFFFFF_t_70][]

*  **5、供应商公司视图 ：LFB1**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmdsZWk4ODA1MjY_size_16_color_FFFFFF_t_70 1][]

*  **6、供应商采购视图：LFM1**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmdsZWk4ODA1MjY_size_16_color_FFFFFF_t_70 2][]

*  **7、客户公司视图 ：KNB1**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmdsZWk4ODA1MjY_size_16_color_FFFFFF_t_70 3][]

*  **8、客户销售和分销视图：KNVV**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmdsZWk4ODA1MjY_size_16_color_FFFFFF_t_70 4][]

*  **9、BP销售和分销视图：销项税 - KNVI**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmdsZWk4ODA1MjY_size_16_color_FFFFFF_t_70 5][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmdsZWk4ODA1MjY_size_16_color_FFFFFF_t_70 6][]

BP 维护参数位置CVIS\_EI\_EXTERN -> CUSTOMER->CENTRAL\_DATA->TAX\_IND

*  **10、标识：税号 - DFKKBPTAXNUM**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmdsZWk4ODA1MjY_size_16_color_FFFFFF_t_70 7][]

![20201225163847587.jpg][]

[20191016092314861.jpg]: /images/20230531/13623a5d128b4fcea6dae7eccf06c84f.png
[20191016092914105.jpg]: /images/20230531/9d75b06052244a6da0247fd7646b99ef.png
[20191016092949822.jpg]: /images/20230531/998c2ec72536408e832f1ef22eae1bea.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmdsZWk4ODA1MjY_size_16_color_FFFFFF_t_70]: /images/20230531/055122c2820b4201a51cb878907c4cf0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmdsZWk4ODA1MjY_size_16_color_FFFFFF_t_70 1]: /images/20230531/defbe446a5be4452bb5d39e071c835cf.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmdsZWk4ODA1MjY_size_16_color_FFFFFF_t_70 2]: /images/20230531/b19c28ab7057460c85a02c9175dfec56.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmdsZWk4ODA1MjY_size_16_color_FFFFFF_t_70 3]: /images/20230531/a36df767694d4c9c811323e25ce21c80.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmdsZWk4ODA1MjY_size_16_color_FFFFFF_t_70 4]: /images/20230531/e07c3d15bd0e453dba0a453cf15a200a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmdsZWk4ODA1MjY_size_16_color_FFFFFF_t_70 5]: /images/20230531/7f4bdba75ece4fb599b0bc3603fe511a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmdsZWk4ODA1MjY_size_16_color_FFFFFF_t_70 6]: /images/20230531/a560074614504692807ab726b6683cc1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmdsZWk4ODA1MjY_size_16_color_FFFFFF_t_70 7]: /images/20230531/5867b619db41410faba28ca2c1e6b409.png
[20201225163847587.jpg]: /images/20230531/4a57468c11b64c9c8b53b94d348b95af.png