产品物料主数据
Product Integration
SAP_COM_0009
Product Master - Create, Read, Update, Delete
https://api.sap.com/api/API_PRODUCT_SRV/resource
https://my302567-api.s4hana.ondemand.com/sap/opu/odata/sap/API_PRODUCT_SRV
描述description的update方法不行,会报错,直接使用create方法可以实现update的效果
api有一致性检查,有些字段需要在多个视图加,否则可能会被覆盖,参考2928466
会计凭证
读会计凭证
https://api.sap.com/api/API_OPLACCTGDOCITEMCUBE_SRV/resource
注:DebitCreditCode 反过来了(冲销凭证才有问题),可以用posting key处理判断借贷
Read G/L Account
https://api.sap.com/api/API_GLACCOUNTINCHARTOFACCOUNTS_SRV/resource
库存
https://api.sap.com/api/API_MATERIAL_STOCK_SRV/resource
包含批次、特殊库存
物料分类特性 Product Classification Integration
SAP_COM_0309 Product Classification Integration
https://api.sap.com/api/API_CLFN_PRODUCT_SRV/resource
A_ProductCharc:可以读到物料所有的class type 和class 特性(没值的也能读到)
A_ProductCharcValue :可以直接读到物料特性值,有值的特性才在数组中,只能读到 class type = 001(material class)的数据
先用 Product Master Data Including Classification – Read,取到ClassInternalID
根据ClassType判断是物料class还是批次class的特性
SAP_COM_0163 分类和特性主数据
SAP_COM_0163 Class Data for Classification – Create, Read, Update, Delete
1.Class Data for Classification – Create, Read, Update, Delete--这个是class主数据(class对应的特性)
https://api.sap.com/api/API_CLFN_CLASS_SRV/resource
2.Characteristic Data for Classification – Create, Read, Update, Delete--这个是特性主数据,包含特性名称、特性描述、特性类型、特性ID等(产品的和批次的都在里面)
https://api.sap.com/api/API_CLFN_CHARACTERISTIC_SRV/resource
SAP_COM_0337 创建修改物料批次特性值
先读/BatchCharcValue,读到更新,读不到创建
批量写特性写不进去,报错:
create batch charc error:Creating operations are disabled for association '_BATCHCHARC', source entity '$AE_A2X#SRVD#API_BATCH_SRV~A_BATCH';An exception was raised;
只能挨个特性更新
custom cds view
如果要读标准表数据,可以创建custom cds view ,数据源来自标准的custom cds view。标准的和自建的都在 custom cds view这个app里。必须要建YY1的CDS VIEW,不然communication scaneria 加不进去
物料凭证
SAP_COM_0108
Process Material Documents
https://api.sap.com/api/API_MATERIAL_DOCUMENT_SRV/resource
价格
销售价格 crud SAP_COM_0294
Condition Record for Pricing in Sales – Create, Read, Update, Delete
https://api.sap.com/api/API_SLSPRICINGCONDITIONRECORD_SRV/resource
https://my302567-api.s4hana.ondemand.com/sap/opu/odata/sap/API_SLSPRICINGCONDITIONRECORD_SRV
先读 A_SlsPrcgCndnRecdValidity
再读 A_SlsPrcgConditionRecord,注意需要取etag,再更新。更新A_SlsPrcgConditionRecord虽然有参数ConditionValidityStartDate,但是无效,只能更新金额。
直接create可以更新有效期(所以直接create就行,不用read和update了)
采购价格 crud SAP_COM_0294
Condition Record for Pricing in Purchasing – Create, Read, Update, Delete
https://api.sap.com/api/API_PURGPRCGCONDITIONRECORD_SRV/resource
https://my302567-api.s4hana.ondemand.com/sap/opu/odata/sap/API_PURGPRCGCONDITIONRECORD_SRV
创建会计凭证
Finance - Posting Integration (SAP_COM_0002)
Journal Entry - Post (Synchronous)
demo
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:sfin="http://sap.com/xi/SAPSCORE/SFIN">
<soapenv:Header/>
<soapenv:Body>
<sfin:JournalEntryBulkCreateRequest>
<MessageHeader>
<ID>MSG_2019-07-01_APITEST</ID>
<!--<ReferenceID></ReferenceID>-->
<CreationDateTime>2019-07-01T17:00:00.1234567Z</CreationDateTime>
</MessageHeader>
<!--1 or more repetitions:-->
<JournalEntryCreateRequest>
<MessageHeader>
<ID>SUB_MSG_2019-07-01_001</ID>
<!--<ReferenceID></ReferenceID>-->
<CreationDateTime>2019-09-04T16:08:50.811Z</CreationDateTime>
</MessageHeader>
<JournalEntry>
<OriginalReferenceDocumentType>BKPFF</OriginalReferenceDocumentType>
<OriginalReferenceDocument/>
<OriginalReferenceDocumentLogicalSystem/>
<BusinessTransactionType>RFBU</BusinessTransactionType>
<AccountingDocumentType>ZE</AccountingDocumentType>
<DocumentReferenceID/>
<DocumentHeaderText>X</DocumentHeaderText>
<CreatedByUser>CB9980000010</CreatedByUser>
<CompanyCode>6210</CompanyCode>
<DocumentDate>2019-09-05</DocumentDate>
<PostingDate>2019-09-05</PostingDate>
<Item>
<CompanyCode>6210</CompanyCode>
<GLAccount>0052010000</GLAccount>
<AmountInTransactionCurrency currencyCode="HKD">1800.00</AmountInTransactionCurrency>
<DebitCreditCode>S</DebitCreditCode>
<DocumentItemText>Test Item 2</DocumentItemText>
<AccountAssignment>
<CostCenter>6210HK01</CostCenter>
<ProfitCenter>HK01</ProfitCenter>
<WBSElement>621000000008.1.1</WBSElement>
</AccountAssignment>
</Item>
<Item>
<CompanyCode>6210</CompanyCode>
<GLAccount>0012623001</GLAccount>
<AmountInTransactionCurrency currencyCode="HKD">-1800</AmountInTransactionCurrency>
<DebitCreditCode>H</DebitCreditCode>
<DocumentItemText>Test Item 2</DocumentItemText>
<AccountAssignment>
<ProfitCenter>HK01</ProfitCenter>
</AccountAssignment>
</Item>
</JournalEntry>
</JournalEntryCreateRequest>
</sfin:JournalEntryBulkCreateRequest>
</soapenv:Body>
</soapenv:Envelope>
BP CRUD
SAP_COM_0008 API_BUSINESS_PARTNER
开票
note
https://launchpad.support.sap.com/#/notes/2773986
sap help
读取bp信贷额度
SAP_COM_0173 Credit Management Account - Read