_PAYMENTPROPOSALHEADER
_PAYMENTPROPOSALHEADER is an SAP database table in S/4HANA. It contains 61 fields.
Fields (61)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| AccountingClerk | AccountingClerk | 1 | |
| AddressID | AddressID | 1 | |
| BankAccountHolderName | BankAccountHolderName | 1 | |
| BankChainBank1ControlKey | BankChainBank1ControlKey | 1 | |
| BankChainBank1DetailReference | BankChainBank1DetailReference | 1 | |
| BankChainBank2ControlKey | BankChainBank2ControlKey | 1 | |
| BankChainBank2DetailReference | BankChainBank2DetailReference | 1 | |
| BankChainBank3ControlKey | BankChainBank3ControlKey | 1 | |
| BankChainBank3DetailReference | BankChainBank3DetailReference | 1 | |
| BankControlKey | BankControlKey | 1 | |
| BankInternalID | BankInternalID | 1 | |
| BankPaymentGroupingOrigin | BankPaymentGroupingOrigin | 1 | |
| BillOfExchangeIssueDate | BillOfExchangeIssueDate | 1 | |
| BusinessArea | BusinessArea | 1 | |
| BusinessPlace | BusinessPlace | 1 | |
| Country | Country | 1 | |
| CustomerAdditionalName | CustomerAdditionalName | 1 | |
| DataExchangeInstruction1 | DataExchangeInstruction1 | 1 | |
| DataExchangeInstruction2 | DataExchangeInstruction2 | 1 | |
| DataExchangeInstruction3 | DataExchangeInstruction3 | 1 | |
| DataExchangeInstruction4 | DataExchangeInstruction4 | 1 | |
| DataExchangeInstructionKey | DataExchangeInstructionKey | 1 | |
| DirectDebitType | DirectDebitType | 1 | |
| District | District | 1 | |
| EDIPaymentAdviceStatus | EDIPaymentAdviceStatus | 1 | |
| EDIPaymentOrderStatus | EDIPaymentOrderStatus | 1 | |
| ExchangeRate | ExchangeRate | 1 | |
| FunctionalCurrency | FunctionalCurrency | 1 | |
| HouseBank | HouseBank | 1 | |
| HouseBankAccount | HouseBankAccount | 2 | |
| LostCashDiscountInCoCodeCrcy | LostCashDiscountInCoCodeCrcy | 1 | |
| LostCashDiscountInTransacCrcy | LostCashDiscountInTransacCrcy | 1 | |
| NumberOfPaidItems | NumberOfPaidItems | 1 | |
| NumberOfTextLines | NumberOfTextLines | 1 | |
| PayeeBankCountry | PayeeBankCountry | 1 | |
| PayeeLanguage | PayeeLanguage | 1 | |
| PayeePaymentSystem | PayeePaymentSystem | 1 | |
| PayeePOBox | PayeePOBox | 1 | |
| PayeePOBoxPostalCode | PayeePOBoxPostalCode | 1 | |
| PayeePostalCode | PayeePostalCode | 1 | |
| PayeeTitle | PayeeTitle | 1 | |
| PaymentMethod | PaymentMethod | 2 | |
| PaymentReason | PaymentReason | 1 | |
| PaymentRequestPaymentGroup | PaymentRequestPaymentGroup | 1 | |
| PaymentRunIsProposal | PaymentRunIsProposal | 1 | |
| PersonnelNumber | PersonnelNumber | 1 | |
| POBox | POBox | 1 | |
| POBoxDeviatingCityName | POBoxDeviatingCityName | 1 | |
| POBoxPostalCode | POBoxPostalCode | 1 | |
| PostalCode | PostalCode | 1 | |
| PostingDate | PostingDate | 3 | |
| Region | Region | 1 | |
| SendingCompanyCode | SendingCompanyCode | 1 | |
| SEPAMandateUUID | SEPAMandateUUID | 1 | |
| SEPASequenceType | SEPASequenceType | 1 | |
| StreetAddressName | StreetAddressName | 1 | |
| SupplierAdditionalName | SupplierAdditionalName | 1 | |
| SupplierCityName | SupplierCityName | 1 | |
| SupplierClerkIDBySupplier | SupplierClerkIDBySupplier | 1 | |
| SupplierCountry | SupplierCountry | 1 | |
| SWIFTTransactionReferenceUUID | SWIFTTransactionReferenceUUID | 2 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _PAYMENTPROPOSALHEADER (
ACCOUNTINGCLERK,
ADDRESSID,
BANKACCOUNTHOLDERNAME,
BANKCHAINBANK1CONTROLKEY,
BANKCHAINBANK1DETAILREFERENCE,
BANKCHAINBANK2CONTROLKEY,
BANKCHAINBANK2DETAILREFERENCE,
BANKCHAINBANK3CONTROLKEY,
BANKCHAINBANK3DETAILREFERENCE,
BANKCONTROLKEY,
BANKINTERNALID,
BANKPAYMENTGROUPINGORIGIN,
BILLOFEXCHANGEISSUEDATE,
BUSINESSAREA,
BUSINESSPLACE,
COUNTRY,
CUSTOMERADDITIONALNAME,
DATAEXCHANGEINSTRUCTION1,
DATAEXCHANGEINSTRUCTION2,
DATAEXCHANGEINSTRUCTION3,
DATAEXCHANGEINSTRUCTION4,
DATAEXCHANGEINSTRUCTIONKEY,
DIRECTDEBITTYPE,
DISTRICT,
EDIPAYMENTADVICESTATUS,
EDIPAYMENTORDERSTATUS,
EXCHANGERATE,
FUNCTIONALCURRENCY,
HOUSEBANK,
HOUSEBANKACCOUNT,
LOSTCASHDISCOUNTINCOCODECRCY,
LOSTCASHDISCOUNTINTRANSACCRCY,
NUMBEROFPAIDITEMS,
NUMBEROFTEXTLINES,
PAYEEBANKCOUNTRY,
PAYEELANGUAGE,
PAYEEPAYMENTSYSTEM,
PAYEEPOBOX,
PAYEEPOBOXPOSTALCODE,
PAYEEPOSTALCODE,
PAYEETITLE,
PAYMENTMETHOD,
PAYMENTREASON,
PAYMENTREQUESTPAYMENTGROUP,
PAYMENTRUNISPROPOSAL,
PERSONNELNUMBER,
POBOX,
POBOXDEVIATINGCITYNAME,
POBOXPOSTALCODE,
POSTALCODE,
POSTINGDATE,
REGION,
SENDINGCOMPANYCODE,
SEPAMANDATEUUID,
SEPASEQUENCETYPE,
STREETADDRESSNAME,
SUPPLIERADDITIONALNAME,
SUPPLIERCITYNAME,
SUPPLIERCLERKIDBYSUPPLIER,
SUPPLIERCOUNTRY,
SWIFTTRANSACTIONREFERENCEUUID
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA