• State Verified Answer
  • Locked Locked
  • Replies 5 replies
  • Answers 1 answer
  • Subscribers 93 subscribers
  • Views 12459 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to use RFC_READ_TABLE BAPI function in Quick Connect for SAP 2.2?

hector.jimenez
over 10 years ago

I need to read custom tables created in a SAP HR system, I read the QC SAP 2.2 Quick Start Guide and found that there is a BAPI Function for the Quick Connect SAP solution. Is there any documentation that explains how to configure/use this RFC_READ_TABLE BAPI?

Parents
  • 0 over 10 years ago

    This has been solved (thanks Reto), basically for a table named ZTHR_IAMORGUNIT with 4 fields, the entry in SAPMetaData.xml is the following. Now, this is something I tested and worked, and it might be wrong or not the correct way to do it as there is no documentation for this. Hope it helps out.

    <sapType name="SAP HR Org Unit">

        <operations>

            <operation name="Get" enumerator="GetOrgUnits">

              <attributes>

         <attribute name="Id" displayName="Organisational Unit">

                  <attributeBinding bindingType="outerParameter" sourceCall="GetOrgUnits2" bindTo="OrgUnit_Token1"/>

                </attribute>

                <attribute name="Country">

                  <attributeBinding bindingType="outerParameter" sourceCall="GetOrgUnits2" bindTo="OrgUnit_Token0"/>

                </attribute>

                <attribute name="Burks" displayName="Company Code">

                  <attributeBinding bindingType="outerParameter" sourceCall="GetOrgUnits2" bindTo="OrgUnit_Token2"/>

                </attribute>

                <attribute name="Name" displayName="Name of Org Unit">

                  <attributeBinding bindingType="outerParameter" sourceCall="GetOrgUnits2" bindTo="OrgUnit_Token3"/>

                </attribute>

              </attributes>

          <calls>

            <call name="GetOrgUnits" callType="complex">

             <inputParameters>

                    <inputParameter name="dummy">

                      <parameterBinding bindingType="value" bindTo="dummy"/>

                    </inputParameter>

                  </inputParameters>

      <outputParameters>

                    <outputParameter name="OrgUnits">

                      <parameterBinding bindingType="outerParameter" sourceCall="GetOrgUnit_DATA" bindTo="DATA"/>

                    </outputParameter>

                  </outputParameters>

                  <calls>

                    <call name="GetOrgUnit_DATA" nativeName="RFC_READ_TABLE" callType="bapi">

                      <inputParameters>

                        <inputParameter name="QUERY_TABLE">

                          <parameterBinding bindingType="value" bindTo="ZTHR_IAMORGUNIT"/>

                        </inputParameter>

                        <inputParameter name="DELIMITER">

                          <parameterBinding bindingType="value" bindTo=";"/>

                        </inputParameter>

                        <inputParameter name="NO_DATA">

                          <parameterBinding bindingType="value" bindTo=""/>

                        </inputParameter>

                        <inputParameter name="ROWSKIPS">

                          <parameterBinding bindingType="value" bindTo="0"/>

                        </inputParameter>

                        <inputParameter name="ROWCOUNT">

                          <parameterBinding bindingType="value" bindTo="0"/>

                        </inputParameter>

      <inputParameter name="OPTIONS" type="table">

                        </inputParameter>

                        <inputParameter name="FIELDS" type="table">

                          <parameterBinding field="FIELDNAME" bindingType="value" bindTo="COUNTRY"/>

      <parameterBinding field="FIELDNAME" bindingType="value" bindTo="ORG_UNIT"/>

                            <parameterBinding field="FIELDNAME" bindingType="value" bindTo="BUKRS"/>

      <parameterBinding field="FIELDNAME" bindingType="value" bindTo="NAMEOFORGUNIT"/>

                        </inputParameter>

                      </inputParameters>

                      <outputParameters>

                        <outputParameter name="DATA" type="table">

                        </outputParameter>

                      </outputParameters>

                    </call>

                  </calls>

                </call>

                <call name="GetOrgUnits2" callType="complex">

                  <inputParameters>

                    <inputParameter name="Input">

                      <parameterBinding bindingType="outerParameter" sourceCall="GetOrgUnits" bindTo="OrgUnits.WA"/>

                    </inputParameter>

                  </inputParameters>

                  <outputParameters>

                    <outputParameter name="OrgUnit_Token0">

                      <parameterBinding bindingType="outerParameter" sourceCall="GetOrgUnits" bindTo="OrgUnits.WA"/>

                      <dataHelper helperType="parseStringResult" delimeter=";" position="3"/>

                    </outputParameter>

                    <outputParameter name="OrgUnit_Token1">

                      <parameterBinding bindingType="outerParameter" sourceCall="GetOrgUnits" bindTo="OrgUnits.WA"/>

                      <dataHelper helperType="parseStringResult" delimeter=";" position="2"/>

                    </outputParameter>

      <outputParameter name="OrgUnit_Token2">

                      <parameterBinding bindingType="outerParameter" sourceCall="GetOrgUnits" bindTo="OrgUnits.WA"/>

                      <dataHelper helperType="parseStringResult" delimeter=";" position="1"/>

                    </outputParameter>

                    <outputParameter name="OrgUnit_Token3">

                      <parameterBinding bindingType="outerParameter" sourceCall="GetOrgUnits" bindTo="OrgUnits.WA"/>

                      <dataHelper helperType="parseStringResult" delimeter=";" position="0"/>

                    </outputParameter>

                  </outputParameters>

                </call>

    </calls>

            </operation>

        </operations>

    </sapType>

Reply
  • 0 over 10 years ago

    This has been solved (thanks Reto), basically for a table named ZTHR_IAMORGUNIT with 4 fields, the entry in SAPMetaData.xml is the following. Now, this is something I tested and worked, and it might be wrong or not the correct way to do it as there is no documentation for this. Hope it helps out.

    <sapType name="SAP HR Org Unit">

        <operations>

            <operation name="Get" enumerator="GetOrgUnits">

              <attributes>

         <attribute name="Id" displayName="Organisational Unit">

                  <attributeBinding bindingType="outerParameter" sourceCall="GetOrgUnits2" bindTo="OrgUnit_Token1"/>

                </attribute>

                <attribute name="Country">

                  <attributeBinding bindingType="outerParameter" sourceCall="GetOrgUnits2" bindTo="OrgUnit_Token0"/>

                </attribute>

                <attribute name="Burks" displayName="Company Code">

                  <attributeBinding bindingType="outerParameter" sourceCall="GetOrgUnits2" bindTo="OrgUnit_Token2"/>

                </attribute>

                <attribute name="Name" displayName="Name of Org Unit">

                  <attributeBinding bindingType="outerParameter" sourceCall="GetOrgUnits2" bindTo="OrgUnit_Token3"/>

                </attribute>

              </attributes>

          <calls>

            <call name="GetOrgUnits" callType="complex">

             <inputParameters>

                    <inputParameter name="dummy">

                      <parameterBinding bindingType="value" bindTo="dummy"/>

                    </inputParameter>

                  </inputParameters>

      <outputParameters>

                    <outputParameter name="OrgUnits">

                      <parameterBinding bindingType="outerParameter" sourceCall="GetOrgUnit_DATA" bindTo="DATA"/>

                    </outputParameter>

                  </outputParameters>

                  <calls>

                    <call name="GetOrgUnit_DATA" nativeName="RFC_READ_TABLE" callType="bapi">

                      <inputParameters>

                        <inputParameter name="QUERY_TABLE">

                          <parameterBinding bindingType="value" bindTo="ZTHR_IAMORGUNIT"/>

                        </inputParameter>

                        <inputParameter name="DELIMITER">

                          <parameterBinding bindingType="value" bindTo=";"/>

                        </inputParameter>

                        <inputParameter name="NO_DATA">

                          <parameterBinding bindingType="value" bindTo=""/>

                        </inputParameter>

                        <inputParameter name="ROWSKIPS">

                          <parameterBinding bindingType="value" bindTo="0"/>

                        </inputParameter>

                        <inputParameter name="ROWCOUNT">

                          <parameterBinding bindingType="value" bindTo="0"/>

                        </inputParameter>

      <inputParameter name="OPTIONS" type="table">

                        </inputParameter>

                        <inputParameter name="FIELDS" type="table">

                          <parameterBinding field="FIELDNAME" bindingType="value" bindTo="COUNTRY"/>

      <parameterBinding field="FIELDNAME" bindingType="value" bindTo="ORG_UNIT"/>

                            <parameterBinding field="FIELDNAME" bindingType="value" bindTo="BUKRS"/>

      <parameterBinding field="FIELDNAME" bindingType="value" bindTo="NAMEOFORGUNIT"/>

                        </inputParameter>

                      </inputParameters>

                      <outputParameters>

                        <outputParameter name="DATA" type="table">

                        </outputParameter>

                      </outputParameters>

                    </call>

                  </calls>

                </call>

                <call name="GetOrgUnits2" callType="complex">

                  <inputParameters>

                    <inputParameter name="Input">

                      <parameterBinding bindingType="outerParameter" sourceCall="GetOrgUnits" bindTo="OrgUnits.WA"/>

                    </inputParameter>

                  </inputParameters>

                  <outputParameters>

                    <outputParameter name="OrgUnit_Token0">

                      <parameterBinding bindingType="outerParameter" sourceCall="GetOrgUnits" bindTo="OrgUnits.WA"/>

                      <dataHelper helperType="parseStringResult" delimeter=";" position="3"/>

                    </outputParameter>

                    <outputParameter name="OrgUnit_Token1">

                      <parameterBinding bindingType="outerParameter" sourceCall="GetOrgUnits" bindTo="OrgUnits.WA"/>

                      <dataHelper helperType="parseStringResult" delimeter=";" position="2"/>

                    </outputParameter>

      <outputParameter name="OrgUnit_Token2">

                      <parameterBinding bindingType="outerParameter" sourceCall="GetOrgUnits" bindTo="OrgUnits.WA"/>

                      <dataHelper helperType="parseStringResult" delimeter=";" position="1"/>

                    </outputParameter>

                    <outputParameter name="OrgUnit_Token3">

                      <parameterBinding bindingType="outerParameter" sourceCall="GetOrgUnits" bindTo="OrgUnits.WA"/>

                      <dataHelper helperType="parseStringResult" delimeter=";" position="0"/>

                    </outputParameter>

                  </outputParameters>

                </call>

    </calls>

            </operation>

        </operations>

    </sapType>

Children
No Data